Workaround: Making the SQL Server JDBC drivers accessible to WebSphere Application Server

Steve Pitschke
Last Updated: November 21, 2012
Build Basis: Rational Connector for SAP Solution 4.0

Summary

This article explains how to make the SQL Server JDBC drivers accessible to WebSphere Application Server.

More Information

To make the SQL Server JDBC drivers accessible to a connector JEE application, you must create an SQL Server JDBC provider on WebSphere Application Server.

Workaround

Follow these steps:

1. Open the WebSphere administration console by pointing a browser to http://yoursystem:9060/ibm/console
2. In the console navigation tree, expand Resources, then JDBC, and then JDBC Providers.
3. On the first page of the wizard, select All Scopes then select Node=YourNodeName, Server=YourServerSetup. Then click New.
4. Set the Database type to SQL Server, Provider type to SQL Server Using Microsoft JDBC Driver, and Implementation type to XA data source.
5. On the second page of the wizard, set the driver directory path to the directory where you placed the sqljdbc4.jar file.
6. On the last page of the wizard, click Finish. Then, save the changes.