Note: If setting up a cloud connection to Azure SQL database, or you get a
USE statement is not supported to switch between databases error, you should try connecting using Azure Synapse .
- Open the connections page in preferences, see managing connections for more information.
- Click the
Add new Connectionbutton at the top of the connections page.
Microsoft SQL Serverfrom the list.
- Give a
Connection namefor your own internal reference.
Hostname, enter the hostname of your database server.
Port, use the default
1433, or enter the port used by your server.
Database, enter the name of your database.
Domain, enter your the domain name for the server. This is optional.
Password, enter the username and password for SQL Server. These are optional.
- Toggle connection type for direct or cloud.
- Share the connection with your team.
SSLsettings. These are optional.
Connectand you're all set!
Happy querying! 🍭
Updated 13 days ago