SSMS: Compatibility Level Blank

After installing a new SQL Server 2016 or after upgrading your SQL Server to the latest version, you may get a strange issue. Open the SQL Server Management Studio, and you may notice that the compatibility level dropdown for all your databases is blank. What’s wrong here?

Issue

Fix

It will happen when you use lower version SQL Server Management Studio to connect to higher version SQL Server instance. So to solve this issue, simply run SSMS 2014 or SSMS 2016 and the list will be populated!

It works!

Thanks to this blog: blog.sqlauthority.com, I solved my issue.

 

Thanks for reading! You can follow me on Twitter @PrigentNico

About Nicolas 230 Articles
I work as a System Engineer, based in Switzerland with a primary focus on Microsoft technologies. I have 7 years experience in administering Windows Servers. . I am a Microsoft MVP for Cloud & Datacenter Management. I also received the PowerShell Hero 2016 award by PowerShell.0rg. And finally, I am "MCSA: Windows Server 2012" and "Administering & Deploying SCCM" certified.