Connecting to sql azure from ssms throw exception 'sys.configurations' Connecting to Sql Server Azure from MSSQL Server MGMT Studio, following exception occures :

Cannot connect to xxxxxxxxx.database.windows.net

An exception occured while executing a Transact-SQL Statement or batch.
   (Microsoft.SqlServer.ConnectionInfo)

sql management studio connection to windows azure invalid exception object name 
'sys.configurations'


Any clue ?

And here's the whole message : Cannot connect to ndkkyxvogj.database.windows.net.

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.CheckDacAndSmo(SqlConnection sqlConnection) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Invalid object name 'sys.configurations'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=11.00.9164&amp;EvtSrc=MSSQLServer&amp;EvtID=208&amp;LinkId=20476

Server Name: ndkkyxvogj.database.windows.net Error Number: 208 Severity: 16 State: 1 Line Number: 17

Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)
there can be couple of issues -

Firewall : You will need to add your local IP range to the allowed SQL Azure Firewall rules. Refer to : How to: Configure the Server-Level Firewall Settings (Windows Azure SQL Database)

You are using older/unsupported version of SSMS. If yes, then upgrade to the latest version (e.g SSMS 2008R2 - build 10.50.** Refer : SQL Azure July 2011 Service Release


You might be hitting - Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)