prakaash2109

Just another WordPress.com site

AFTER DATABASE MIGRATION FROM SQL 2005 TO SQL 2008 CLUSTER SERVER, ERROR & SOLUTION

on August 17, 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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: