Guides
Employees
macOS
DataGrip for MSSQL on MacOS

DataGrip for MSSQL on MacOS

1. Installation

Download and install DataGrip from the official JetBrains website.

License Activation On first launch, use the License Server (when on campus) or your Educational License (Student Account). Connection: Ensure you are connected to the VPN or campus network.

2. Kerberos Authentication

To connect to MSSQL on macOS, you must first obtain a Kerberos ticket.

Important Configuration Due to a driver bug, you must set useDefaultJaasConfig to true in the Advanced tab of the connection settings later.

Using Ticket Viewer

  1. Open Ticket Viewer (search via Spotlight Cmd + Space). Ticket Viewer - Initial Window
  2. Click Add Identity. Ticket Viewer - Add Identity
  3. Enter credentials:
  • Identity: sXXXXXXXX@pjwstk.edu.pl
  • Password: Your student password
  1. Verify the ticket is active. Ticket Viewer - Active Ticket

Using Terminal

  1. Open Terminal.
  2. Run the command:
kinit sXXXXXXXX@pjwstk.edu.pl
  1. Enter your password when prompted.
  2. Verify the ticket with klist.

3. Configuration

Data Source

  1. Go to File > Data Sources and Drivers (or Cmd + ;).
  2. Click + > Microsoft SQL Server.

Connection Details

Fill in the fields:

FieldValue
HostDB-MSSQL16.pjwstk.edu.pl
Port1433
AuthenticationKerberos
Database2019SBD
UsersXXXXXXXX@pjwstk.edu.pl
PasswordYour student password

Data Sources and Drivers

Advanced Settings

Go to the Advanced tab and ensure useDefaultJaasConfig is set to true if dealing with Kerberos issues.

Test

Click Test Connection. On success, click OK.

4. Alternative Methods

Alternative: jTDS Driver (Legacy)

If Kerberos fails, try the jTDS driver:

  1. Select Driver: Microsoft SQL Server (jTDS).
  2. Auth: User & Password.
  3. User: sXXXXXXXX (ID only).
  4. Advanced Tab:
    • USENTLMV2: true
    • DOMAIN: PJWSTK
Alternative: Virtualization
Use Omnissa Horizon or a Windows VM (Parallels/UTM) to run SSMS natively.
VPN for MacOSConnecting to Oracle Database in DataGrip on macOS