mssql:// and sqlserver:// (identical behavior):
Azure SQL
Use your.database.windows.net hostname. Azure SQL requires encryption.
SSL / TLS
Both default totrue when unset.
Local with self-signed cert:
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Connect Tamery to Microsoft SQL Server or Azure SQL: connection string format and SSL/TLS options.
mssql:// and sqlserver:// (identical behavior):
mssql://username:password@hostname:1433/database
| Part | Description |
|---|---|
username | SQL Server login (e.g. sa) |
password | Password for that login |
hostname | Host (e.g. localhost or a remote address) |
1433 | Port (default) |
database | Database name |
.database.windows.net hostname. Azure SQL requires encryption.
sqlserver://username:password@your-server.database.windows.net:1433/your-database?encrypt=true&trustServerCertificate=false
true when unset.
| Parameter | Description |
|---|---|
encrypt=true | Encrypt the connection. Required for Azure SQL. |
encrypt=false | No encryption. Local dev only. |
trustServerCertificate=true | Skip certificate validation. Local dev with self-signed certs. |
trustServerCertificate=false | Validate against a trusted CA. Use in production and Azure SQL. |
mssql://sa:password@localhost:1433/mydb?encrypt=true&trustServerCertificate=true
sqlserver://username:password@hostname:1433/database?encrypt=true&trustServerCertificate=false
SQLEXPRESS, URI-encode the backslash: localhost%5CSQLEXPRESS. When
in doubt, use 127.0.0.1 with the explicit port.