deepaksharma

Connecting to SQL Server with Integrated Auth

Discussion created by deepaksharma on Aug 21, 2015
  • 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.

Outcomes