SQL Server Express 2022 Reinstall

Francois Timms 0 Reputation points
2024-04-19T06:14:14.86+00:00

Hi

I have a question regarding the install process of SQL Server 2022 Express.

I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL Server and attempted to reinstall, but was not able to do so. During installation I get the error:

The error Log shows the following:

Overall summary:

Final result: Failed: see details below

Exit code (Decimal): -2147467259

Start time: 2024-04-19 07:56:18

End time: 2024-04-19 08:07:59

Requested action: Install

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, uninstall this feature, and then run the setup process again.

Component name: SQL Server Database Engine Services Instance Features

Component error code: 0x80004005

Error description: The system cannot find the path specified

Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=0xF57C3D6F%400xDC80C325&EvtType=0xF57C3D6F%400xDC80C325

Feature: SQL Server Replication

Status: Failed

Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.

Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

Component name: SQL Server Database Engine Services Instance Features

Component error code: 0x80004005

Error description: The system cannot find the path specified

Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=0xF57C3D6F%400xDC80C325&EvtType=0xF57C3D6F%400xDC80C325

Any assistance will be great.

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,754 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-22T09:55:44.9033333+00:00

    Hi @Francois Timms,

    Thanks for your information.

    I've checked the log and I agree with Greg Low. Here are my suggestions:

    1. Uninstalling the SQL Server clearly and try to reinstall. You can follow this article. In addition, I found an issue like yours and you can also try this:

      For all future people: I understand you got error 1605. But it is not actually an error. Look in folder temp and you will find bat file. Open it with administrator and delete all that you can delete. In the end, you will have 2 files (in my case, database engine). Open registry editor with administrator, use Find (Ctrl+F), find by keys (long string of random chars), and delete everything corresponding to this keys. (Be patient, it can took a long time, appx. 30 seconds). Then delete all folders with SQL, in my case these were SQL2022 in C:\ and in C:\Program files. Reboot your computer and install SQL Server

    2. If you are windows11, here is A known issue with Windows 11 + SQL Server is a misaligning disk sector size.

    Hope this can help you well.

    Best regards,

    Lucy Chen

    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.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    0 comments
  2. Francois Timms 0 Reputation points
    2024-04-25T07:16:22.57+00:00

    Good Morning

    I followed the steps as provided by you and within the links shared and still no luck. I Also deleted all the relevant SQL Server folder and registry keys. After a reboot the installation still failed.

    I again tried to remove all traces of SQL Server from my system (folders, registry entries). Still no luck. There seems to be an instance that remains somewhere within the registry. I will try again and follow the log errors.

  3. Francois Timms 0 Reputation points
    2024-04-26T06:23:00.0733333+00:00

    Morning

    I still have the same error that appears, even after I have attempted to remove all traces of SQL Server instances from the registry. It would be great to get some clear instructions on exactly which keys I need to delete from the registry to get this working again.

    Log file attached.

    Thanks

    0 comments
  4. Francois Timms 0 Reputation points
    2024-04-26T06:28:22.9166667+00:00

    Looks like the logfile did not attach. Herewith the content of the file:

    Filename: sql_engine_core_inst_Cpu64_1.log

    Contents:

    === Verbose logging started: 2024/04/26 08:15:42 Build type: SHIP UNICODE 5.00.10011.00 Calling process: D:\Setup\SQLEXPR_x64_ENU\x64\ScenarioEngine.exe ===

    MSI (c) (E4:84) [08:15:42:723]: Resetting cached policy values

    MSI (c) (E4:84) [08:15:42:723]: Machine policy value 'Debug' is 0

    MSI (c) (E4:84) [08:15:42:723]: ******* RunEngine:

           ******* Product: D:\Setup\SQLEXPR_x64_ENU\x64\setup\sql_engine_core_inst.msi

       ******* Action: 

       ******* CommandLine: **********

    MSI (c) (E4:84) [08:15:42:724]: Client-side and UI is none or basic: Running entire install on the server.

    MSI (c) (E4:84) [08:15:42:724]: Grabbed execution mutex.

    MSI (c) (E4:84) [08:15:42:727]: Cloaking enabled.

    MSI (c) (E4:84) [08:15:42:727]: Attempting to enable all disabled privileges before calling Install on Server

    MSI (c) (E4:84) [08:15:42:727]: Incrementing counter to disable shutdown. Counter after increment: 0

    MSI (s) (AC:60) [08:15:42:734]: Running installation inside multi-package transaction D:\Setup\SQLEXPR_x64_ENU\x64\setup\sql_engine_core_inst.msi

    MSI (s) (AC:60) [08:15:42:734]: Grabbed execution mutex.

    MSI (s) (AC:28) [08:15:42:735]: Resetting cached policy values

    MSI (s) (AC:28) [08:15:42:735]: Machine policy value 'Debug' is 0

    MSI (s) (AC:28) [08:15:42:735]: ******* RunEngine:

           ******* Product: D:\Setup\SQLEXPR_x64_ENU\x64\setup\sql_engine_core_inst.msi

       ******* Action: 

       ******* CommandLine: **********

    MSI (s) (AC:28) [08:15:42:735]: Machine policy value 'TransformsSecure' is 0

    MSI (s) (AC:28) [08:15:42:735]: User policy value 'TransformsAtSource' is 0

    MSI (s) (AC:28) [08:15:42:754]: Machine policy value 'DisableUserInstalls' is 0

    MSI (s) (AC:28) [08:15:42:754]: Specified instance {0029E33B-8F28-4225-9A4D-5CE25ABE529E} via transform :InstID03.mst;:InstName03.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.

    MSI (s) (AC:28) [08:15:42:755]: MainEngineThread is returning 1639

    MSI (s) (AC:60) [08:15:42:756]: User policy value 'DisableRollback' is 0

    MSI (s) (AC:60) [08:15:42:756]: Machine policy value 'DisableRollback' is 0

    MSI (s) (AC:60) [08:15:42:756]: Incrementing counter to disable shutdown. Counter after increment: 0

    MSI (s) (AC:60) [08:15:42:756]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2

    MSI (s) (AC:60) [08:15:42:757]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2

    MSI (s) (AC:60) [08:15:42:757]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1

    MSI (c) (E4:84) [08:15:42:759]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1

    MSI (c) (E4:84) [08:15:42:759]: MainEngineThread is returning 1639

    === Verbose logging stopped: 2024/04/26 08:15:42 ===

    0 comments
  5. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-26T06:58:41.65+00:00

    Hi @Francois Timms.

    Thanks for your feedback.

    Please ensure you are following the steps to remove remnants from previous installations as instructed in this article.

    Could you please post the errorlog.txt like this? The information you give cannot show us error messages.

    Hi Some more info. I tried to reinstall both Express edition as well as the Developer edition, without success. Same error for both.ERRORLOG.txt Error log attached. And thank you for your assistance.

    In addition, after you remove the registry key, please run the sfc tool to repair your operating system. After that, try to install SQL Server as administrator again.

    It would be great to get some clear instructions on exactly which keys I need to delete from the registry to get this working again.

    If you have any concerns, please feel free to share with us.

    Note: Please post your issue or error logs by comment instead of answer. Thanks for your understanding!

    Best regards,

    Lucy Chen

    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.

    https://docs.microsoft.com/en-us/answers/support/email-notifications