Connecting to SQL Server datasource using an Active directory Login
Follow these steps to connect to a SQL Server datasource using an Active Directory login:
1. Download the Microsoft jTDS JDBC driver
2. From Studio, create a new data source
3. Select "New Adapter" using the “Microsoft SQL Server <desired version>” parent adapter
4. Modify the “Adapter Class Name” to: net.sourceforge.jtds.jdbc.Driver
5. Modify the Connection URL Pattern to: jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE_NAME>;tds=8.0;lastupdatecount=true
6. Copy the jTDS driver to /conf/adapters/custom/<name of the new adapter>
7. Restart TDV
8. Create a new data source from the new adapter
9. Supply the following details in the data source panel:
| — | Host: |
| — | Port: |
| — | Database Name: |
| — | Login: <user name (no domain)> |
| — | Password: <user’s password> |
10. In the Advanced tab, add a JDBC Connection Property:
| — | Property: domain |
| — | Value: <domain name of AD user> |