Hello,

I'm trying to connect to my Azure SQL Server and i'm not able to do so. i receive the following error:

Cannot open server 'kztgi9z11x.database.windows.net' requested by the login. Client with IP address '94.187.18.4' is not allowed to access the server. Login Failed for User 'hayekmichel'. (Microsoft SQL Server, Error: 40615).

I even tried the http://hanssens.org/tools/sqlazuremanager/ tool but got the same issue.


Thanks;
Mike

• Changed type MikeJH73 Friday, October 16, 2009 8:16 PM

the SQL Azure firewall prevents all access to your SQL Azure server until you specify which computers have permission.

Initially, all access to your SQL Azure server is blocked by the SQL Azure firewall; connection attempts originating from the Internet or Windows Azure will not be able to reach your SQL Azure server. In order to begin using your SQL Azure server, you must go to the SQL Azure portal and specify one or more firewall settings that enable access to your SQL Azure server. Use the firewall settings to specify which IP address ranges from the Internet are allowed, and whether or not Windows Azure applications can attempt to connect to your SQL Azure server.

• Marked as answer by MikeJH73 Friday, October 16, 2009 10:02 PM
• Unmarked as answer by MikeJH73 Friday, October 16, 2009 10:02 PM
• Marked as answer by MikeJH73 Friday, October 16, 2009 10:04 PM

Great, it worked. Sorry i missed the firewall issue.
Thank you so much.
Mike

• Marked as answer by MikeJH73 Friday, October 16, 2009 10:03 PM

Try this tool help you troubleshoot all Azure SQL Database issue:

http://support.microsoft.com/kb/2980233