Open topic with navigation

# Adding the MS SQL Server JDBC Driver

When you install and configure database connectors that use Microsoft SQL Server as the database, a JDBC driver is required. This driver does not ship pre-installed; you need to install it before configuring database connectors on the appliance.

To install a JDBC Driver:

1. From the Microsoft web site, download the MS SQL Server JDBC Driver to a computer that can access ArcMC.

2. Run the setup program to install the driver.

3. Follow the instructions in Uploading Files to a Repository to add the `sqljdbc.jar` file.

   Tip: The name of the `jar` file may be different from that of some JDBC driver versions. Different versions of the JDBC driver are required for different SQL Server database versions; be sure to use the correct driver for your database.

   The new driver file is added to the repository, as shown in the following example.

   After you have installed the JDBC driver, you need to upload the driver file to the containers that will hold the SQL Server database Connectors. Follow the instructions in Uploading Files to a Repository.

   After the driver file has been uploaded to a container, follow the instructions in Adding a Connector to add a connector that requires a JDBC driver.