Friday, October 10, 2014

2 Microsoft Azure SQL Database

Microsoft Azure SQL database is specialize flavor of SQL server host in the Microsoft Azure .

Create the Azure is very simple and just few click step in the wizard. However, when I try to connect to it through SSMS, I get the error :

image

The error is clear, we need to add the client IP to connect to the server.

I am using the new preview version of Microsoft Azure.  I can not find the way to configure the IP in the new portal . I have go back to the old version of the Azure Portal.

image

Click the server –> CONFIGURE to add the Client IP

image

image

After it is done. I can connect to the Server from SSMS.

image

Reference

http://azure.microsoft.com/en-us/documentation/articles/sql-database-manage-azure-ssms/#Step2

2 comments:

  1. Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates