How to specify Active Directory credentials when connecting to MSSQL data source

How to specify Active Directory credentials when connecting to MSSQL data source

book

Article ID: KB0081228

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.5,7.0.6+

Description

How to specify Active Directory credentials when connecting to MSSQL data source

Resolution

1. Open Studio ==>  Select any folder open "Create New Data Source" ==> Now select "New Adapter" using the Microsoft SQL Server <2012> parent adapter
2. Modify Adapter Class Name to: net.sourceforge.jtds.jdbc.Driver
3. Modify Connection URL Pattern to: jdbc:jtds:sqlserver://localhost:1433/<db>;tds=8.0;lastupdatecount=true
e.g. jdbc:jtds:sqlserver://dvbu-msq-005.dv.local:1433/Northbay;tds=8.0;lastupdatecount=true
****Please provide actual values of host_name, port and database
4. Download jtds.jar from MS site and copy the jTDS driver to /conf/adapters/custom/<name of the new adapter>
5. Restart CIS
6. Create a new data source from the new adapter
7. Supply details: database name, port, database name, authentication domain, login without domain name, password
8. Add a JDBC property in the Advanced data source tab
Property: domain and value 
9. Introspect - this should use the supplied credentials in the data source panel 

Issue/Introduction

How to specify Active Directory credentials when connecting to MSSQL data source