MSSQL error when install SAP 4.6C for system migration

[Former Member]

Dear All,

I am currently performing migration from 4.6C on mssql2000 on 32bit to 4.6C mssql 2008R2 64bit(will upgrade to ERP 6). however after installing MSSQL 2008 R2 and perform step II in sapnote 965145 - Installation of 46C SAP Systems on MS SQL Server 2005 I got below error

ins

Creating coprocess osql.exe ...

Error: DBCOMMONDBENV_NT_MSS InternalInstallationDo 2 560

Your actual major version of MS SQL Server is 0.

Please assure that the version is at least 700!

Please help as i have install MSSQL 2008 R2 before the SAP installation and performed all prerequisites. Please also refer to attach screenshot and error log.

Thanks

regards

Aiman.

CEDBR3CP.txt.zip

[Matt_Fraser]

Aiman,

According to the PAM (http://service.sap.com/pam) R/3 4.6C is not compatible with SQL Server 2008.  The highest SQL Server release for 4.6C is 2005.

On the other hand, ERP 6.0 is supported (or was, rather... the support has ended) on SQL 2000, though in 64-bit only with the 7.00 kernel, for which support has ended as well.  In 32-bit, the 7.20 kernel was supported on SQL 2000.

So, you are going to have to do your upgrade in a different order, or do the database upgrade in two steps.  One alternative could be:

1. On existing (32-bit) server, upgrade R/3 4.6C to ERP 6.0 with 7.00 32-bit kernel.  Note that unless you have a special support agreement with SAP, this will probably be an unsupported upgrade, but since you're out of support anyway, that may not make a difference.  Please note that Windows 2003 is the minimum OS for ERP 6.0, so if you are still on Windows 2000, you'll have to figure out an OS upgrade first, as well (it's also the maximum OS for 4.6C, so this is the OS the first server needs to be on for this to work).
2. On new (64-bit) server, install SQL Server 2008 (64-bit) on Windows 2008 R2.
3. Do a Homogeneous System Copy of your ERP 6.0 system to the new server, migrating to the 7.21_EXT 64-bit kernel in the same step.

This is probably the cleanest alternative, as it gives you a clean install of both Windows and SQL Server on the new system, which is generally preferred over an upgrade (at least of the OS).

Regards,

Matt

[former_member188883]

Hi Aiman,

SAP note 965145 - Installation of 46C SAP Systems on MS SQL Server 2005

is meant for SQL 2005 installation only.

From the information which you shared it looks like you trying to install SQL 2008 using above SAP note.

This may not work.

Regards,

Deepak Kori