How to set SQL Server Authentication Method in DataGrip?

sql-server datagrip
bigtunacan picture bigtunacan · Jan 4, 2016 · Viewed 9.3k times · Source

Is there a way to specify the authentication method (SQL Server or Windows Authentication) when connecting to SQL Server with DataGrip?

I have tried configuring using both the SQL Server(jTDS) and the SQL Server(Microsoft) drivers and don't see an option on either.

Answer

pwae picture pwae · Jan 7, 2016

With the jTDS Driver:

This is dependent on the settings for the connection/data source.

i.e. To set up a connection for Windows Authentication:

  1. In the "General" tab, if specify your Windows/AD Username in the User field.
  2. on the "Advanced" tab, in the DOMAIN property, specify the domain for the Windows account you put in Step 1.
  3. You may need to set USENTLMV2=true if Kerberos authentication isn't enabled on your network

If you don't specify the domain in step 2, it will assume you are doing a SQL Server Authentication login attempt.

With the Microsoft Driver:

I couldn't get this to work on OS X, but most people seem to have no issues on Windows.

  1. In the "Advanced" tab for the data source, set integratedSecurity to true.

n.b. you may have to also set this property for the actual Driver as well, on OS X i was getting continually "This driver is not configured for Integrated Authentication", but that could be OS X thing.

Hope this helps.

Related questions

How to quickly generate SELECT statement for a table in DataGrip?

In Microsoft SQL Server Management Studio (SSMS), you can right-click on a table, then go to Script Table as -> SELECT To, and then choose a destination for the generated script. Is there anything similar in DataGrip, or can …

Read More
How to connect to MS SQL Server Express in JetBrains DataGrip?

I'm trying to set up new tool from JetBrains: DataGrip to work with my local install of MS SQL Server 2014 Express. I spent some time trying to "convert" ms connection string to jdbc, but no luck. I can connect using …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More