?
Solved

Steps how to move SCCM database to sql server 2008.

Posted on 2010-09-16
4
Medium Priority
?
1,467 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

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 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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

762 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