Limitations of Microsoft SQL Server JDBC driver when publishing to a remote WebSphere Application Server

It is a known problem that when you are publishing to a remote WebSphere® Application Server by using a Microsoft SQL JDBC driver, you might get the following error. This error prevents you from making a database connection:

Important: Applicable to WebSphere Application Server traditional
SystemOut
     O [Microsoft][SQLServer 2000 Driver for JDBC]Error opening/loading com.microsoft.util.transliteration.properties.
SystemErr
     R java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error opening/loading com.microsoft.util.transliteration.properties.

To work around this problem:

  1. Copy the following Microsoft SQL Server JAR files to the x:\AppServer\lib folder (where x is the directory where WebSphere Application Server is installed:
    • msbase.jar
    • mssqlserver.jar
    • msutil.jar
  2. If you want the JAR files located elsewhere:
    1. In the WebSphere Application Server installed directory, open the following directory.
      x:\profiles\properties
      Where x:\profiles is the directory of your profile for the WebSphere Application Server.
    2. Edit the server.policy file and change the permissions for the JAR files to read access, for example.
      // WebSphere system classes  
      grant codeBase "file:${was.install.root}/lib-" { 
          permission java.security.AllPermission; 
      permission java.io.FilePermission 
      "${was.install.root}${/}lib${/}msbase.jar", "read"; 
      permission java.io.FilePermission 
      "${was.install.root}${/}lib${/}msutil.jar", "read"; 
      permission java.io.FilePermission 
      "${was.install.root}${/}lib${/}mssqlserver.jar", "read"; 
      };
Icon that indicates the type of topic Reference topic
Timestamp icon Last updated: July 17, 2017 21:58

File name: rmssql.html