Microsoft at it again. So my SQL object explorer in Visual Studio stopped working and shows the error in yellow. The mentioned element is a symmetric key that I generated in order to use AES encryption. Now having it is useless for me because I have to open SSMS if I want to checkout a table structure. Any ideas on how to get this solved?
EDIT
Please stop answers specifying to update Azure SDK, it's not related and has not worked
Open your project in Visual Studio. In Solution Explorer, right-click the Connected Services node, and, from the context menu, select Add Connected Service. In the Connected Services tab, select the + icon for Service Dependencies. In the Add Dependency page, select Azure SQL Database.
Azure fully supports running any edition of SQL Server on IaaS (VM). Combined with 'Always On' availability groups you will be able to achieve full compatibility with legacy on-premises SQL installs.
Use that latest Visual Studio 2019 Community edition, which contains the latest version of SQL Server Data Tools with SQL Server Object Explorer
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With