How to Connect SQL Server to DBeaver

How do I connect Microsoft SQL Server to DBeaver?

Open DBeaver, add a new Microsoft SQL Server connection, supply the JDBC URL, credentials, and test; DBeaver will auto-install the driver, letting you run T-SQL instantly.

Welcome to the Galaxy, Guardian!

Oops! Something went wrong while submitting the form.

Description

Why choose DBeaver for SQL Server?

DBeaver offers a free, multi-platform IDE with JDBC support, visual ERD, data import/export, and plug-ins that make managing SQL Server as easy as PostgreSQL or MySQL.

What do I need before connecting?

Ensure Microsoft SQL Server is reachable via TCP/IP, note the host, port (default 1433), database name, and a login with "SQL Server Authentication" or Active Directory credentials.

How do I add a new SQL Server connection in DBeaver?

Step 1: Launch New Connection Wizard

Click the plug-icon ➜ Database ➜ New Connection.

Step 2: Select Microsoft SQL Server

Type "sql" in the filter and pick "Microsoft SQL Server".

Step 3: Enter server details

Fill Host, Port, Database, User, and Password. Toggle "Save password" if desired.

Step 4: Test & download driver

Click Test Connection. DBeaver downloads the MS SQL JDBC driver automatically. A green check confirms success; press Finish.

Can I use a JDBC URL directly?

Yes. Open the Edit Driver Settings ➜ Driver Properties tab and paste a URL such as:
jdbc:sqlserver://prod-db.acme.com:1433;databaseName=shop;encrypt=true;trustServerCertificate=false

Which advanced settings matter?

Enable Auto-commit for quick DML, raise Fetch size for large exports, and activate Server Time Zone when timestamps look off.

How do I query the sample ecommerce tables?

Open a SQL Editor tab connected to shop and run the example below. Results appear in the bottom grid and can be exported to CSV or JSON.

Why How to Connect SQL Server to DBeaver is important

How to Connect SQL Server to DBeaver Example Usage


-- Top 5 customers by revenue in the last 90 days
SELECT TOP 5 c.id, c.name, SUM(oi.quantity*p.price) AS recent_revenue
FROM Orders o
JOIN Customers c  ON c.id = o.customer_id
JOIN OrderItems oi ON oi.order_id = o.id
JOIN Products p   ON p.id = oi.product_id
WHERE o.order_date >= DATEADD(day,-90,GETDATE())
GROUP BY c.id, c.name
ORDER BY recent_revenue DESC;

How to Connect SQL Server to DBeaver Syntax


JDBC URL syntax:
jdbc:sqlserver://<host>:<port>;databaseName=<database>;user=<user>;password=<password>[;encrypt=<true|false>][;trustServerCertificate=<true|false>]

Example with ecommerce DB:
jdbc:sqlserver://db.internal:1433;databaseName=shop;user=analyst;password=s3cret;encrypt=true;trustServerCertificate=false

Basic query syntax (T-SQL):
SELECT c.id, c.name, SUM(oi.quantity*p.price) AS lifetime_value
FROM Customers c
JOIN Orders o  ON o.customer_id = c.id
JOIN OrderItems oi ON oi.order_id = o.id
JOIN Products p ON p.id = oi.product_id
GROUP BY c.id, c.name;

Common Mistakes

Choosing Windows Authentication when the server only allows SQL Server Authentication. Fix by switching the dropdown in the connection wizard or adding <code>integratedSecurity=false</code> in the JDBC URL.
Omitting <code>databaseName</code> in the JDBC URL, which lands you in <em>master</em>. Always add <code>;databaseName=shop</code> so scripts hit the intended schema.