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