Question Re: Install SQL Server 2008 R2 in Windows Server 2012 using SQL4SAP Script in Technology Q&A

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

former_member229542 — Tue, 18 Mar 2014 00:23:16 GMT

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!

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

Former Member — Tue, 18 Mar 2014 05:11:56 GMT

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

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

former_member229542 — Tue, 18 Mar 2014 11:16:27 GMT

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

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

Former Member — Tue, 18 Mar 2014 12:42:33 GMT

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

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

Former Member — Tue, 18 Mar 2014 13:42:35 GMT

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

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

Former Member — Tue, 18 Mar 2014 14:26:21 GMT

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

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

Former Member — Sun, 23 Mar 2014 16:40:05 GMT

Hello

Can you please note that:

- Use a user with administration rights of your server (do not use sidadm)

- SQL4SAP script does not support cluster

- You cannot use the script to upgrade SQL Server

- Windows Server 2012 supportes: Standard Edition and Datacenter Edition

- For detail prerequisites read http://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx

Best regards

Joao Vagarinho

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

former_member229542 — Sun, 23 Mar 2014 17:21:10 GMT

Thanks guys for the support

I was able to Install SQL 2008 R2 Server by using the setup.exe provided.

Also .NET 3.5 Framework is mandatory

Anyways, I was able to run a 640 System on a Windows 2012/SQL Server 2008R2

Regards!

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

Former Member — Thu, 10 Jul 2014 14:52:17 GMT

Hi All,

We are planing for OS & DB Migration from SQL 2000 / Windowns 2003 to SQL 2012 / Windows 2012 server, it would be helpful for me if you share your ideas and experience on this.

source system:

SAP : ECC 6.0

DB: SQL 2000

OS: Windows 2003

Target System:

SAP ECC 6.0

DB: SQL 2012

OS: Windows 2012

Steps:

1: Install ECC 6.0 with SQL 2008 on Windows 2012 server.

2: Take DB Backup from Source system (SQL 2000).

3: Restore source system backup(SQL 2000) into Target System (SQL 2008)

4: From there Upgrade DB from SQL 2008 to SQL 2012.

5: Start the SAP Instance.

will it be possible or i need to follow any other steps for this activity.

Regards,

Vino

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

Former Member — Tue, 01 Sep 2015 07:53:00 GMT

Installation of MSQL2008 on

MicrosoftServer2012.

In the script sql4sap and the pdf documents, MS2012 is supported version for mssql2008. Though in PAM it is not supported.

Install NET-Framework as a pre-requisite in the windows powershell as Administrator

>Intall-WindowsFeature NET-Framework-Core

use script to install the database.

MicrosoftServer2012R2

If you do with setup.exe, mssql08 is installed but the options are not OK eg Collation. SAP does not get installed or import hangs etc. etc.

Edit the script sql4sap.vbs, find and replace all Windows2012 with WindowsNT6.3

Always use the modified script sql4sap in this case.

Best Regards

Shivinder

Project Management and SAP Basis Consultant

0032 495580041

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

former_member240800 — Mon, 28 Mar 2016 19:37:53 GMT

Hi,

Edit script and Add this line:

case "6.3" OSFamily = "Windows8"

under line

case "6.2" OSFamily = "Windows8"

Best regards

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

luisdarui — Mon, 28 Mar 2016 19:58:26 GMT

It is not suggested to edit the script file, as it reflects the OS x DB matrix restrictions.

For example, SQL Server 2008 (R2) is not supported by SAP in Windows 2012 (R2).

Best Regards,

Luis Darui