Connecting to SQL Server

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 .

1. Open the connections page in preferences, see managing connections for more information.
2. Click the Add new Connection button at the top of the connections page.
   
3. Select Microsoft SQL Server from the list.
   
4. Give a Connection name for your own internal reference.
5. For Hostname, enter the hostname of your database server.
6. For Port, use the default 1433, or enter the port used by your server.
7. For Database, enter the name of your database.
8. For Domain, enter your the domain name for the server. This is optional.
9. For Username and Password, enter the username and password for SQL Server. These are optional.
10. Toggle connection type for direct or cloud.
11. Share the connection with your team.
12. Configure SSH and SSL settings. These are optional.
13. Hit Connect and you're all set!

Happy querying! 🍭