After database migration from sql 2005 to sql 2008 Cluster server, we are getting following error.
-
Wednesday, February 22, 2012 6:58 AM
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.
prakash
All Replies
-
Wednesday, February 22, 2012 7:14 AM
Is your issue related to Configuration Manager 2007 ? if no, so it is better to post on SQL forums.
Bechir Gharbi | http://myitforum.com/myitforumwp/community/members/bgharbi/ | Time zone : GMT+1
-
Wednesday, February 22, 2012 7:24 AMThis is related to SCCM 2007 sp2,
prakash
-
Wednesday, February 22, 2012 7:30 AM ok, in this case start to look this link http://blogs.technet.com/b/configurationmgr/archive/2011/05/24/configmgr-2007-fix-unable-to-connect-to-site-database-after-it-s-moved-to-a-failover-cluster.aspx
Bechir Gharbi | http://myitforum.com/myitforumwp/community/members/bgharbi/ | Time zone : GMT+1
- Proposed As Answer by Torsten [MVP]MVP Thursday, February 23, 2012 7:36 AM
-
Wednesday, February 22, 2012 9:30 AM
Hi,
Usually this problem relates to service principal names being incorrect or not set at all. Check those out.
Dean
- Proposed As Answer by Torsten [MVP]MVP Thursday, February 23, 2012 7:36 AM
- Marked As Answer by Moiz Rassiwala[MSFT]Microsoft Employee, Moderator Thursday, February 23, 2012 6:11 PM
-
Thursday, February 23, 2012 5:00 AMThanks for all your replies, issue is resolved now,
prakash
-
Friday, February 24, 2012 8:31 AMThanks for the link Bechir, it solves the same problem for me like Dean.
- Edited by Jones MCSA Friday, February 24, 2012 8:33 AM
.png)
