Error connecting to database, failed to retrieve data for this request

Question

I recently upgraded to SQL Server Management Studio 2019 (v18.7.1). I also have SSMS 2012.

When I use SSMS 2012 to connect to a database running on Window Server 2016 / SQL 2017, I usually get an error like below but I can connect and run queries and see the underlying SQL. However , I am unable to connect using SSMS 2019. Can you advise what can be done?

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)

---

The EXECUTE permission was denied on the object 'xp_qv', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

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

---

BUTTONS:

OK

---

Answer 1

SQL Server Management Studio (SSMS) is the tool which can be used to query, design and manage the databases. The latest release number is 19.0.1 (here 19 DOES NOT mean 2019) which was released on Feb 2, 2023. There is no SSMS 2019 or 2012. Microsoft suggests that if you have a preview version of SSMS 19 installed, you should uninstall it before installing SSMS 19.0.1. If you have SSMS 19.0 installed, installing SSMS 19.0.1 upgrades it to 19.0.1. Here is the link to "Download SQL Server Management Studio (SSMS)".

Answer 2

TITLE: Microsoft SQL Server Management Studio

---

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

For help, click: https://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)

---

C:\business analytics with excel\SHADMEHR.csv is not a primary database file. (Microsoft SQL Server, Error: 5171)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-5171-database-engine-error

---

BUTTONS:

OK

---