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:

FieldValue
Database typeSQL Server
Port1433, SQL Server's default.
Database nameThe 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.

Was this page helpful?