Forum Discussion

NK12's avatar
NK12
Occasional Contributor
7 years ago

Unable to Connect SQLSERVER DB by using JDBC step

Have used all the pre-requisites   Copied all the JAR files -sqljdbc41 and sqljdbc42 in ext and lib folders   Copied sqljdbc_auth.dll in bin folder   Used the driver name as-   com.microsoft....
NK12's avatar
NK12
Occasional Contributor
7 years ago

Thanks for your help!!

 

Finally I'm able to make the successful connection

 

SQL Server DB is running in host environment not in local

 

Used the below steps

 

1.Copied

                  bin\ext folder contains sqljdbc41.jar

                  bin folder contains sqljdbc_auth.dll

 

2. Driver Name as com.microsoft.sqlserver.jdbc.SQLServerDriver

 

3. Connection String as jdbc:sqlserver://<Instannce Name>;databaseName=<DB Name>;integratedSecurity=true

 

Thanks!!