| copyright | lastupdated | keywords | subcollection | ||
|---|---|---|---|---|---|
|
2021-3-23 |
SAP, {{site.data.keyword.cloud_notm}} SAP-Certified Infrastructure, {{site.data.keyword.ibm_cloud_sap}}, SAP Workloads |
sap |
{:shortdesc: .shortdesc} {:codeblock: .codeblock} {:screen: .screen} {:external: target="_blank" .external} {:pre: .pre} {:table: .aria-labeledby="caption"} {:note: .note} {:tip: .tip} {:important: .important}
{: #anydb-ms-sql-server}
The SAP systems in a landscape have specific requirements for servers, operating systems, network setup, and supported storage. {: shortdesc}
Deployment of SAP AnyDB on IBM Cloud is similar to deployments with infrastructure with on-premises data centers. Therefore, use the information that is provided from SAP and the RDBMS providers.
To assist your project's planning phase, below are additional design considerations for SAP AnyDB - Microsoft SQL Server with {{site.data.keyword.ibm_cloud_sap}}.
{: #anydb-ms-sql-server-overview}
Before you start deploying the MS SQL Server software, ensure that:
- Check all relevant SAP and MS SQL Server information and prerequisites (for example, SAP Notes); including versions and fix pack levels of MS SQL Server that are supported
- All required packages are installed for the relevant OS that you are using for MSSQL
{: #anydb-ms-sql-server-documentation}
A good entry point into the documentation is SAP community page for MS SQL Server For a current overview of the combinations of MS SQL Server, SAP NetWeaver (or other SAP components), and operating systems - see the Product Availability Matrix (PAM).
MS SQL Server database and SAP NetWeaver on Windows
- Installation of SAP Systems Based on the Application Server ABAP of SAP NetWeaver 7.3 EHP1 to 7.52 : MS SQL Server
- Installation of SAP Systems Based on the Application Server Java of SAP NetWeaver 7.5 and SAP Solution Manager 7.2 SR2 Java : MS SQL Server
MS SQL Server licensing supported by SAP
- SAP Note 1491158 - Information About the Microsoft SQL Server License Scope
- SAP Note 398136 - Support Policy for Microsoft SQL Server
MS SQL Server release/support information
- SAP Note 2807743 - Release planning for Microsoft SQL Server 2019
- SAP Note 2779625 - Setting up Microsoft SQL Server 2019
- SAP Note 2492596 - Release planning for Microsoft SQL Server 2017
- SAP Note 2484674 - Setting up Microsoft SQL Server 2017
- SAP Note 2201059 - Release planning for Microsoft SQL Server 2016
- SAP Note 1177356 - MS SQL Server: End of Support for SAP Releases
- SAP Note 62988 - Service packs for MS SQL Server
{: #anydb-ms-sql-server-bm}
See SAP Note 2414097 - SAP Applications on IBM Cloud: Supported DB/OS and IBM Cloud Bare Metal Server Types for supported MSSQL database versions.
A sample configuration is shown in:
{: #anydb-ms-sql-server-bm}
See SAP Note 2927211 - SAP Applications on IBM Virtual Private Cloud: Supported DB/OS and IBM Gen 2 Virtual Server Instances for supported MSSQL database versions.
A sample configuration is shown in: