I am experiencing AUTHENTICATION problems which is due to the fact that the SQL server and the IIS server are on two different NT machines.
I have Challenge/Response authentication method setup for the first page of my Intranet web site (which does not have the call to the database) and then once the user is allowed access to the first page, I want to access the SQL Server through the next pages using anonymous authentication. Here is my connection string from my .asp page: MyConn.Open “Provider=SQLOLEDB; Data Source=lzsql2k01; Initial Catalog=cbstest; Integrated Security=SSPI;”
I keep getting the same error: Login failed for user ‘NG AUTHORITY\ANONYMOUS LOGON”
Both the IIS server and the SQL Server 2000 are running on seperate Win2000 servers. How do I setup SQL Server to accept anonymous logins and how do I code my connection string in my asp code?
Please and thanks,