question

chrissar-2833 avatar image
1 Vote"
chrissar-2833 asked AlbertoMorillo commented

SSMS Failing to retrieve Azure database information

Hi!

I've been using an Azure SQL database in conjunction with SSMS for 4 years now and have never had an issue. A week ago, it started acting up.

My connection to the database server works fine, but when I try to expand the database folder, I get the following message:

TITLE: Microsoft SQL Server Management Studio



Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476


ADDITIONAL INFORMATION:

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



GetDatabaseServiceObjectives operation failed. Please retry. (Microsoft SQL Server, Error: 42019)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2148&EvtSrc=MSSQLServer&EvtID=42019&LinkId=20476


BUTTONS:

OK



If I create a new query, I am still able to use the databases I want, but they aren't visible in the usual directory. The only viewable database there is master.

Any help to resolve the matter would be appreciated.

Cheers,

Chris

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo commented

Please download the latest version of SQL Server Management Studio from here. Keep always updating your SSMS to get the best user experience with Azure SQL Database.

If the latest version does not work, please uninstall SSMS and give a try to previous versions. Visit here.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That worked! I had two version of SSMS. I uninstalled both, restarted my PC, and installed the latest version of SSMS. Thanks for your help.

0 Votes 0 ·

You are always welcome. Thank you for visiting Microsoft QA forums!

0 Votes 0 ·