Home > Connect to Windows Azure Virtual Machine Using SSMS

Connect to Windows Azure Virtual Machine Using SSMS

In 2013, Microsoft made it available for customers to utilize virtual machines running in Windows Azure. This allowed customers to run an on-premises version of SQL Server, but have the instance hosted in the cloud. The natural question then became, “How do I connect to the Azure VM using SQL Server Management Studio (SSMS)?" Connecting to an instance of SQL Server running inside of an Azure VM can be completed in just a few steps:
  1. Create your VM
  2. Open a port for the VM inside the Azure management portal
  3. Open a port in the Windows firewall on the Azure VM
  4. Configure security for the instance; verify TCP is enabled
  5. Connect remotely with SSMS
It’s that easy. Let’s take a look at the steps in more detail.

Create your VM

First we will create an Azure VM. Here I will choose the “Quick Create” option that has an image of SQL 2012 SP1 running on Windows Server 2012: Connect Azure VM SSMS 1

Open a port in the Azure management portal

Once the VM is created, you will need to open up a port to allow access to the instance of SQL Server. I’m going to stick with the default port of 1433 and create a new endpoint here: Connect Azure VM SSMS 2

Open a port in the Windows firewall

Next up, we need to configure the firewall on the server itself. I will use Remote Desktop to connect to the server and get this part done. From the dashboard, I can click on "Connect" in the lower left: Connect Azure VM SSMS 3   This will open up an RDP session for me. From there I will configure a new inbound rule in the Windows firewall for port 1433: Connect Azure VM SSMS 4   I will select a rule type of ‘Port,’ as shown above. The port will be for 1433 because I’m showing a trivial example here. I’d encourage anyone actually opening up an instance of SQL Server like this to use a non-default port. After clicking next, the options I will select are as follows (sparing you from a bunch of screenshots):
  • Select TCP and specify port 1433
  • Next, select ‘Allows This Connection’
  • Then, select when you want the rule applied (I chose ‘Public,’ choose what is right for you)
  • Lastly, assign this rule a name (I chose SQL because I’m lazy)
Here is where I also would advise you to take a moment to verify that SQL Server is enabled to use the TCP protocol: Connect Azure VM SSMS 5

Configure security

Next, we will configure SQL Server to use mixed mode authentication for the purpose of a simple example. Note that Windows Azure does support Active Directory at this time, so this may be an option for you. We will change the security to ‘Mixed Mode’ and create a new SQL login: Connect Azure VM SSMS 6

Connect

After a restart to the instance we should be able to connect: Connect Azure VM SSMS 7 Voila! Connect Azure VM SSMS 8 Connecting to an instance of SQL Server running in an Azure VM is very simple and straightforward process. You are just a few clicks away from being able to access your instance running in an Azure VM from the client tools installed on your desktop.  
Thomas LaRock
Thomas LaRock
Thomas LaRock is a Head Geek™ at SolarWinds and a Microsoft® Certified Master, Microsoft Data Platform MVP, VMware® vExpert, and former Microsoft Certified Trainer. He has over…
Read more

Tweets

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Technology has helped streamline the healthcare industry thanks to the events of last year. Read why Head Geek… t.co/1xzEBHT5lm

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Learn how database performance monitoring resonates with software developers and why. Watch now. t.co/LAvLc9fD0K

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

The way we work has been drastically altered and the way orgs deal with the changes will determine its success. Rea… t.co/NJUpUFDDq7