F.A.Q.

How to connect to an SQL Server using Windows Authentication?

  • 18 January 2022
  • 0 replies
  • 309 views

Userlevel 5
Badge +9

There are two ways to do this, using two different drivers

Right-click Databases > New Database Connection.

 

Connect via the JDBC driver:

select MS SQL in the Database type field

add integratedSecurity=true to the end of the connection string.

For example jdbc:sqlserver://localhost:1433;databaseName=test1;integratedSecurity=true

 

 

Connect via the jTDS driver:

select jTDS - MS SQL in the Database type field

specify a connection string in the following format

jdbc:jtds:sqlserver://localhost:9876/test1;domain=company

fill in Username and Password

 


0 replies

Be the first to reply!

Reply