Installation Guide › How to Install CA GovernanceMinder on an IBM WebSphere Cluster › Install JDBC Drivers and Data Sources on the Workpoint Cluster › Install Microsoft SQL Server JDBC Drivers and Data Sources on the Workpoint Cluster

Install Microsoft SQL Server JDBC Drivers and Data Sources on the Workpoint Cluster

Valid on Microsoft SQL Server.

This procedure describes how you install Microsoft SQL Server JDBC drivers and data sources on the Workpoint cluster.

Java applications use the JDBC XA driver to establish concurrent connections to multiple databases through their associated resource managers.

Install the JDBC XA drivers on all SQL servers, and on the WebSphere application server.

Note the following:

• With a 32-bit SQL server, use the sqljdbc_xa.dll file in the x86 folder, even if the SQL server is installed on an x64 processor.
• With a 64-bit SQL server on the x64 processor, use the sqljdbc_xa.dll file in the x64 folder.
• With a 64-bit SQL server on an IA-64 processor, use the sqljdbc_xa.dll file in the IA64 folder.

Follow these steps:

1. Install the Microsoft SQL JDBC installer on the SQL server.

   Download the installer, Microsoft JDBC Driver for SQL (sqljdbc_4.0.2206.100_enu.exe), from the Microsoft Download Center.

2. Enable the XA transactions on the SQL server as follows:
   1. In the computer where you install the SQL server, browse to the Control Panel.
   2. Click Administrative Tools, Component Services.
   3. Right-click My Computer and click Properties.
   4. Click the MSDTC tab and click Security Configuration.
   5. Select Enable XA Transactions.
   6. Save the changes and restart the SQL server.
3. Copy and install drivers on other SQL cluster servers as follows:
   1. Locate the JDBC distributed transaction components under the \xa folder of the JDBC driver installation directory.
   2. Copy the file sqljdbc_xa.dll.
   3. Paste this file in the following directory of every SQL server computer that participates in distributed transactions:

      %SQL_SERVER_INSTALL%\Binn
      

   4. Execute the database script xa_install.sql on every SQL server instance that participates in distributed transactions. This script installs sqljdbc_xa.dll as an extended stored procedure.

      Note: When you run this script, log in as an administrator for the SQL Server instance.

4. Install the drivers on WebSphere as follows.
   1. In the original JDBC installation folder on the SQL server, locate the sqldbc.jar file in the following directory:

      Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu
      

   2. Copy this file to the WebSphere application server under the following directory:

      WAS_install_root/essentials/JDBC/
      

      Note: WAS_install_root is the WebSphere Application Server installation directory.

5. To implement the new data source definitions, restart the WebSphere Application Server or the Deployment Manager service as required in your WebSphere environment.

   You have installed the Microsoft SQL Server JDBC drivers and data sources on the Workpoint cluster.