Hi All, currently my environment is SCCM 2007 SP2 R2, clustered DB SQL 2005 x64 SP3. Then I want to move the site database to stand alone SQL Server 2008 x64 SP1, is it enough I follow http://technet.microsoft.com/en-us/library/bb680707.aspx or are there any specific configuration ?Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hello - yes, Have u checked the below link? http://blogs.technet.com/b/configurationmgr/archive/2011/05/17/monday-moving-the-configuration-manager-2007-site-database-from-sql-2005-sp2-to-sql-2008.aspxAnoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

It's almost enough, you also need to make sure that the site server computer account is member of the local admin group and that you have sysadmin permissions. Furthermore tripple check the collation order, it must be the same on both SQL servers.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

Hello - yes, Have u checked the below link? http://blogs.technet.com/b/configurationmgr/archive/2011/05/17/monday-moving-the-configuration-manager-2007-site-database-from-sql-2005-sp2-to-sql-2008.aspx Anoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. yes, I've check that link :)Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

It's almost enough, you also need to make sure that the site server computer account is member of the local admin group and that you have sysadmin permissions. Furthermore tripple check the collation order, it must be the same on both SQL servers. Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund great, thanks for the answer Kent.Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.