I've seen several instructions (such as this) explaining how to enable outside apps to connect to the Azure database.
The instructions always mention a Firewall option in the General Settings.
My Azure portal does not display "Firewall" in the General Settings. This seems to be preventing me from connecting from SQL Server.
When I try to connect to SQL Server from SSMS it says: "Your client IP address does not have access to the server. Sign into an Azure account and create a new firewall rule to enable access.
Then when I click "Add my client" or "Add my subnet range" it says "In progress..." and spins perpetually.
How do I enable access from SSMS (sql server management studio)?
EDIT:
On my screen I only see "SQL database" and not "SQL server". I wonder if that makes a difference? And how can I see the other one?
Also instead of the firewall link shown below I see something about Geo-replication role. Weird.
What would put me on that track?
Can SQL database only be seen from within Azure while SQL server can be seen from the outside? If so, I'm not sure how I would set up the schema, etc. I guess I could CodeFirst everything ...
EDIT:
OK, looks like there is a difference between SQL database option (from the left hand menu that says "SQL databases" and the VM-based SQL server option (from the virtual machine section on the left hand menu. See here.
Still not sure how to enable my IP or connect from Sql Server Management Studio ...
