Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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&ProdVer=11.00.9164&EvtSrc=MSSQLServer&EvtID=208&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)
share|improve this question
    
What's the version of SSMS? From that version number, it looks like 2014. If that's correct, you may be out of luck, or you should report it as a bug on Connect. –  Jon Seigel Oct 7 '13 at 16:27
add comment

1 Answer

up vote 1 down vote accepted

there can be couple of issues -

  1. 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)
  2. 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

    enter image description here

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.