Skip to main content
F.A.Q.

How to connect to an SQL Server using Windows Authentication?

  • January 18, 2022
  • 0 replies
  • 522 views

DannyRyan
Ataccamer
Forum|alt.badge.img+2
  • Head of Technical Training
  • 41 replies

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

 

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings