question

RichMorrissey-0103 avatar image
0 Votes"
RichMorrissey-0103 asked RichMorrissey-0103 commented

Can't upgrade from SQL 2014 to SQL 2019

Trying to upgrade SQL 2014 standard to SQL 2019 standard, but when I run the wizard the only feature detected on the server is Integration Services. Ant idea why it wouldn't see the default instance installed on the server? I actually ran the new SQL install wizard and it wouldn't allow me to install to the default instance because it was already there.

sql-server-general
· 4
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.

What does "SELECT @@version" return? It could be that you are not on a service-pack level for which upgrades are supported.

0 Votes 0 ·

Did you follow the Procedure?


0 Votes 0 ·

Hi @RichMorrissey-0103 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't 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 ·
RichMorrissey-0103 avatar image
0 Votes"
RichMorrissey-0103 answered RichMorrissey-0103 edited

I found the cause of the issue and was able to resolve it. I tried to re-install SQL 2014 on top of the existing install and got a error message that it couldn't install because of a missing file in the installer folder. Having seen this error before when trying to install a SP, I tried using FixmissingMSI https://docs.microsoft.com/en-us/troubleshoot/sql/install/restore-missing-windows-installer-cache-files and it was able to repair the cache. Once that was done the upgrade to SQL 2019 worked as expected.

· 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.

Great to hear that you were able to sort it out! And big thanks for taking the time to report back, so it can help others!

0 Votes 0 ·
GuoxiongYuan-7218 avatar image
0 Votes"
GuoxiongYuan-7218 answered GuoxiongYuan-7218 edited
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.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered RichMorrissey-0103 commented

Hi @RichMorrissey-0103,

Agree with all.
And please refer to this docs.

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 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.

Yes, I've tried it with SQl service running, and stopped, same result

0 Votes 0 ·
RichMorrissey-0103 avatar image
0 Votes"
RichMorrissey-0103 answered

Yup it is service pack 3

Microsoft SQL Server 2014 (SP3-GDR) (KB4532095) - 12.0.6118.4 (X64)
Dec 12 2019 21:46:15
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)

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.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @RichMorrissey-0103,

Could you check this status?
115892-1.png
Check the status of the service, if it is not running, start the service.

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1.png (100.5 KiB)
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.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @RichMorrissey-0103,

If you just want to upgrade and don't need SQL Server 2014, it is recommended that you back up your database first, then uninstall the SQL Server cleanly and install SQL Server 2019.
If you want to use multiple versions, you can use named instances during installation.

You could follow below steps to delete SQL Server:
1. Uninstall the existing SQL Server and all the components from the add remove program.
2. Backup the registry.
3. Delete the following keys using regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
6. Rename all the SQL Server folders in the computer.
7. Reboot the machine.

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

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.