Database Target Connecting to Microsoft SQL

This page describes how to configure Microsoft SQL Server as a source or target within Jitterbit Studio using either Windows or SQL Server authentication. See Database for information on the types of authentication supported for various systems.

Windows Authentication

Windows authentication can be used with only one domain account. To use Windows authentication with the SQL Server ODBC driver, set up the following in Windows:

1. Open the Services Administrative tool (Start > Administrative Tools > Services).
2. Right-click on the Jitterbit Apache Server service and select Properties.
3. Go to the Log On tab. Select This account and enter the name and credentials of the account you want to use for authentication. Then click Apply.
4. Repeat for the Jitterbit Process Engine service.

Once the above steps are completed, go to Jitterbit Studio and set up your source or target as normal. In the database source/target definition screen under Connection Parameters, specify the following:

• Driver: The SQL Server driver must be an ODBC driver. Windows authentication is not supported using JDBC.
• Server Name: Enter the name or IP address of server that runs the SQL Server that Jitterbit needs to connect to. You may have to specify the SQL Server instance name (HostName\InstanceName).
• Database Name: Enter the name of the database on the server that Jitterbit needs to integrate to.
• Login: Leave this field blank.
• Password: Leave this field blank.
• Options: Click to expand additional settings. In the field Additional Connection String Parameters, enter the following depending on your driver:
  • SQL Server [ODBC]: If you are using the "SQL Server [ODBC]" driver enter integratedSecurity=true. If this does not work, enter Trusted_Connection=yes.
  • ODBC Driver 11 for SQL Server [ODBC], SQL Server Native Client 10.0 [ODBC], SQL Server Native Client 11.0 [ODBC]: If you are using another SQL server driver, enter Trusted_Connection=yes.

 The driver will now authenticate as the Windows domain user specified above.

SQL Server Authentication

Go to Jitterbit Studio and set up your source or target as normal. In the source/target definition screen under Connection Parameters, specify the following:

• Driver: The SQL Server driver may be an ODBC or JDBC driver.
  

  NOTE: When selecting a JDBC driver, we recommend using "SQL Server MS JDBC [JDBC]," which is bundled with Harmony Agents as of version 9.3.
• Server Name: Enter the name or IP address of server that runs the SQL Server that Jitterbit needs to connect to. You may have to specify the SQL Server instance name (HostName\InstanceName).
• Database Name: Enter the name of the database on the server that Jitterbit needs to integrate to.
• Login: Enter the username for SQL Server authentication.
• Password: Enter the password for SQL Server authentication.

The driver will now authenticate using the SQL Server authentication credentials as specified.