Here i would like to explain how to connect Microsoft Azure SQL Data Base to Local SQL Server Management Studio, It’s very Easy to manage Azure SQL Data Base.Below are the Steps.
Create Data base on Azure.
- Go SQL Data Bases,then Add New
2. Enter Data Base Details and Create Data Base with Server.
3.After Database created, click on database and get Properties, Copy server name to some where.
Open SQL Server Management Studio and Enter Azure SQL Server Details.
if you got error like below after you press connect.Please add Azure Sql Server firewall rule as below.
Rule Name : sp_set_firewall_rule
Start IP : Client IP
End IP : Client IP
Now you can connect Azure SQL data base using Azure SQL Data base credentials.