Once here, you’ll have the option to choose an IP range. Setting an Azure SQL Server firewall rule Go to the resource page of the SQL Database you want to connect to and look for an option called Set Server Firewall. You can connect this to an existing Azure virtual network, or define an IP range that can access the database, which is what is done in the demos below. Next, you’ll need to login to the Azure Portal to make sure that your device can to connect to the database. For the love of Equifax, please use best practices for passwords when you set something like this up in QA or Production! The password I’m using isn’t the most secure, but it’ll do for demo purposes.

This database has a SQL admin (sa) user AtaAdmin and the password is Admin123. Using the instructions from the quickstart document, I’ve set up a sample database called ata-demo. There are dozens of different ways to connect to Azure SQL, and unfortunately I can’t go over them all, but the ones I will be covering in this post are:īefore you get started, you must make sure you have a database available and can connect to it. A Windows 10, Mac OS, or Linux laptop or desktop with PowerShell, Visual Studio Code and SQL Server Management Studio installed.An Azure SQL Database (You can use your own if you like, but I’ll be using the sample.If you’d like to connect to Azure SQL database, you’ll need to meet a few prerequisites ahead of time. Connecting to an Azure SQL Database with PowerShell.Connecting to an Azure SQL Database with Visual Studio Code (Code).Connecting to an Azure SQL Database with SQL Server Management Studio (SSMS).

Connecting to an Azure SQL Database with The Azure Portal.

Sql server management studio mac os