upgrading to sql server 2019 from sql server 2016 is not happening - unique issue

Hammad Ali Khan 0 Reputation points
2023-04-02T07:25:15.1333333+00:00

Hi Experts,

I am running into an issue during the upgrade of my sql server 2016 to sql server 2019. my installed default named instance is not detecting by the setup. it only upgrades the shared features. i have tried to repair the sql server 2016 instance but that is also not detecting the instance. it is a strange thing because my instance is working perfectly fine.

Also, any SPs or updates are not installing on that instance, when checked the error logs it says you have not an instance installed in this computer. while my instance is working fine.

FYI, my both installation medias are verified because i have another machine which was installed and upgraded by 2016 and 2019 respectively

please help me out from this issue because this is also happening my production sql as well.

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

1 answer

Sort by: Most helpful
  1. CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor
    2023-04-03T07:37:37.15+00:00

    Hi @Hammad Ali Khan

    Please refer to this doc for solutions: Restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update.

    Best regards,

    Cosmog Hong


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

    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.

    0 comments No comments