Connecting to SQL Server with Integrated Auth

• 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.