In this walkthrough we will see how to connect from Local SQL server management studio to SQL Azure. Follow the below steps.

Open SQL Server management studio

clip_image001

You will get Connect to server dialog box. Click cancel on that.

clip_image002

After cancelling the dialog box click on New Query from left top

clip_image003

On clicking New Query, you will get the connect to server dialog box again.

clip_image004

Now here you need to provide, Server name of SQL Azure and Login credential of SQL Azure.

To know what is database server name of SQL Azure portal, login to Windows Azure portal with your live credential and then click on SQL Azure tab

clip_image006

You will get the server name in form of

abc.database.windows.net

Where abc is name of your SQL Azure server. We need to provide this server name at local sql server management studio.

clip_image007

Make sure to select SQL Server Authentication and provide login user name and password of your SQL Azure database portal.

After that before clicking Connect click on Option

clip_image008

Provide the database name you want to connect by default. I am connecting to Student database.

clip_image009

Now click on Connect to connect to SQL Azure

On successful connection to test

select * from sys.databases

You will get listed all your SQL Azure databases.

image

Advertisements

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