- Download the Microsoft JDBC Driver 4 for SQL SERVER :
- Output - sqljdbc_4.0.2206.100_enu.exe. Its available at Microsoft site.
- Run the above downloaded exe and it will create a folder ‘Microsoft JDBC Driver 4.0 for SQL Server’ at the downloaded location/ we may change the folder location.
- From the Folder ‘Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu
- Copy the sqljdbc_auth.dll file from ‘Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\auth\x64’ to ‘LISA\jre\bin’ folder
- There are 2 versions of this dlljrelisa. If it’s difficult to ensure the version then we can try by copying one or another dll.
- In LISA workstation – In JDBC test step –set the JDBC Driver and Connection string as shown below:
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String: jdbc:sqlserver://serverNm:1433;integratedSecurity=true
- Click ‘Test Connection’.
- If TCP/IP port is not enabled then need to enable it from SQL server configuration manager –client network configuration and also might need to add port in ‘IP ALL’ tab.