Thursday, March 15, 2012

After database migration from sql 2005 to sql 2008 Cluster server, we are getting following error.



ERROR : 
2012-02-21 19:46:00.110 Logon        Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 172.16.28.114]
2012-02-21 19:46:01.780 Logon        Error: 18456, Severity: 14, State: 11.
ERROR 2 : 
CTriggerManager::Init - unable to get SQL connection
*** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
*** Failed to connect to the SQL Server.
Solution : 
CMD -> run -> odbcad32 -> go to System DSN -> configure new database server here -> configuration -> client configuration -> Network libraries -> set to Named Pipes

No comments:

Post a Comment