Upgrade SQL server to 2017 but, the result displayed no 14x with compatible list and version looks

Joann Liao 21 Reputation points
2021-04-12T23:37:46.73+00:00

I had completely upgraded two out of three instances to SQL server 2017 from 2014. Both upgraded successfully. However, the result via SSMS) looks weird e.g. version number and compatibility level did NOT listed 14x or SQL Server 2017. Please refer to the attached screenshot.

Please help/ advise.

87163-sqlupgrade2017issues.png

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

Accepted answer
  1. CathyJi-MSFT 20,671 Reputation points Microsoft Employee
    2021-04-13T03:26:35.343+00:00

    Hi @Joann Liao ,

    According to your screenshot, did you connect to default instance(MSSQLSERVER) in SSMS? The default instance is SQL 2017 now, but it is still showing SQL 2014 version in SSMS.

    SSMS Object Explorer Showing Blue Question Mark for SQL Server default instance, this means that SSMS does not know if the service is running or not, by way of a WMI call. Make sure SQL server instance is running, check this from SSCM. Please close the SSMS, run the SSMS as administrator, then connect to default instance. A white arrow on a green circle icon is the correct state for SQL server instance. If this is still not work, try the suggestion from this thread.

    After connect to SQL server, please using select @@version to check SQL server version.

    By the way, we can also get the SQL server version from error log as below screenshot.
    87138-screenshot-2021-04-13-112325.jpg


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.


0 additional answers

Sort by: Most helpful