Solved

Cannot connect to Site Database after moving SCCM database

Posted on 2010-09-22
10
2,459 Views
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
http://technet.microsoft.com/en-us/library/bb680707.aspx
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
0
Comment
Question by:dongocdung
  • 6
  • 4
10 Comments
 
LVL 6

Expert Comment

by:TarekIsmail
Comment Utility
HI,
 
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.

SNAG-0115.jpg
SNAG-0116.jpg
SNAG-0117.jpg
SNAG-0118.jpg
SNAG-0119.jpg
0
 

Author Comment

by:dongocdung
Comment Utility
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
0
 
LVL 6

Expert Comment

by:TarekIsmail
Comment Utility
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.
0
 
LVL 6

Expert Comment

by:TarekIsmail
Comment Utility
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
http://technet.microsoft.com/en-us/library/bb932190.aspx

I think you need to move SMS provider using KB below
How to Move the SMS Provider
http://technet.microsoft.com/en-us/library/bb693923.aspx
0
 

Author Comment

by:dongocdung
Comment Utility
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"
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 6

Expert Comment

by:TarekIsmail
Comment Utility
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
http://technet.microsoft.com/en-us/library/bb693923.aspx
0
 

Author Comment

by:dongocdung
Comment Utility
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"
0
 
LVL 6

Expert Comment

by:TarekIsmail
Comment Utility
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.
0
 

Author Comment

by:dongocdung
Comment Utility
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
0
 
LVL 6

Accepted Solution

by:
TarekIsmail earned 500 total points
Comment Utility
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
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Remote Desktop Protocol or RDP has become an essential tool in many offices. This article will show you how to set up an external IP to point directly to an RDP session. There are many reasons why this is beneficial but perhaps the top reason is con…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now