Forum Discussion

vi's avatar
vi
Occasional Contributor
9 years ago

Connecting SQL server 2014 using windows authentication

Hi,  I am trying to setup a jdbc connection to connect to SQL servere using windows authentication and query the database. I contacted support team but i couldn't get the help on this, which is sup...
NataliaB's avatar
NataliaB
Occasional Contributor
9 years ago

1. copy sqljdbc jar (the most recent version) to \ReadyAPI-1.6.0\bin\ext

2. copy folders xa and auth to the same place and add it to the PATH (there should be 2 folders for each, in total 4 folders to add to the path)

3. copy sqljdbc_auth.dll to \ReadyAPI-1.6.0\bin

4. restart machine

 

Your connection string should be :

jdbc:sqlserver://<SERVER_NAME>:<PORT:1433>;databaseName=<DB: DB_NAME>;integratedSecurity=true