Connect to Microsoft SQL Server to query and analyze your enterprise data. Supports tables with geometry and geography columns for spatial analysis.
Connect to SQL Server
- Click Add data in the Layers panel
- Go to the Connections tab
- Select SQL Server
- Fill in the connection parameters
- Click Create Connection
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| Connection Name | Yes | A friendly name to identify this connection |
| Host | Yes | Hostname or IP address (e.g., localhost, sqlserver.example.com) |
| Port | Yes | Port number (default: 1433) |
| Database | Yes | Database name to connect to |
| Username | Yes | Database username |
| Password | Yes | Database password |
| Schema | No | Default schema (default: dbo) |
SSL/TLS Configuration
Enable SSL/TLS for encrypted connections to your database. When enabled, you can optionally upload:
- Client Certificate: PEM or CRT format
- Private Key: PEM or KEY format
- CA Certificate: For server verification
Without a CA certificate, Atlas trusts self-signed certificates by default.
Working with Data
After connecting, browse available schemas and tables. Select the data you want to import and click Add to Project. Tables with SQL Server spatial columns (geometry, geography) import as vector layers.
Firewall Configuration
If your database is behind a firewall, whitelist these Atlas IP addresses:
16.16.129.130
51.20.23.178
13.50.71.210
51.21.188.73
Troubleshooting
| Issue | Solution |
|---|---|
| Connection Refused | Verify host and port. Check SQL Server is configured for TCP/IP connections. |
| Authentication Failed | Confirm credentials. SQL Server authentication must be enabled (not Windows only). |
| Database Not Found | Verify database name. Check user has access to the database. |
| Schema Not Found | Default schema is dbo. Verify schema exists and user has permissions. |
| SSL Connection Error | Try enabling "Trust Server Certificate" or provide a valid CA certificate. |