How to connect to SQL Server 2014 with datagrip

Question

My SQL Server Management Studio is working but datagrip is not connecting to SQL Server. My local instance is IMZZA\sqlserver2014

BTW, users, check this tutorial: https://blog.jetbrains.com/datagrip/2016/06/21/connecting-datagrip-to-ms-sql-server/ — moscas, Jul 25 '16 at 11:51

score 1 · Answer 1 · answered Apr 12 '16 at 20:23

For instance "IMZZA\sqlserver2014", you have to enter like:

Host = IMZZA
Instance = sqlserver2014
Also Remove the value from Port, which is default 1433
Click "Test Connection" button. It should give you the "Connection successful" message.

These steps worked for me.

score 1 · Answer 2 · answered Apr 25 '16 at 14:59

1

Remember that TCP must be enabled in Config Manager

answered Apr 25 '16 at 14:59

moscas

score 0 · Answer 3 · answered May 17 '19 at 14:19

0

This only worked for me with SQL Server Browser Enabled and Running.

answered May 17 '19 at 14:19

Dan Walters

3 Answers3