[TechCorner] Correct configuration of JDBC DataSource with SQL Server

Hey Everyone,

 

Quite often, you have a task to configure the JDBC Datasouce with SQL Server that uses Windows authentication. However, you may face the following errors:

Can't get the Connection for specified properties; 
com.microsoft.sqlserver.jdbc.SQLServerException: 
This driver is not configured for integrated authentication.

or 

 

Failed to init connection for driver 
[com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString 
[jdbc:sqlserver://<ip address>:<port>;databaseName=<database name>;integratedSecurity=true]

 

There are some tricks you need to do in SoapUI to set up the connection correctly. I’ve prepared a Knowledge Base article that explains all configuration steps in detail.

 

FIND THE SOLUTION HERE

 

Let me know if you have any questions on the article.

 

Good luck with testing!