- Download Microsoft JDBC driver package from here (download the tarball package)
- Unzip the package and copy sqljdbc_auth.dll simply to system32 folder or any location defined in PATH
- Copy sqljdbc4.jar to any location
- Setup SQL Server jdbc driver in SQL Workbench, point the jar to the sqljdbc4.jar
- Create a new connection using the sample URL
jdbc:sqlserver://[hostname]:[port];integratedSecurity=true;databaseName=[database_name];
Wednesday, May 28, 2014
Connect to SQL Server in SQL Workbench Using Integrated Windows Authentication
Just a quick note to anyone may be looking for the steps:
Subscribe to:
Posts
(
Atom
)