Link to home
Start Free TrialLog in
Avatar of SA-mattman
SA-mattman

asked on

Can't connect to SCCM console after moving SQL database

Hello All,

A DBA and I have been racking our brains for a couple days now
after moving the  SCCM SQL database from the primary site server to a
sql server.   We can no longer open the SCCM console. The SQL
server and SCCM log files are getting anonymous login messages.

We're having no luck resolving it..  going to post what we've
done with the log files.  Any help is greatly appreciated.
Servers have been replaced with fake data..

Primary Site Server:  SCCMXYZ
New SQL Server:  SQLTST01
Instance and Database:  T2\SCCMDB
Service Account:  SCCMSA
SPN info: (manually created)
SCCMSA:      MSSQSvc/SQLTST01.domain.lan:5050
                      MSSQSvc/SQLTST01:5050
SQLTST01:    MSSQSvc/SQLTST01.domain.lan:5050
                       MSSQSvc/SQLTST01:5050  

We've done the correct procedure.  
1) Added SCCMXYZ machine account to SQLTST01's local administrator group.
 rebooted both servers.
2) We backed up SQL database and restored onto new server
3) SCCMXYZ and SCCMSA both have rights to DB on new server
4) We logged into SCCMXYZ with the SCCMSA service account
5) We used "preinst.exe /stopsites" to stop the component site
services.  All stopped fine except SQL monitor.  No service is
found for that..
6) We used the setup.exe to change to the new sql server.  Used
SQLTST01\T2 for server and instance.  Used SCCMDB for database.
It processed everything fine..
7) Rebooted


DBA watched his logs while it was processing changes and he got
some messages showing the service account connnecting and quite
a few anonymous connection messages.
Once server (SCCMXYZ) was rebooted, I tried logging into the console.  
It opens the console but hangs and never connects to the
databse.  

Logs:

SMSAdminUI.Log


[6][4/5/2011 8:49:22 AM]

:Microsoft.ConfigurationManagement.ManagementProvider.SmsConnectionException\r\nThe ConfigMgr console could not connect to the ConfigMgr site database. Verify that this computer has network  connectivity to the SMS Provider computer and that your user account has Remote Activation permissions on both the ConfigMgr site server and SMS Provider computers. For more information, see "How to Configure DCOM Permissions for Configuration Manager Console Connections" in ConfigMgr Help.\r\n   at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String
connectionManagerInstance)
   at

Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.BuildTreeWorker()\r\nThe ConfigMgr Provider reported an error.
\r\nMicrosoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe ConfigMgr Provider reported an error.\r\n   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()
   at
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.Connect(String configMgrServerPath)
   at
Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String
connectionManagerInstance)\r\nConfigMgr Error Object:instance of __ExtendedStatus
{
      Operation = "ExecQuery";
      ParameterInfo = "SELECT * FROM SMS_Site WHERE
ReportingSiteCode = ''";
      ProviderName = "WinMgmt";
};

Error Code:
ProviderLoadFailure
\r\nSystem.Management.ManagementException\r\nProvider load

failure \r\n   at

System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at
System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
   at
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
      Operation = "ExecQuery";

Distmgr.log (getting a lot of these type of messages in other logs)

VerifyContentPackages: thread started      

SMS_DISTRIBUTION_MANAGER      4/6/2011 1:57:49 PM      5208

(0x1458)
*** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.      

SMS_DISTRIBUTION_MANAGER      4/6/2011 1:57:49 PM      5208

(0x1458)
*** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.      

SMS_DISTRIBUTION_MANAGER      4/6/2011 1:57:49 PM      5208

(0x1458)
*** Failed to connect to the SQL Server.      

SMS_DISTRIBUTION_MANAGER      4/6/2011 1:57:49 PM      5208

(0x1458)
VerifyContentPackages: error: Cannot get SQL connection      

SMS_DISTRIBUTION_MANAGER      4/6/2011 1:57:49 PM      5208

(0x1458)

We move the database back to the original server and the
console works fine.  Everything seems to run just fine.

Avatar of Abdul Jalil Abou Alzahab
Abdul Jalil Abou Alzahab
Flag of Canada image

If you moved the Site Database to another SQL, you need to run ConfigMgr Setup Wizard on the ConfigMgr Server to modify the SQL Server name:

1. Ensure the primary site server computer account has administrative privileges over the new site database server computer.
 
2. Close any open Configuration Manager console connections to the site server.
 
3. On the primary site server computer, use the hierarchy maintenance tool (Preinst.exe) to stop all site services with the following command: Preinst /stopsite.
 
4. On the primary site server computer, click Start, click All Programs, click Microsoft System Center, click Configuration Manager 2007, and click ConfigMgr Setup, or navigate to the .\bin\i386 directory of the Configuration Manager 2007 installation media and double-click Setup.exe.
 
5. Click Next on the Configuration Manager Setup Wizard Welcome page.
 
6. Click Perform site maintenance or reset this site on the Configuration Manager Setup Wizard Setup Options page.
 
7. Select Modify SQL Server configuration on the Configuration Manager Setup Wizard Site Maintenance page.
 
8. Enter the appropriate SQL Server name and instance (if applicable) for the new site database server as well as the site database name on the Configuration Manager Setup Wizard SQL Server Configuration page.
 
9. Configuration Manager Setup performs the SQL Server configuration process.
 
10. Restart the primary site server computer, and verify the site is functioning normally.
Avatar of SA-mattman
SA-mattman

ASKER

Thank you for your reply but we've done all that.

Per original post:
We've done the correct procedure.  
1) Added SCCMXYZ machine account to SQLTST01's local administrator group.
 rebooted both servers.
2) We backed up SQL database and restored onto new server
3) SCCMXYZ and SCCMSA both have rights to DB on new server
4) We logged into SCCMXYZ with the SCCMSA service account
5) We used "preinst.exe /stopsites" to stop the component site
services.  All stopped fine except SQL monitor.  No service is
found for that..
6) We used the setup.exe to change to the new sql server.  Used
SQLTST01\T2 for server and instance.  Used SCCMDB for database.
It processed everything fine..
7) Rebooted
Try to Move the SMS Provider, using the following link:
http://technet.microsoft.com/en-us/library/bb693923.aspx

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

http://support.microsoft.com/kb/247931

and for your referecne please check the following link:
https://www.experts-exchange.com/questions/20800659/IIS-and-SQL-'NT-AUTHORITY-ANONYMOUS-LOGON'.html
ASKER CERTIFIED SOLUTION
Avatar of SA-mattman
SA-mattman

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My DBA found the issue.  He posted the solution under my account.