Home > SQL Databases > Connecting Azure SQL Database using SQL Server Management Studio

Connecting Azure SQL Database using SQL Server Management Studio

There are multiple ways of connecting Azure SQL Server

  • Connect by SQL Server Name
  • Connect by URL
  • Connect by FQDN

 

Connect by server name require you host name configuration changes at your end or you should have your VPC / VPN .You can read more here on the guidelines for Connecting to Azure SQL Database.

In this post we will see how to connect Azure SQL Database using SQL Server Management Studio and PowerShell.

I assume that you have a Azure Database Created using Azure Portal and the login information which was provided at the time of database creation.

 

image

Click on the database , it will take you to the database information page, here you will see [Connect to your database] and the Server details.

image

image

Copy the Server Information  (Server: faw5udm867.database.windows.net,1433)

open SQL Server Management Studio and pass the details as below. You may get Error while connecting for the first time which is to allow access to you IP Address.

To get you IP Address added to the Azure firewall rule follow the below steps on Azure Portal.

image

image

Categories: SQL Databases
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: