trusted connection

[bigDWK]

Hi-
Is it possible to do a trusted connection for a web server not on
the same physical machine. By this I mean can I make a remote
connection from a web server to a sql server using a trusted connection.
If so, how?

Thanks,
Dave

[Simon Hayes]

"bigDWK" <ne*******@davewking.com> wrote in message
news:e2R9b.478302$YN5.326092@sccrnsc01...

Hi-
Is it possible to do a trusted connection for a web server not on
the same physical machine. By this I mean can I make a remote
connection from a web server to a sql server using a trusted connection.
If so, how?

Thanks,
Dave

One of these links may help, assuming you're using IIS/ASP (you didn't
mention your web server):

http://support.microsoft.com/default...b;EN-US;176379
http://support.microsoft.com/default...b;EN-US;176377

Simon

[bigDWK]

Thanks for the Reply. I'm using Windows 2003 Web with IIS 6 and
Windows 2003 Enterprise with MS SQL Server 2000. Both have the most
up to date patches and service releases. Basically what I'm trying to
do is from the Web Server Box to the SQL Box without putting the
username and password in my ASP code. I read somewhere that this is
bad and should be avoided. It said to use a trusted connection
instead. Any ideas on how to do this?

Thanks

"Simon Hayes" <sq*@hayes.ch> wrote in message news:<3f**********@news.bluewin.ch>...

"bigDWK" <ne*******@davewking.com> wrote in message
news:e2R9b.478302$YN5.326092@sccrnsc01...

Hi-
Is it possible to do a trusted connection for a web server not on
the same physical machine. By this I mean can I make a remote
connection from a web server to a sql server using a trusted connection.
If so, how?

Thanks,
Dave

One of these links may help, assuming you're using IIS/ASP (you didn't
mention your web server):

http://support.microsoft.com/default...b;EN-US;176379
http://support.microsoft.com/default...b;EN-US;176377

Simon