Friday, October 10, 2014

0 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

0 comments:

Post a Comment

 

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