Unable to install sql server 2019.Tried all available Solutions,did not worked

Anonymous
2022-12-17T07:45:57.037+00:00
SQL Server | Other
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,586 Reputation points
    2022-12-19T02:49:43.193+00:00

    Hi @Anonymous ,

    Here are the steps to uninstall cleanly.

    1. Remove all SQL Server components from 'Programs and Features'
    2. Backup the registry
    3. Delete the following keys in 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. Reboot the machine
      In addition, please use an administrator account to reinstall SQL Server on your computer (Right click->run as administrator).

    Best regards,
    Seeya


    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

3 additional answers

Sort by: Most helpful
  1. Ronen Ariely 15,206 Reputation points
    2022-12-17T08:57:36.467+00:00

    Good day @Anonymous and welcome to the Microsoft QnA forum

    I noticed in your details.txt file error code: 1639

    (12) 2022-12-17 11:54:10 Slp: Error result: -2068052377
    (12) 2022-12-17 11:54:10 Slp: Result facility code: 1212
    (12) 2022-12-17 11:54:10 Slp: Result error code: 1639

    Please check if the following discussion solve your issue:

    https://bobcares.com/blog/sql-server-error-1639/

    https://learn.microsoft.com/en-us/answers/questions/661340/sql-error-1639.html?WT.mc_id=DP-MVP-5001699


  2. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2022-12-17T11:22:02.027+00:00

    Reading detail.txt, I found this:

    (15) 2022-12-17 11:54:01 Slp: Running: C:\WINDOWS\system32\WBEM\mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\150\Shared\sqlmgmproviderxpsp2up.mof"
    (15) 2022-12-17 11:54:01 Slp: Microsoft (R) MOF Compiler Version 10.0.22621.1
    (15) 2022-12-17 11:54:01 Slp: Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.

    (15) 2022-12-17 11:54:01 Slp: File 'C:\Program Files (x86)\Microsoft SQL > Server\150\Shared\sqlmgmproviderxpsp2up.mof' not found!

    Can you check this folders and see what files you have in this folder. I checked my machine and I do have a file with that name in that location.

    Why you would not have one, I don't know, but which anti-virus are you running?

    By the way, I noticed another thing that you may want to change for your next installation attempt, although it is not related to this error. I see that your location is India and your have chosen the server collation SQL_Latin1_General_CP1_CI_AS. This is an old collation, and it does not support all characters used by languages in India. I would recommend that you select Indian_General_100_CI_AS_SC_UTF8.


  3. Peter Groft 106 Reputation points
    2022-12-20T06:35:54.17+00:00
    1. Launch the SQL Server Setup program (setup.exe) from SQL Server installation media.
    2. After prerequisites and system verification, the Setup program will display the SQL Server Installation Center page.
    3. Click Maintenance in the left-hand navigation area, and then click Repair to start the repair operation.
    4. Setup support rule and file routines will run to ensure that your system has prerequisites installed and that the computer passes Setup validation rules. Click OK or Install to continue.
    5. On the Select Instance page, select the instance to repair, and then click Next to continue.
    6. The repair rules will run to validate the operation. To continue, click Next.
    7. The Ready to Repair page indicates that the operation is ready to proceed. To continue, click Repair.
    8. The Repair Progress page shows the status of the repair operation. The Complete page indicates that the operation is finished.

    Hope This Works,
    Peter

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.