Friday, March 9, 2012

IIS6 connect to sql server on another machine w/windows authentication

Can someone point me at an article that tells how to allow theASP.net worker process to connect, via windows authentication, to aremote sql server instance ?

Start with:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000008.asp

The remote server access is in the connection string, specifying server and instance.

Jeff

|||

Also make sure remote connections enabled on the remote SQL instnace. Check this KB:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

No comments:

Post a Comment