SQL Server
Connect Microsoft SQL Server with the SQL Server database type. Azure SQL Database, Azure SQL Managed Instance and Amazon RDS for SQL Server connect the same way.
Connect a database
Add the database as in Connect a database, with these values:
| Field | Value |
|---|---|
| Database type | SQL Server |
| Port | 1433, SQL Server's default. |
| Database name | The database to query. |
Azure SQL requires an encrypted connection, so turn on Enabled in the Encryption section.
For the credential, create a read-only user. To keep QueryDesk's queries off your primary, connect a read replica.
Schemas
The schema sync reads every schema in the database. A table in dbo is named bare, as orders; a table in another schema keeps its schema, as billing.invoices.
AI read-only
SQL Server has no read-only transaction, so with Read only set, QueryDesk's parser is the only check. It refuses OPENQUERY, OPENROWSET and OPENDATASOURCE, which run SQL on another server. Give the AI's credentials a login with nothing beyond db_datareader. See AI governance.