?
Solved

Steps how to move SCCM database to sql server 2008.

Posted on 2010-09-16
4
Medium Priority
?
1,468 Views
Last Modified: 2013-11-21
Hi all,
We are moving the SCCM database to SQL server 2008. The SCCM database is now on SQL server 2005. Could you please give me some sources or ideas how to do that?
Thank you
0
Comment
Question by:dongocdung
[X]
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
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33696468
so you have the old server running SQL 2005 and the new server running SQL 2008.
the easy way to move database from SQL 2005 to SQL 2008 using :
1-Detaching the Database
2- Copy the DATA / LOG Files
3- Attaching the Database

Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps.

after you move the SQL database to the new server you can use the steps in the KB below
http://technet.microsoft.com/en-us/library/bb680707.aspx

Good Luck!
Tarek Ismail

0
 

Author Comment

by:dongocdung
ID: 33702946
I will try it and let you know later
thank you
0
 

Author Comment

by:dongocdung
ID: 33728749
Hi TarekIsmail,
When I tried to this step:

Select Modify SQL Server configuration on the Configuration Manager Setup Wizard Site Maintenance page.

I entered  the SQL server name and instance but I got this error msg
"Could not connect or execute SQL query".
 I verified the SQL and instance name. They are correct. Do you why?
Thank you
0
 
LVL 6

Accepted Solution

by:
TarekIsmail earned 2000 total points
ID: 33729049

make sure to configure firewall on sql 2008 server allow access from remote computers

and make sure the sql server support tcp/ip and named pipe.

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The environment that this is running in is SCCM 2007 R2 running on a Windows 2008 R2 server. The PXE Distribution point is running on its own Windows 2008 R2 box. This is what Event viewer showed after trying to start the WDS service:  An erro…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

650 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