question

JoannLiao-4647 avatar image
0 Votes"
JoannLiao-4647 asked Cathyji-msft commented

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

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Here's more details behind. Attached the screenshot, it's before upgrade to SQL Server 2017 from 2014. There were three instances. Then, I upgraded two out of three instances to SQL server 2017.

First step, uninstalled SQL Reporting services.
Second step, upgraded SQL Server 2014 to 2017.
Third step, re-Installed the SQL Reporting Services

87223-beforeupgrade.png


0 Votes 0 ·
beforeupgrade.png (183.4 KiB)

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft commented

Hi @JoannLiao-4647,

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JoannLiao-4647,

Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·