Installation Guide › Installing an AIX Implementation › Run the CA RCM Installer › Complete CA RCM Server Installation on AIX/WebSphere › Install Microsoft SQL Server JDBC Drivers and Data Providers in the CA RCM Cluster

Previous Topic: Add and Configure Servers in CA RCM Cluster

Next Topic: Install Oracle JDBC Drivers and Data Providers in the CA RCM Cluster
Install Microsoft SQL Server JDBC Drivers and Data Providers in the CA RCM Cluster

The Java Database Connectivity (JDBC) API supports server cluster connections to the SQL database. When a Microsoft SQL Server hosts CA RCM databases, you install JDBC drivers on the SQL server and the WebSphere Application Server.

To install Microsoft SQL Server JDBC drivers and data providers in the CA RCM cluster

  1. Download the Microsoft SQL JDBC installer installer, sqljdbc_1.2.2828.100_enu.exu, from the Microsoft Download Center to the SQL server.
  2. Run the installer.
  3. Find the file sqldbc.jar in the following directory: 
    Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu
  4. 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. In the WebSphere administration console, click Resources, JDBC, JDBC Providers and create a JDBC provider with the following settings:
  6. Restart the WebSphere Application Server or the Deployment Manager service as required in your WebSphere environment to implement the new data source definitions.