Solution : https://service.sap.com/sap/support/notes/1152240 (SAP Service marketplace login required)
Summary :
This SAP note outlines procedures for setting up, running, and upgrading SQL Server 2008 and SQL Server 2008 R2 within an SAP environment. Key actions include upgrading earlier versions of SQL Server (2000, 2005) to SQL Server 2008 (R2), as well as transitioning from SQL Server 2008 to SQL Server 2008 R2. Recommendations include using the latest versions of guides and RDBMS media from SAP Service Marketplace, adhering to certain DBSL patch levels for system stability, and ensuring compatibility through SAP NetWeaver with appropriate JDBC drivers. Links to download locations, installation, and upgrade guides are provided, with emphasis on following SAP notes for specific configurations and troubleshooting.
Key words :
<local_directory>\data_units\<platform>\nw07\webas\ind, <local_directory>\data_units\<platform>\ce71\webas\ind, sap note 1716219for sl toolset sps06, /instguides -> database upgrades -> ms sql server, required basis sp level defined, troubleshooting vi frequently asked questions, current sl toolset release note, microsoft sql server jdbc driver, latest kernel sapexe_<patch>-<xxxxxx>, sql server 2008 cluster group fails
Related Notes :
| 1496520 | SQL Server: Sick message after homogeneous system copy |
| 1490337 | High Availability SAP System on Windows Server 2008 (R2) |
| 1427804 | RSDU_TABLE_TRUNC_PARTITION_MSS -ALTER TABLE SWITCH failed |
| 1377270 | NOT NULL-columns missing defaults |
| 1291861 | SICK message: Wrong long datatypes |
| 1260968 | COPYTOSHADOW: R3trans loses reports |
| 1161733 | SQL Server: SAP EHPI for SAP NetWeaver 7.0 |
| 1145221 | JDBC driver exchange to Microsoft JDBC Driver |
| 1144459 | SAP Installation Media and SQL4SAP for SQL Server 2008 (R2) |
| 1141630 | RSDU_TABLE_TRUNC_PARTITION_MSS -ALTER TABLE SWITCH |
| 1126568 | Enable star join optimization with SQL Server 2008 |
| 1076022 | Release planning for Microsoft SQL Server 2008 (R2) |
| 991014 | (Vardecimal) Compression for SQL Server 2005 SP 2 |
| 683447 | SAP Tools for MS SQL Server |
| 639702 | JDBC Driver for Microsoft SQL Server |