Supported connectors
Connect Microsoft SQL Server
Connect SQL Server or Azure SQL, one database or all of them.
Before you start
- You are an Admin or a Developer, or your role has the datasource Connect permission.
- Your firewall allows Databrain’s outbound IP on the database port. The form shows the IP under Setup guide > Allow the outbound IP. See Allow Databrain’s IP.
- You have a login that can read the database or databases you want to use.
Connect
-
Go to Data Studio > Datasources and select Connect data source.

Connect data source is at the top right of the Datasources page. -
Select MSSQL. You can type the name in Search connectors.

The MSSQL tile on the Add datasource page. -
Fill in the form:
Field What to enter Datasource name How this datasource appears in lists and pickers, for example Production warehouse.Server The SQL Server host. For Azure SQL, the server name from the connection string, for example myserver.database.windows.net.Port Usually 1433.Database Name The database to read. Enable Multiple Databases Sync every database on the server. Use it when each customer has their own database. Authentication username/password(default),Microsoft Entra password,Microsoft Entra service principal,Microsoft Entra access token,Microsoft Entra managed identity VM,Microsoft Entra managed identity App Service,Microsoft Entra default credentialorNTLM. The form shows only the fields the method needs.Read Replica Connect with read-only intent to a read replica. SSH Tunnel disablefor a direct connection. Chooseenableto connect through a bastion host, then enter SSH Host, SSH Port (22), Username and Private key (OpenSSH or PEM). -
Select Connect datasource.

Databrain checks the connection and reads your schema. You see Step 3 of 3 with Model your data. Next, create a datamart.
Grant read access
The user needs SELECT on the tables you want to model, and read access to information_schema so Databrain can read the schema. Replace the placeholders:
GRANT SELECT ON SCHEMA::<schema> TO [<user>];Where to find the values
- Server name: run
SELECT SERVERPROPERTY('MachineName'). - Azure SQL with several databases and SQL logins: create the login in
master. In each tenant database, runCREATE USER [<user>] FROM LOGIN [<login>];and grant SELECT. - Microsoft Entra: in each tenant database, run
CREATE USER [<app>] FROM EXTERNAL PROVIDER, then grant SELECT. Do not useDENY VIEW ANY DATABASEon Azure SQL.
If something goes wrong
If the check fails, the datasource stays on the form with Needs credentials. Fix the field the message names and select Connect datasource again.
- The database did not answer in time. A firewall blocks Databrain. Allow the outbound IP on the database port.
- The database rejected these credentials. Check the username and password, and that the user can sign in from a remote host.
- The credentials worked, but the user cannot read the catalogue. Run the grants above.
- The data source rejected the login. Check the Entra app, Tenant ID and credentials. For Azure SQL, check that the user can open the selected database.