MSSQL with datagrip

How do I connect SQL server 2019 developer to datagrip without installing SSMS (SQL Server Management Studio)?

The documentation for datagrip only mentions the express version not the developer version and uses user password for Authentication. I would like to  use windows credentials for Authentication

I have tried:

1. Connect to datagrip with developer version and with SSMS installed

with the following settings:

Host: localhost

Port: 1433

Instance: MSSQLSERVER

Authentication: Windows credentials

 

Result:

It connects only I can’t see my databases only the generated databases like master etc.

And I can't create databases.

 

2. Connect to datagrip with developer express and without SSMS installed.

with the following settings:

Host: localhost

Port: 1433

Instance: SQLEXPRESS

Authentication: Windows credentials

 

Result:

Can't connect to instance.

 

For both tries I have set:

SQL Server Browser to start mode automatic and started the service in Sql Server Configuration Manager.

TCP/IP to start mode automatic and started the service set port to 1433 in Sql Server Configuration Manager.

SQL Server Agent to start mode automatic and started the service in Services.

As the documentation suggests.

I have not tried to create a new user in SSMS as the documentation suggests.

 

Is it also possible to import .bak files?

2 comments
Comment actions Permalink

Hi Merijn, you're aware of the fact that you can/must select the databases? In the picture you can see two connections. The first MariaDb (collapsed) and the second MSSQL Dev2019

1
Comment actions Permalink

Merijn Bauhuis100,

I didn't get, do you have MS SQL Server installed locally? Or do you want to install a local instance?

0

Please sign in to leave a comment.