Create SQL Azure And Access Through Microsoft SQL Server Management Studio

Requirement

  • Azure Account.
  • No proxy network.

Step 1: Login to the new portal by clicking here.

Step 2: Add SQL database

From the left side menu, choose SQL database and click the add button to create a new SQL database.

Database

It will ask you to fill in the details.

details

Step 3: Create New Server

Click to create new Server.

new

Give all the details of the Server.

details

Click select and create button; it will create a Server and a database.

Server

Server

Deployment Started. After it completes, you will get SQL database, which is ready to access.

Database

Step 4: Access through SSMS

Open your SQL Server Management Studio (SSMS), give Server name and the credentials.

SSMS

It will give you an error or a message, showing it cannot connect to the server.

Step 5: Add Client IP address to Firewall

Add your IP Address to the server’s firewall setting.

Select Server and choose the settings. In the setting, choose firewall and save your IP address.

Settings

Settings

Settings
Settings

Here, you can see your IP address is already displaying. I have hidden it with a  red mark.

Click Add Client IP.

Add

It will appear in the below section.

section

Also, you can give the name of your IP.
name
Here, I am giving the name “MyPC”.

Now, save the setting and you are able to connect to the Server.

setting

setting

Here we go, settings are updated and we are now able to access SQL database.

Database

Up Next
    Ebook Download
    View all
    Learn
    View all