Guides
Employees
Linux
DataGrip for MSSQL on Linux

DataGrip for MSSQL on Linux

Prerequisites

Requirements

  • DataGrip installed.
  • Active connection to VPN or campus network.
  • Driver: This guide uses the jTDS driver.

Configuration

Data Source

  1. Go to File > Data Sources and Drivers (or Ctrl + Alt + Shift + S).
  2. Click + > Microsoft SQL Server.

Connection Details

Set the Driver to Microsoft SQL Server (jTDS). Fill in:

FieldValue
HostDB-MSSQL16.pjwstk.edu.pl
Port1433
AuthenticationUser & Password
Database2019SBD
UsersXXXXXXXX (ID only)
PasswordYour student password

Data Sources and Drivers

Advanced Settings

Go to the Advanced tab and set:

  • USENTLMV2: true
  • DOMAIN: PJWSTK

Advanced

Test

Click Test Connection. On success, click OK.

Shared Disk on LinuxConnecting to Oracle Database in DataGrip - Linux