How to set SQL Server authentication method in DataGrip?

Question

Can I specify an authentication method (SQL Server or Windows Authentication) when connecting to SQL Server using DataGrip?

I tried tuning using the SQL Server (jTDS) and SQL Server (Microsoft) drivers and I don’t see any options.

Answer 1

JTDS driver:

It depends on the connection / data source settings.

i.e. To configure a connection for Windows authentication:

• On the General tab , enter the Windows / AD username in the User field .
• " DOMAIN Windows, 1.
• USENTLMV2 = true, Kerberos .

2, , SQL Server.

Microsoft:

OS X, , , Windows.

• IntegratedSecurity true.

n.b. , , , OS X " ", OS X.

, .