: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

• san1901

  Old Hand

  Points: 359

  More actions

  May 12, 2010 at 8:47 am

  #138922

  Hi All:

  I have a Windows Server 2003 with IIS and SQL Server 2000 running together. The front-end of the application were created using ASP/ADO (VBScript). The back-end is in SQL. The connection is made using ODBC.

  I also have a new Windows Server 2008 (datacenter) with SQL Server 2008. I moved the database in question to the new server without a problem (please note that I belongs to the domain admin group and I have admin rights to both SQLs Servers.)

  When I change the configuration of the ODBC to the new location of the database (SQL Server 2008), I get the following message on the Intranet web page:

  Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  Source: Microsoft OLE DB Provider for ODBC Drivers

  SQLState: 28000

  NativeError: 18456

  What I want to do is to connect using the domain account like before at Server 2003/SQL 2000 instead of having to use AUTHORITY\ANONYMOUS. The rights on the SQL server are not the problem because I have admin rights; also, I have admin rights for any domain resources (including IIS.) Why the computer uses ANONYMOUS instead of my domain account? The IIS is the same that I have been using from the beginning at the Windows Server 2003. I just moved the database to a new SQL Server and the rights to the database are the same as in the old one.

  Are there any suggestions how to solve this problem?

  Thank you all.