unable to install sql server exit code -2068052377

John Burks 11 Reputation points
2022-07-05T15:16:37.617+00:00

217705-ssms3.png

I was using 2018 ssms with sql server and it worked up to a few days ago.
I've tried several ways to fix this. I ran repair setup and goes thru the repair but still have the issue. I uninstall and reinstall. I check service.msc and and tried to restart and it says file not found. When I check the sql service I noticed the path it is pointing to is not there. I tied looking at the ssql config and could find it . Untill I found it in win32 folder I tried to run and it can't pin mmc. Not sure what to do from here

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,256 questions
{count} vote

9 answers

Sort by: Most helpful
  1. John Burks 11 Reputation points
    2022-07-08T00:17:03.883+00:00

    I figure it out it was actually right in front of me
    click drop down for browse for more
    click on database engine
    select new name of server
    ****\SQLEXPRESS
    1a) I backed up my registry
    1b)To get sql server to install I had to delete it from the registry.
    2)I remove all downloaded files from program file folder
    3) I did a custom install and I didn't include the first three features for the share instance
    4) I check and saw that ssqlexpress was running in service.msc
    4) I then went back in and installed the data service engine (first additional shared feature you can select)
    5)re download ssms
    6)check cmd make sure ssql was still running
    7)I also look at the ssql config to make sure all the configurations were there
    8)finally I check the box (instructions above and I saw that there was a new server name)

    It was a lot of jumping thru hoops that I shouldn't have to do. There something wrong with the basic install.

    1 person found this answer helpful.
    0 comments No comments

  2. John Burks 11 Reputation points
    2022-07-06T17:59:27.5+00:00

    I look in the summary text and I see a warning and a failure. The warning is for the anti-virus which I turned off. The other is for database services. Not sure how to fix.

    Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220705_065640\ConfigurationFile.ini

    Detailed results:
    Feature: Database Engine Services
    Status: Failed
    Reason for failure: An error occurred during the setup process of the feature.
    Next Step: Use the following information to resolve the error, and then try the setup process again.
    Component name: SQL Server Database Engine Services Instance Features
    Component error code: 1639
    Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220705_065640\sql_engine_core_inst_Cpu64_1_Local.log
    Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
    Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639

    Feature: SQL Browser
    Status: Passed

    Feature: SQL Writer
    Status: Passed

    Feature: SQL Client Connectivity SDK
    Status: Passed

    Feature: SQL Client Connectivity
    Status: Passed

    Rules with failures or warnings:

    Global rules:
    Warning IsFirewallEnabled The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at https://go.microsoft.com/fwlink/?linkid=2094702 for information about ports to open for each feature.

    Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220705_065640\SystemConfigurationCheck_Report.htm

    0 comments No comments

  3. John Burks 11 Reputation points
    2022-07-06T18:49:16.22+00:00

    I also notice none of the mcssql folders are in the c:program files. The last folder is the client sdk.

    This is in the sq_engine_core_cou64_1,.log

    Product: C:\SQL2019\Express_ENU\x64\setup\sql_engine_core_inst.msi
    ******* Action:
    ******* CommandLine: **********
    MSI (s) (D4:F4) [15:06:43:627]: Machine policy value 'TransformsSecure' is 0
    MSI (s) (D4:F4) [15:06:43:627]: User policy value 'TransformsAtSource' is 0
    MSI (s) (D4:F4) [15:06:43:672]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (D4:F4) [15:06:43:672]: Specified instance {A60B3D8E-5311-4BF1-AF7A-D1AC15F9152E} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
    MSI (s) (D4:F4) [15:06:43:672]: MainEngineThread is returning 1639
    MSI (s) (D4:C8) [15:06:43:673]: User policy value 'DisableRollback' is 0
    MSI (s) (D4:C8) [15:06:43:674]: Machine policy value 'DisableRollback' is 0
    MSI (s) (D4:C8) [15:06:43:674]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (D4:C8) [15:06:43:674]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (D4:C8) [15:06:43:675]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (D4:C8) [15:06:43:675]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
    MSI (c) (78:64) [15:06:43:676]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
    MSI (c) (78:64) [15:06:43:677]: MainEngineThread is returning 1639
    === Verbose logging stopped: 7/6/2022 15:06:43 ===


  4. Seeya Xi-MSFT 16,411 Reputation points
    2022-07-07T05:46:49.123+00:00

    Hi @John Burks ,

    Welcome to Microsoft Q&A!
    This error is a problem with the Windows installer. We may fix this by uninstalling and reinstalling the Windows installation.
    a) Press the Start and Run buttons.
    b) Type msiexec /unreg into the Run box, then press ENTER.
    c) Press the Start and Run buttons.
    d) Type msiexec /regserver into the Run box and press ENTER.

    For more information, please refer to this article: https://bobcares.com/blog/sql-server-error-1639/

    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

  5. John Burks 11 Reputation points
    2022-07-07T22:28:17.537+00:00

    218723-screenshot-2022-07-07-181839.png218599-screenshot-2022-07-07-180256.png

    I 218709-screenshot-2022-07-07-175443.png

    I got it to install with the exception of the error in 3. I tried that and below didn't work. It's there and running but when I tried to open it on SSMS it can't find the server. I restarted in service.msc and I changed the log on to local. Just can't get it to connect.
    Thanks
    John

    a) Press the Start and Run buttons.
    b) Type msiexec /unreg into the Run box, then press ENTER.
    c) Press the Start and Run buttons.
    d) Type msiexec /regserver into the Run box and press ENTER.

    0 comments No comments