SAP Support for SQL Server 2017

  • Article

We are happy to share that SAP released support for SQL Server 2017 for some SAP NetWeaver based systems. In this blog we will talk about how you can update your existing installations on SQL Server to SQL Server 2017, what you need to do when installing a new SAP NetWeaver based system on SQL Server 2017 and what to consider when upgrading an SAP NetWeaver based system which is already running on SQL Server 2017. We will also list all supported products and the required Support Package Stacks.

For the first time, you do not need to apply new Support Packages Stacks if you are already running on a supported SPS for SQL Server 2016. The minimum SPS are the same. You only need a new SAP Kernel and ODBC driver.

SQL Server RDBMS DVD

Important: Please read SAP Note 2139358 (Login required) and SAP Note 2534720 (Login required) on more information about how and where to download the SQL Server 2017 RDBMS DVD.

Installation of SAP NetWeaver

The following SAP NetWeaver based products are supported on SQL Server 2017:

  • SAP products based on SAP NetWeaver Java for releases SAP NetWeaver 7.1 or higher
  • SAP products based on SAP NetWeaver ABAP for releases SAP NetWeaver 7.0 and higher
  • SAP NetWeaver PI for releases SAP NetWeaver 7.1 and higher
  • SAP Solution Manager 7.2

The following SAP NetWeaver based products are not supported on SQL Server 2017:

  • SAP Solution Manager 7.1 and earlier releases of SAP Solution Manager
  • SAP CRM 5.0 and SAP CRM 6.0 (also known as SAP CRM 2007)
  • SAP SCM 5.0 and SAP SCM 5.1 (also known as SAP SCM 2007)
  • SAP SRM 5.0
  • SAP NetWeaver Developer Workplace
  • SAP NetWeaver Java 7.0x

Before you start with the installation, please read the following SAP Notes:

  • Release planning Note – SAP Note 2492596 (Login required)
  • Setting up Note – SAP Note 2484674 (Login required)
  • Required SQL Server patches – SAP Note 62988 (Login required)
  • SWPM Note and required Kernel DVD – SAP Note 1680045 (Login required)
  • Central Note for SL Toolset – SAP Note 1563579 (Login required)

Requirements

  • Windows Server 2012 64-bit or higher
  • SQL Server 2017 Enterprise Edition

Preparation

SAP Software Provisioning Manager

See SAP Note SAP Note 1680045 (Login required) on where to download the SWPM. Please make sure to always download the latest SWPM and the SWPM that matches the SAP NetWeaver version that you want to install (e.g. for SAP NetWeaver 7.0 based products you need to download 70SWPM).
You need to download at least SAP Software Provisioning Manager 1.0 SP23.

Kernel DVD

For installations with SWPM 7.0x (70SWPM), see SAP Note SAP Note 1680045 (Login required) on where to download the latest Kernel DVD.
Use the archive based installation for installations with SWPM.

For SAP products based on SAP NetWeaver 7.4 and higher, use the 7.49 DCK Kernel
For SAP products based on EHP1 for SAP NetWeaver 7.3 and lower use the 721_EXT Kernel DVD (only the EXT Kernel is supported)

SAP recommends using the latest SP stack kernel (SAPEXE.SAR and SAPEXEDB.SAR), available in the Support Packages & Patches section of the SAP Support Portal https://launchpad.support.sap.com/#/softwarecenter.

For existing installations of NetWeaver 7.40, 7.50 and AS ABAP 7.51 this is SAP Kernel 749 PL 500. For details, see release note 2626990.
For new installations of NetWeaver 7.40, 7.50 and AS ABAP 7.51 this is SAP Kernel 753 PL 100. For details, see DCK note 2556153 and release note 2608318.
For AS ABAP 7.52 this is SAP Kernel 753 PL 100. For details, see release note 2608318.

Java DVD

See SAP Note SAP Note 1680045 (Login required) on where to download the Java DVD for the product you want to install.

ODBC driver

If you want to install a distributed SAP System (database and SAP application Server are running on different hosts), make sure that the latest ODBC driver for Microsoft SQL Server is installed on the host running your SAP application Server. See SAP Note 1902794 (Login required)

The ODBC driver can also be downloaded from the Microsoft Download Center

Installation

Install your SAP system using

  • The SAP Software Provisioning Manager SAR archive (SWPM.SAR or 70SWPM.SAR) 1.0 SP23 or higher
  • The SAP Software Provisioning Manager Kernel DVD (for installations with 70SWPM.SAR)
  • Kernel archives of SAP Kernel 7.21 EXT, 7.22EXT, 7.49 or 7.53
  • The Java DVD as described in SAP Note 1680045 (Login required)
  • The DVDs that were originally shipped with the SAP product (Export DVD, language DVDs…)

To install the SAP NetWeaver based system, follow these steps:

  1. After the Installation upgrade your kernel to the latest 7.21 EXT/7.22 EXT Kernel or 7.49 Kernel. 7.22 EXT Kernel is recommended for SAP System based on SAP NetWeaver 7.31 or lower.
  2. ABAP/ABAP+JAVA: Connect your new SAP System to your SAP Solution Manager (only required if you do not install SAP Solution Manager)
  3. ABAP/ABAP+JAVA: Create a maintenance stack to implement at least (only required if you do not install SAP Solution Manager):
    • SAP Business Suite 2005
      • SAP ERP 6.0 SPS 28 or higher
    • SAP Business Suite 7 Support Release 1
      • SAP CRM 7.0 SPS 18 or higher
      • EHP4 for SAP ERP 6.0 SPS 18 or higher
      • SAP SCM 7.0 SPS 18 or higher
      • SAP SRM 7.0 SPS 19 or higher
    • SAP Business Suite 7i 2010
      • EHP1 for SAP CRM 7.0 SPS 15 or higher
      • EHP5 for SAP ERP 6.0 SPS 15 or higher
      • EHP1 for SAP SCM 7.0 SPS 15 or higher
      • EHP1 for SAP SRM 7.0 SPS 15 or higher
    • SAP Business Suite 7i 2011
      • EHP2 for SAP CRM 7.0 SPS 16 or higher
      • EHP6 for SAP ERP 6.0 SPS 16 or higher
      • EHP2 for SAP SCM 7.0 SPS 16 or higher
      • EHP2 for SAP SRM 7.0 SPS 16 or higher
    • SAP Business Suite 7i 2013
      • EHP3 for SAP CRM 7.0 SPS 10 or higher
      • EHP7 for SAP ERP 6.0 SPS 10 or higher
      • EHP3 for SAP SCM 7.0 SPS 10 or higher
      • EHP3 for SAP SRM 7.0 SPS 10 or higher
    • SAP Business Suite 7i 2016
      • EHP4 for SAP CRM 7.0 SPS 01 or higher
      • EHP8 for SAP ERP 6.0 SPS 01 or higher
      • EHP4 for SAP SCM 7.0 SPS 01 or higher
      • EHP4 for SAP SRM 7.0 SPS 01 or higher
    • SAP NetWeaver 7.1 SPS 20 or higher
    • SAP NetWeaver 7.1 including EHP1 SPS 15 or higher
    • SAP NetWeaver 7.3 SPS 14 or higher
    • SAP NetWeaver 7.3 including EHP1 SPS 17 or higher
    • SAP NetWeaver 7.4 SPS 12 or higher
    • SAP NetWeaver 7.5 SPS 01 or higher
    • SAP NetWeaver 7.51 and higher do not need additional support packages
  4. ABAP/ABAP+JAVA: Use the Software Update Manager (SUM) 1.0 SP17 or higher to implement the maintenance stack (only required if you do not install SAP Solution Manager)
    DO NOT use SPAM to implement the support packages
    DO NOT update SPAM manually but let the SUM update the SPAM as part of the maintenance stack implementation
  5. SAP Solution Manager 7.2 only: Use the Software Update Manager (SUM) 1.0 SP17 to install SAP Solution Manager 7.2 SR1 which already contains the required SPS 01

Post Steps

Configure your SQL Server as described in SAP Note 2484657 (Login required)

System Copy of SAP NetWeaver

You can also copy your SAP System that is running on an older SQL Server release to a machine running a new SQL Server with the following steps:

  • Make sure that your source system is at least on the support package stack as described in the installation section if this blog.
  • Copy your SAP system using
    • The SAP Software Provisioning Manager 1.0 SP23 or higher SAR archive (SWPM.SAR or 70SWPM.SAR)
    • The SAP Software Provisioning Manager Kernel DVD for installations with 70SWPM or the lastest archives of the 7.21 EXT, 7.22 EXT, 7.49 or 7.53 kernel
    • The Java DVD as described in SAP Note 1680045 (Login required)
    • The DVDs that were originally shipped with the SAP product (Export DVD, language DVDs…)
  • After the Installation upgrade your kernel to the latest 7.21 EXT, 7.22 EXT Kernel, 7.49 or 7.53 Kernel. 7.22 EXT Kernel is recommended for SAP System based on SAP NetWeaver 7.31 or lower.

The steps for a System Copy where the source SAP system is already running on SQL 2017 are the same.

Update or Upgrade of SAP NetWeaver

Only updates or upgrades that are supported by the SAP Software Update Manager are supported for SQL Server 2017. Please read SAP Note SAP Note 1563579 (Login required) to find the SAP Note for the latest SAP Software Update Manager that describes the supported update and upgrade scenarios.

As an example, the following upgrades are not supported by SAP Software Manager and are therefore not supported for SQL Server 2017:

Upgrade of SAP CRM 5.0 to SAP CRM 7.0 or EHP1 for SAP CRM 7.0

Upgrade of SAP SCM 5.0 to SAP SCM 7.0 or EHP1 for SAP SCM 7.0

Upgrade of SAP SRM 5.0 to SAP SRM 7.0 or EHP1 for SAP SRM 7.0

Use at least SAP Software Update Manager 1.0 SP22 or SAP Software Manager 2.0 SP02