Maybe I did not explain myself very clear. Here you have a better description of the problem:
Server1: Windows Server 2003 with IIS and SQL Server 2000 running together. An ODBC connection is used to connect the pages on the IIS to the database in SQL. IIS, ODBC and SQL server are using Windows authentication (Anonymous is disable in the IIS.) The ODBC verify the authenticity of the login ID with Windows NT authentication using the network login ID.
Server 2: Windows Server 2008 (Datacenter), SQL Server 2008. Even thought, I installed IIS in this server, I do not use it for anything else but Reporting Services. IIS is in a default configuration.
Here it is the change I am trying to accomplish:
1. A moved the database from Server 1 (SQL 2000) to Server 2 (SQL 2008). No problems so far. I can access the data in both servers without any problem and run all store procedures, etc., etc. using the SQL Management Studio.
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
On Error Resume Next
Set oConn = Server.CreateObject("ADODB.Connection")
Set oRSz = Server.CreateObject("ADODB.RecordSet")
Thank you all.
Look at the SQL 2008 box's security. is it set to Windows Auth or mixed?
You should also look at the web apps config...
It doesn't look like the app is getting the users credentials
answered Jun 11 '10 at 04:01 PM
Are the two SQL servers in the same domain? If not, is there a trust relationship between the domains to which they belong?
answered May 12 '10 at 04:24 PM
Matt Whitfield ♦♦