SAP Basis Tech Supports

Symptom

You want to download and install a current version of the JDBC Driver for Microsoft SQL Server in your SAP system.

Other terms

MSS, MSSQL, Microsoft SQL, MS SQL Server, Java Database Connectivity, JDBC Driver

Reason and Prerequisites

You must regularly update the JDBC Driver for Microsoft SQL Server used in a Java system.

Solution
General Remarks

A branded DataDirect JDBC Driver is used for installations up to Release NetWeaver 2004s SR2. It consists of the files base.jar, sqlserver.jar, util.jar, and spy.jar.
The following applies to this release and this driver:
You can find the current version of the Microsoft SQL Server JDBC Driver that SAP supports on SAP Service Marketplace atservice.sap.com/msplatforms -> SQL Server.You can use the Microsoft SQL Server JDBC Driver that you can download from the SAP Service Marketplace only in an SAP environment. You can access the driver only using Open SQL.Depending on the SAP release and the system configuration, the driver files base.jar, util.jar, sqlserver.jar, and spy.jar are available in an installed system at:(NetWeaver’04, Java:)usr\sap\\JC\j2ee\jdbc(NetWeaver’04, ABAP+Java:)usr\sap\\DVEBMGS\j2ee\jdbc(NetWeaver 2004s:)usr\sap\\SYS\exe\\Platform\mssjdbcCheck your JDBC Driver version before you download it. To do this, open a command prompt, branch to the relevant JDBC directory (see previous paragraph) and execute the following command:
java -cp sqlserver.jar;base.jar;util.jar com.sap.nwmss. jdbc.sqlserver.SQLServerDriver
The download name tells you which version of the driver you need to download from SAP Service Marketplace.To operate a Java system with Microsoft SQL Server 2005, you require at least driver version 3.50.20.NetWeaver ‘04 and systems that are based on it require at least Support Package 13 to use the current driver.Ensure that the DB connection information in the secure store of your system allows you to use the current driver. To do this, start configtool, open secure store and check the following entries:jdbc/pool//ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriverjdbc/pool//Urlbegins withjdbc:nwmss:sqlserver://
If these parameters are incorrect, and you use a NetWeaver 2004s system or NetWeaver ‘04 system with Support Package 13, create an SAP customer message.

For installations that have Release NetWeaver 2004s SR3, use the official Microsoft SQL Server 2005 JDBC Driver provided by Microsoft (also see Note 1109274). It consists of the file sqljdbc.jar.
The following applies to this release and this driver:
You can download the latest version of the Microsoft SQL Server 2005 JDBC Driver from the Microsoft download page, (for example, http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b64-4794-950d-81e1ec91c1ba&displaylang=en).Microsoft SQL Server 2005 JDBC Driver 1.2 contains an error (see Microsoft Knowledge Base article 945842 at http://support.microsoft.com/?kbid=945842). Do not use this version in SAP systems. Make sure you use either a higher release than 1.2 or the urgent correction (hotfix) for Release 1.2. You can download the urgent correction from SAP Service Marketplace.http://service.sap.com/msplatforms -> SQL ServerThe zip file sqljdbc_12_hotfix.zip (Hotfix for SQL JDBC 1.2) contains the installation programs for Windows (sqljdbc_1.2.2828.201_enu.exe) and UNIX (sqljdbc_1.2.2828.201_enu.tar.gz).Depending on the SAP release and the system configuration, the driver file sqljdbc.jar is available in an installed system at:(NetWeaver’04, Java:)usr\sap\\JC\j2ee\jdbc(NetWeaver’04, ABAP+Java:)usr\sap\\DVEBMGS\j2ee\jdbc(NetWeaver 2004s:)usr\sap\\SYS\exe\\Platform\mssjdbcTo operate a Java system with Microsoft SQL Server 2005, you require at least driver version 1.2with the urgent correction.
Importing the new driver
1. Read the section “General remarks” above.2. Download the driver from SAP Service Marketplace and unpack the archive in a local directory.3. Stop the SAP system.4. Replace the driver files in the JDBC directory of your system with the files from the archive you downloaded.5. Start the SAP system.