How to connect to a SQL Azure database using SQL Server Management Studio

Published on March 01, 2014 in Azure · Read time 3 minutes

If you are writing a website that will be deployed to Windows Azure, or indeed you are using SQL Azure as the backend for some other endeavour, chances are you will want to connect to that database with a management tool and query its data. You can achieve this in one of two ways; using Visual Studio or using SQL Server Management Studio. Using Visual Studio is fine, but I have been using SQL Server Management Studio for many years and I have grown accustomed to it, so it is my preferred tool. There are a couple of steps you need to take to make this work. Obtaining the connection information Both approaches require connection information and updates to the Windows Azure firewall rules, so we’ll do this first. Go to WindowsAzure.com and log in to the Management Portal. Select your SQL database and click the small arrow next to the name of your database (shown below). Under the Connect to your database header, click SQL Database connection strings for ADO .Net, ODBC, PHP and JDBC . Next, you need to update the Windows Azure firewall rules to allow access to your database. Switch back to the Windows Azure Management Portal, and under the Design your SQL database header, click…