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?
Please sign in to leave a comment.
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
Merijn Bauhuis100,
I didn't get, do you have MS SQL Server installed locally? Or do you want to install a local instance?