For reference, I am using MS-SSMS version 14.0.17289.0 and I have Microsoft Visual Studio 2019 installed, on Windows 10.
I am unable to locate or open Object Explorer. I have installed the Microsoft SQL Express server to go through the database tutorial, however, when I go to the View dropdown menu there is no option for Object Explorer. I have tried going into View > Registered Servers and right-clicking on the server then clicking object explorer, but this does absolutely nothing. I have checked this by opening the Telemetry log, which records entries for opening the server menu but does not change when I click the object explorer option.
Why is Object Explorer not in the View menu, and why does clicking it from the server menu do nothing? How do I open it?
41 Answer
For reference I am using MS-SSMS version 14.0.17289.0 and I have Microsoft Visual Studio 2019 installed, on Windows 10. For reference, I am using MS-SSMS version 14.0.17289.0 and I have Microsoft Visual Studio 2019 installed, on Windows 10. I am unable to locate or open Object Explorer. I have installed the SQL Server 2017 Express.
You are using an incompatible version of Microsoft SQL Server Management Studio which does not support SQL Server 2017 Express. The simplest solution is to install the current version of Microsoft SQL Server Management Studio.
Why is Object Explorer not in the View menu, and why does clicking it from the server menu do nothing? How do I open it?
It likely has to do with the fact you are running an incompatible version of SSMS.
