Pass Integrated Windows credentials to SQL Server w/out Basic Authentication?
Posted on 2005-05-02
Using ASP legacy (not .NET), IIS 6 on Win 2003, SQL is on a different server.
When I turn on Basic Authentication for the site, and enter my Windows Active Directory user credentials, the database connection works. When I turn on Integrated Windows Authentication (even leaving Basic enabled), it tries to use NT AUTHORITY\ANONYMOUS LOGON and fails.
Is there anyway around this? I want it to just work, without having to type in credentials for the user account I'm already logged in as.
My connection string is:
"Provider=SQLOLEDB;Data Source=<server>;Initial Catalog=<database>;Integrated Security=SSPI"