Connect Microsoft Azure SQL Data Base to Local SQL Server Management Studio

Hi,

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.

Step 01.

Create Data base on Azure.

  1. Go SQL Data Bases,then Add New

22.  Enter Data Base Details and Create Data Base with Server.

3

4

3.After Database created, click on database and get Properties, Copy server name to some where.

5

Step 02.

Open SQL Server Management Studio and Enter Azure SQL Server Details.

6

if you got error like below after you press connect.Please add Azure Sql Server firewall rule as below.

1

Rule Name : sp_set_firewall_rule

Start IP : Client IP

End IP : Client IP

7

Step 03.

Now you can connect Azure SQL data base using Azure SQL Data base credentials.

8

Thanks

 

Advertisements

Author: eshan1604

Hi Guys, I'm Udara Eshan Ariyarathne from Sri Lanka. Currently i'm working as a Software Engineer (Microsoft Technologies). I'm sharing some IT related articles such as Development ,Configuration and Designing things what i have learn from day to day works. Hope it useful all of us. "Enjoying IT" Thanks & Regards, Udara Eshan Ariyarthne

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s