Upgrade Issue 2016 to 2017

Rohit Kulkarni 656 Reputation points

Hello Team,

I have update the MS SQL Server from 2016 to 2017.The upgrade went fine.

But when i logged in to the instance and trying to change the database to 2017.

In the Propertires-->Options-->Compatibility Level

This option is blank. Please advise can any one.

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,152 questions
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 15,196 Reputation points Microsoft Vendor

    Hi @Rohit Kulkarni,

    Yes. You need install the latest SSMS. It seems that your SSMS is version 16.X. This only applies to SQL Server 2016 and prior versions. You can see your current SSMS version here.

    From the SSMS navigation bar click on Help->About.. :

    User's image

    SSMS 19.0.1 is the latest general availability (GA) version. You can install it.

    Best regards,


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

2 additional answers

Sort by: Most helpful
  1. Guoxiong 8,056 Reputation points

    I guess you use an earlier version of SQL Server Management Studio (SSMS). Try to use the latest version of SSMS and see if that solve your issue. Here is the link to Download SQL Server Management Studio (SSMS).

  2. Erland Sommarskog 72,736 Reputation points MVP