Installing the Microsoft SQL Server JDBC Driver

Install the Microsoft SQL Server JDBC driver.

  1. Go to the Microsoft download site and search for this string:
    Microsoft SQL Server 2005 JDBC driver
  2. Click the link for the 1.2 driver, and follow the instructions to download and install the driver.
  3. Open Control Panel > System, click the Advanced tab, and click Environment Variables.
  4. In the System Variables window, if the CLASSPATH variable is not listed, click New. Otherwise, select it, and click Edit.
  5. Enter the full path of the JDBC driver, using a semicolon (;) to separate it from any other drivers.
  6. Click OK three times.
Parent topic: Primary Microsoft SQL Server Configuration and Verification