Connect to SQL Server using Datagrip on Windows 11

Question

I'm trying to connect to SQL Server 2022 using Datagrip in Windows 11 with Windows Authentication. These are the data that I have obtained when installing SQL Server and with the systeminfo command in the CMD: Instance Name: SQLEXPRESS SQL Administrator: ZEPHYRUS\dkval

Host:           localhost
Server Name:    ZEPHYRUS
User:           dkval
Port:           1433
Domain:         WORKGROUP

I have already tried the drivers: Microsoft SQL Server

In Advanced I put:

• integratedSecurity true

Microsoft SQL Server(jTds) In Advanced I put:

• domain WORKGROUP
• USENTLMV2 true

What would be the correct fields to fill in Datagrip?

Answer 1

This setup should be enough (works even without specifying the database):

Driver:

Tested on MS SQL Server 2022 and the latest version of DataGrip 2023.3.4.

Answer 2

Finally, I managed to establish the connection by configuring the port according to Md. Naushad Alam.

I had already entered SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, but I had edited the IP11 and IP12, but according to Md. Naushad Alam's answer, the IPAII has to be edited, after editing it, I restarted the service and The connection worked.

I will leave the configuration that finally worked:

SQL Server Configuration Manager

Datagrip

Thanks to @AlwaysLearning for explanation about the use of Instance vs Port and to @Koyasha for replicating the connection and specifying the driver version