<div>
so you have the old server running SQL 2005 and the new server running SQL 2008.<br />
the easy way to move database from SQL 2005 to SQL 2008 using :<br />
1-Detaching the Database<br />
2- Copy the DATA / LOG Files<br />
3- Attaching the Database<br />
<br />
Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps<br />
<a href="http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps" rel="ugc">http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps</a>.<br />
<br />
after you move the SQL database to the new server you can use the steps in the KB below<br />
<a href="http://technet.microsoft.com/en-us/library/bb680707.aspx" rel="ugc nofollow">http://technet.microsoft.com/en-us/library/bb680707.aspx</a><br />
<br />
Good Luck!<br />
Tarek Ismail<br />
<br />

</div>


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 [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 [http://technet.microsoft.com/en-us/library/bb680707.aspx]

Good Luck!
Tarek Ismail



<div>
I will try it and let you know later<br />
thank you
</div>


I will try it and let you know later
thank you

<div>
Hi TarekIsmail,<br />
When I tried to this step:<br />
<br />
Select Modify SQL Server configuration on the Configuration Manager Setup Wizard Site Maintenance page.<br />
<br />
I entered &nbsp;the SQL server name and instance but I got this error msg <br />
&quot;Could not connect or execute SQL query&quot;.<br />
&nbsp;I verified the SQL and instance name. They are correct. Do you why?<br />
Thank you
</div>


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

<div>
<div class="content wysiwyg-content">
Hi all,<br />
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?<br />
Thank you
</div>
</div>


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

Steps how to move SCCM database to sql server 2008.

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.