Cannot connect to Site Database after moving SCCM database

Posted on 2010-09-22
Last Modified: 2013-11-21
We are moving the SCCM database to SQL server 2008. The SCCM database is now on SQL server 2005. We did everything such as:
- Moving a Database from SQL Server 2005 to SQL Server 2008
- I did this step in the following link to modify the SQL configuration
Everything were done successfully. When I tried to open SCCM console, It opened the smail window "Connecting to Site Database (xxx-SCCM, Company). It runs forever and does not stop. I canceled it and opened again. However, I still got that windows.
Do you have any idea?
Thank you
Question by:dongocdung
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4

Expert Comment

ID: 33735795
Ensure the primary site server computer account has administrative privileges over the new site database server computer.

also make sure the computer account has logon to SQL database as attached settings
then delete the site database from the console , and try to connect again.


Author Comment

ID: 33736230
I have SCCM computer account as local Admin in SQL server 2008. I also did some steps that you asked me to do. However, i still got that windows running forever

Expert Comment

ID: 33736607
OK , we need to check the SmsAdminUI log file:

close all SCCM console
go to thew following path
C:\Program Files (x86)\Microsoft Configuration Manager\AdminUI\AdminUILog
rename the SmsAdminUI to SmsAdminU-old
open the SCCM console again, connect the SCCM server wait for some time to get the log
send the log to check it , hopping to get a solution for your issue.
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.


Expert Comment

ID: 33736712
HI dongocdung:

also we need to check the SMS provider location
is it located on the old SQL server or on SCCM server.
any way you need to check the location first using KB below
KB: How to Verify Namespace and Server Connectivity

I think you need to move SMS provider using KB below
How to Move the SMS Provider

Author Comment

ID: 33737649
I did change the log file name but it did not work. When I verified the SMS provider location, I entered the \\sccm\roots\sms in Namespace but I got this error msg
"Number: 0x8004100e
Facility: WMI
Description: Invalid namespace"

Expert Comment

ID: 33737722
good , so our issue is the SMS provider was located with the old SQL server

now we need to move SMS provider using the same wizrad like chnageing sql server

Author Comment

ID: 33738234
When I Select
Select Modify SMS Provider configuration on the Configuration Manager Setup Wizard Site Maintenance page.
and I entered the new SQL server but I got this error msg

"Setup has detected an open MMC instance. Any open MMC instance must be closed before continueing"

Expert Comment

ID: 33738640
i dont know who to know the used console , but you can restart your SQL , then restart your SCCM server.
then run the wizard again , and i recommend to host SMS provider on SCCM server not SQL server.

I hope restart will close all Connected console.

Author Comment

ID: 33744914
It run successfully. How do I need to delete the old SQL site? Do I just right click and delete it? Also, could you please show me how to move SMS provider to SCCM server.
Thank you

Accepted Solution

TarekIsmail earned 500 total points
ID: 33746290
It run successfully, so you modifiy the SMS provider configuraton to the new selected server.

WHat you mean by old SQL site , do you mean old SQL database on the old server?

to move /modifiy the SMS provider to SCCM server, you already do this in your last step.

I hope we are running in a good state , and SMS moved correctly!
Good Luck!
Tarek Ismail

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack.  My needle was an anti-virus version causing problems with my Exchange server. I have an HP DL350 with Windows Server 2008 Stand…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question