Connecting Azure SQL from SQL Server Management Studio.
This post is a quick guide on how to connect to Azure SQL Database from SQL Server Managment Studio.
- Create a database in Azure SQL Server.
- Get the Server name.
- Add your local machine IP to Server firewall.
- Open Management Studio and enter credential. Username can be found in the
database properties.
- Test sql query against Azure SQL.