Unable to Move SCCM 2007 db to SQL 2012 SP1

[prakash.thakor]

Hi,

 

We want to Move SCCM 2007 R3 database to SQL Server 2012 SP1.

 

SCCM server Version : 4.00.6487.2000

Build Number : 6487

 

But it says fatal error during the move wizard.

 

In ConfigMgrSetup.log it says :

 

***SqlError: [42000][102][Microsoft][ODBC SQL Server Driver]

Incorrect syntax near '99901'. : SiteControl_ins_upd

 

***SqlError: [42000][102][Microsoft][ODBC SQL Server Driver][sql Server]Incorrect syntax near '99901'. : SiteControl_ins_upd

 

I already installed following updates on SCCM server , but still it failed to move.

2676737

2676776

 

Thanks

[Peter van der Woude]

SCCM 2007 is very restricted with its support for SQL 2012 (let alone SP1). Take a look here for all the restrictions: http://technet.microsoft.com/en-us/library/ee344146.aspx