Install SQL Server 2008 R2 in Windows Server 2012 using SQL4SAP Script

[former_member229542]

Hi guys,

Since we are performing a SAP System Migration from older releases of Windows/SQL Server, as detailed on SAP Note

1780433 - System copy of SAP systems on Windows 2012 : SQL Server

We need to install SQL Server 2008 R2 before upgrading the system

When running SQL4SAP Script it states the following

17/03/2014 08:13:44 p.m.

----------------------------------------

Message Box "Windows version error"

OS Family "WindowsNT6.3" is not supported by this script.

Result: vbOK

----------------------------------------

On Windows 2012 should i run the SETUP instead the script?

Thanks!

[Former Member]

Hello,

As per SAP note 1732161,

2. SQL Server

Only SQL Server 2012 is supported productively on Windows Server 2012 (R2). For information on how to install, copy, update or upgrade your SAP system on SQL Server 2012, see SAP note 1676665.

So, what you are doing here is not supported.

Thanks,

Sunny

[former_member229542]

Hi Sunny

Im following SAP Note 1780433 - System copy of SAP systems on Windows 2012 : SQL Server

in order to migrate a SAP 640 system from Windows 2003/SQL Server 2005 to Windows 2012/ SQL Server 2012

Reason and Prerequisites

This note describes how to migrate the mentioned SAP products to Windows 2012/SQL Server 2008 R2,

in order to prepare an upgrade to SAP releases based on NW 7.0 and higher.

Note, that only SAP upgrade paths are supported, that are supported by the SUM tool. For more

information about the upgrade paths supported by SUM, read the Central SUM Note referred to at

http://www.service.sap.com/SLToolset.

Immediately after the SAP upgrade, your database has to be upgraded to SQL Server 2012. SAP does in general not support SQL Server releases prior to SQL Server 2012 on Windows 2012.

I understand this is not supported from Productive system, we are performing this on a Development system for test purposes.

Nevertheless on the note says Install First SQL Server 2008 R2 and after SAP upgrade, perform upgrade of SQL Server Upgrade, so there is misleasing information.

Im not sure if a 640 System would be able to copied and upgraded in Windows 2012/SQL Server 2012

It doesnt mention that 640_EX2 Kernel Support SQL Server 2012 to install the system.

How would yo recommend a system copy restoring database on these conditions?

640 System (SQL Server 2005,Win 2003) --> 640 System (SQL Server 2012, Win 2012)

(and then Upgrading to 740)

Thanks

[Former Member]

Hi Martin,

As you perform the upgrade you need to use setup.exe instead of the script.

Select the instance ID which needs to be upgraded and follow the steps.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hello,

You scenario is not supported because Netweaver 640 system is not supported on SQL server 2012. It is supported on SQL Server 2005. Please check PAM and based on that plan your activities because you will need to do same in production system as you are planning for upgrade. So, if it is not supported then in case of production, you will have lot of problems.

Thanks,

Sunny

[Former Member]

Hi Martin,

Based on information from PAM you can use below approach

Step1: Upgrade 640 system to NW 7.0 on Windows 2003/MSSQL 2005

Step2: Migrate NW 7.0 to Windows 2012/MSSQL 2012

Step3: Upgrade to NW 7.40 on Windows 2012/MSSQL 2012

Hope this helps.

Regards,

Deepak Kori