Connectin ASP.NET to SQL Server 2000, Problem.

Hi
Is there any settings that I must configure to connect an ASP.NET to SQL
Server 2000?
If there is please tell me.
Thanks in advance
Mohammad-Reza Taikandi
You may want to review this;
http://msdn.microsoft.com/library/de...us/dnnetsec/ht
ml/secnetlpMSDN.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thanks kevin
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:c4gQP66NEHA.3564@.cpmsftngxa10.phx.gbl...
> You may want to review this;
>
http://msdn.microsoft.com/library/de...us/dnnetsec/ht
> ml/secnetlpMSDN.asp
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

Connectin ASP.NET to SQL Server 2000, Problem.

Hi
Is there any settings that I must configure to connect an ASP.NET to SQL
Server 2000?
If there is please tell me.
Thanks in advance
Mohammad-Reza TaikandiYou may want to review this;
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/secnetlpMSDN.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks kevin
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:c4gQP66NEHA.3564@.cpmsftngxa10.phx.gbl...
> You may want to review this;
>
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
> ml/secnetlpMSDN.asp
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

Connect to SQL Server dialog

Hi,
Is it possible to avoid the last used server being in Query Analyzer
'Connect to SQL Server' dialog by default(when I click on File/Connect
in Query Analyzer) - I don't want to apply 'truncate table' scripts to
a production server by mistake!
Thanks<polinaskulski@.aol.com> wrote in message
news:1120572207.464620.272820@.g49g2000cwa.googlegr oups.com...
> Hi,
> Is it possible to avoid the last used server being in Query Analyzer
> 'Connect to SQL Server' dialog by default(when I click on File/Connect
> in Query Analyzer) - I don't want to apply 'truncate table' scripts to
> a production server by mistake!
> Thanks

I don't think that's possible - if you're concerned about running scripts in
the wrong place, then you can reference @.@.SERVERNAME in your scripts, or
always begin a transaction and require a manual COMMIT or ROLLBACK. Another
option is to use a dedicated administrator account for deployments to
production servers.

But all those approaches have drawbacks as well, and in the end there's no
catch-all substitute for being careful about what you're doing.

Simon