My sql installation got interrupted thus corrupting my installation. And then I got this error "Invalid command line argument. Consult the Windows Installer SDK for detailed command line help"

Abdulion Messi 0 Reputation points
2023-03-09T05:55:08.9566667+00:00
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,571 Reputation points
    2023-03-13T07:48:16.86+00:00

    Hi @Abdulion Messi ,

    There are the following possible causes of error 1639:

    • The name of the installation directory has space in it.
    • Remnants of the previous installation that leave orphaned entries in the windows installer registry.
    • Another service running in the SQL port.
    • The issue with the Windows temp folder.

    The first reason is the most common one.

    https://www.mssqltips.com/sqlservertip/5315/fixing-sql-server-installation-error-1639/

    You will need to uninstall the failed installation cleanly and reinstall it.

    Please follow the below steps to remove all components of previous installed SQL Server completely:

    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

    1. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
    2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
    3. 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".

    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.