Allow a home computer to connect to your Azure SQL server/database

When running Azure SQL, we can use the option Firewalls and virtual networks to configure how the DB administrator and applications will have access to the SQL server and databases. When trying to connect from home, in some cases (especially in DEV environments that you may not even be connected to the corporate network to test your code), you may want to allow your workstation to be able to connect. There are a couple of ways to connect your home computer to your Azure SQL server and database. The first one is by adding a client IP and use your public IP on the SQL server.

The second method is using SQL Management Studio on your workstation. Type the server name (make sure to use suffix .database.windows.net) and provide the credentials that you defined during SQL server creation. You will be prompt to authenticate on Microsoft Azure, and after the authentication is successful, a dialogue box to create a new firewall rule with your existing IP will be displayed. Just click OK, and that will grant you access to the feature above to connect to the SQL server.

Anderson Patricio

Anderson Patricio is a Canadian MVP in Cloud and Datacenter Management, and Office Server and Services, besides of the Microsoft Award he also holds a Solutions Master (MCSM) in Exchange, CISSP and several other certifications. Anderson contributes to the Microsoft Community with articles, tutorials, blog posts, twitter, forums and book reviews. He is a regular contributor here at Techgenix.com, MSExchange.org, ITPROCentral.com and Anderson Patricio.org (Portuguese).

Share
Published by
Anderson Patricio

Recent Posts

See the light: How to avoid webcam hacking

With so many employees video conferencing from home, the webcam may be a portal to…

3 days ago

Using Intel VTune Profiler performance analyzer on Hyper-V VMs

The Intel VTune Profiler performance analyzer can do more than monitor a system’s CPU utilization.…

3 days ago

The evolution of backup: Interview with Altaro’s Simon Attard

Backup is not the glitziest part of an IT pro’s job, but it may be…

4 days ago

U.S. Department of Veterans Affairs experiences data breach

A successful cyberattack initiated by a social engineering campaign has caused a data breach at…

4 days ago

How to turn off or restart Windows 10 updates: Step-by-step guide

In this article, we'll show you how to turn off or restart updates in Windows…

4 days ago

Five native Windows Admin Center extensions you need to know about

Windows Admin Center is becoming the tool of choice for managing Windows Server deployments. Here…

5 days ago