Visual Studio 2017 Show Table Data does not work

Question

I am using Visual Studio 2017's 'Server Explorer' to connect to a Microsoft SQL database. I set up the connection and successfully connect to the database and can see the tables. However when I choose the 'Show Table Data' from one of the tables, I get the error 'An unexpected error occurred while populating the table or view information.'

Interestingly, if I execute the query: 'SELECT * from table' for the same table, this seems to work correctly and shows the table data.

Note also, that if I use Visual Studio 2010, I can connect to this same database and everything works as expected.

Does anyone have an idea why this does not work in the 2017 version?

Thanks.

Answer 1

I solved it by deleting the connection and adding it again. No need for restarting. I use Microsoft Visual Studio Community 2019.