I have SQL Server 7 installed on Windows 2000 (MYSQLSERVER). I have setup Windows NT access to my SQL Server for my network logon (MYDOMAIN\MYLOGIN). I have created a corresponding user for a database on the server and given it access to the necessary tables, procs, etc. The server does allow both Windows NT Authentication and Standard SQL Authentication.
I have IIS 5 running under Windows 2000 (seperate machine). I have Integrated Windows Authentication enabled and Anonymous access DISABLED. I also have Basic authentication checked (is this necessary?) with default domain set (MYDOMAIN).
My ASP has a connection string of “PROVIDER=SQLOLEDB;DATA SOURCE=MYSQLSERVER;trusted connection=YES;Integrated Security=SSPI”. I then run a simply query against one table. I get the error: “Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.” If I leave off the “Integrated Security=SSPI” from my connection string I get this error: “Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user ‘MYLOGIN’.” Both occur if I turn off Basic Authentication, so that is not it.
Can someone tell me what we are doing wrong? Any help would be greatly appreciated.
Thanks.
