I'd like to check what/how do I set to allow SQL Server being installed in Microsoft Windows Azure to be able to be connected from my local/domain machines?
TQ
Asked
Active
Viewed 1,178 times
1
-
Are you talking about Azure SQL Database or SQL Server installed in VM? – Gaurav Mantri Apr 02 '15 at 06:47
-
Possible Duplicate of http://stackoverflow.com/questions/24075686/azure-database-connection-error/24075945#24075945 – sudhansu63 Apr 02 '15 at 10:14
1 Answers
0
Do you want to Access your Azure SQL database from your local machine?
You need to add the IP-address of your local machine to the allowed addresses that can access the database. You can do this in the azure management portal:
Sorry my screenshot is in German, but the link should be at the same Position. It should be called 'Manage allowed IP-addresses' or something similar in English. There you can add the IP-address of your local machine. After that you can access the database from that computer.
Alexander
- 1,021
- 6
- 20
- 38
-
Added the same answer in English version http://stackoverflow.com/questions/24075686/azure-database-connection-error/24075945#24075945 – sudhansu63 Apr 23 '15 at 05:11