If you come across a database, where several functions like report and changing the recovery model are greyed out.
The issue is caused either by
- IIS installation broken / IIS Role not installed correctly
- SSMS is not run as admin
- SSMS is logged in with a user with not sufficient privileges
- SSMS is not supporting the SQL DB Version.
For example the customer was trying to manipulate a 2017 DB with a 2012 SSMS.
Note: SSMS is very much backwards compatible. Always install the newest version. The newest release can always be found here.
Support for SQL Server 2022, SSMS 19.0 is the first release that is fully aware of SQL Server 202. You can download it here.
This is the page to the previous releases of SSMS, even though they shouldn't be needed.
Note: It is possible to run successfully two versions of SSMS on one machine. Make sure you utilize the right one for your purpose.
In the past the SSMS was included in the SQL installer, but this has changed for better and faster development and bug fixing.
Other:
IIS. Microsoft has its own webpage for IIS which can be found here
MS SQL Lifecycle, webpage with the EOL Dates for all MS SQL Versions
Search terms: SQL Server Management Studio, missing options, function not available, can't select