Solved

SCCM 2007 Database Move

Posted on 2014-03-19
7
248 Views
Last Modified: 2014-05-30
I currently have SCCM 07 up and running.  I have the SQL portion on a separate SQL server. That server is being replaced with a new one.  I need to move the existing SCCM database to the new server SQL server.

I have not found any good walk through a on the web.

What steps do I need to take to make this transition happen smoothly?
0
Comment
Question by:BSModlin
  • 3
7 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39940514
0
 

Author Comment

by:BSModlin
ID: 39950126
I have completed the steps above.  I am leaving this question open until I have verified all is working.  I will allocate points today.  THANK YOU for your assistance.
0
 

Author Comment

by:BSModlin
ID: 39950485
I am receiving errors when trying to launch reporting. See Attached.

Not sure where to go from here...

PLEASE HELP!
ReportingError.JPG
SiteError.JPG
0
 

Author Comment

by:BSModlin
ID: 39951818
Do I need to reinstall something on the database server because it is new??
0
 
LVL 23

Expert Comment

by:Nagendra Pratap Singh
ID: 39960821
Have you changed the server name?
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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
email the result out from a T-SQL queries 29 62
syadmin MSSQL 2 57
T-SQL for SS2000 -- get characters until a digit 6 19
Optimizing a query 3 33
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

939 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

8 Experts available now in Live!

Get 1:1 Help Now