Assume you have already had Sql Server installed on your local machine, and SQL Server Management Studio installed on Windows Azure Virtual Machine.

1, Install Local Endpoint on both your local machine and Windows Azure VM, and add them to the same group. Steps can be found here.

2, Enable Sql Server authentication on your local machine;

a)      Double click the server in SSMS, and select properties;

b)      Select Security on the left;

c)       Under Server authentication, make sure “SQL Server and Windows Authentication mode” is select;

3, Open inbound connection to port 1433, on your local machine;

a)      Go to windows firewall, launch Advanced Settings;

b)      Select Inbound rules on the left, and click “New Rule…” on the right;

c)       Select Port in New Inbound Rule Wizard, click Next;

d)      Make sure TCP is selected, and put 1433 in Specific local ports text box, click Next;

e)      Select Allow the connection, click Next;

f)       Select Domain, Private and Public, click Next;

g)      Put whatever name in the Name field, click Finish;

4, Connect to Sql Server from VM

a)      Launch Sql Server Management Studio(ssms);

b)      In the Server Name, input your local machine’s name;

c)       Select proper Authentication, user and password (you probably need to select Sql Server authentication).

d)      Click Connect;

Troubleshooting:

  1. Make sure Sql Server has enabled TCP/IP, in SQL Server Network Configuration. This can be done in Sql Server Configuration Manager.
  2. Make sure Sql Server had enabled remote connection. You can double check by:

a)      Double click the server in SSMS, and select properties;

b)      Select Connections on the left;

c)       Make sure the “Allow remote connections to this server” is checked.

  1. Instead of opening connection to port 1433, create an inbound rule, to allow sqlservr.exe through the firewall. Sqlservr.exe usually located under C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn;
  2. Currently local endpoint will fail if you install it on Windows 8. To workaround this, save the installer on you disk, open the property dialog, go the Compatibility tab, select “Run this program in compatibility mode for:”, and in the select Windows 7 in the dropdown list. Then run the installer.