View Jitterbit Developer Portal
- Created by Laura Knowles, last modified by Lisa Brown on Oct 16, 2018
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 can be used with only one domain account. To use Windows authentication with the SQL Server ODBC driver, set up the following in Windows: 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: The driver will now authenticate as the Windows domain user specified above. 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. The driver will now authenticate using the SQL Server authentication credentials as specified.Windows Authentication
<domainName>\<machineName>$
).integratedSecurity=true
. If this does not work, enter Trusted_Connection=yes
.Trusted_Connection=yes
.SQL Server Authentication
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
There is no content with the specified labels
Last updated: Oct 16, 2018