In previous articles you have already learned how to Create/Activate Microsoft Azure Account and how to Create SQL Server and Database in Azure. If you have already completed previous two steps, then you may try to connect Azure SQL Database from your SQL Server Management Studio (SSMS) as described below in this article.
It is very simple to connect your cloud SQL database. The process is exactly similar like you connect traditional SQL server database.
In previous articles, we have already created new SQL server with name “myazuresql-server” and Database name “MyAzureSQLServer-Database”. You may try to connect that SQL server and database from your SQL Server Management Studio.
Connect Azure SQL Server Database from SSMS (SQL Server Management Studio)
- Open SQL Server Management Studio
- Do selections as follows and Click to Connect.
Note: If you are not sure about values mentioned above then have a look at our previous articles.
- You may have prompted to sign in for your Azure Microsoft Account to set the firewall rule. Click on Sign In and select Firewall rule – Add my client IP address & Click OK
Now your SSMS is ready to fire queries against Azure SQL Server Database. You can easily access Azure SQL databases, tables & views. You can do pretty much same you usually do it with traditional SQL database.
At this stage you only have created the Azure SQL Server and SQL Database. Check out other articles to create sample tables and play more with other Azure SQL database unique features.