sqlsql-serversql-server-2019sql-server-2019-express

The SQL Server feature 'SQL_Engine_Core_Inst' error


For few days I am getting an issue with SQL Server 2019 Express Installation. When installing SQL Server I get an error and the server won't work. I've tried repairing it but I've got also an error here. The following error is :

  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:          0x84B40002

  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.

  Error help link:               (Link that doesn't work)

My SQL Server Management Studio 2018 also don't work. I've tried uninstalling and installing SQL Server but it doesn't help. I've even tried uninstalling and installing Windows but nothing to do.


Solution

  • I fixed the issue: If you run into that error, try creating a Virtual Hard Drive with Disk Manager. Then install SQL Server 2019 on it and it should maybe resolve the problem. If not, read all the comments and check if something helps.

    Edit: When you shut down your computer, if you restart it, the virtual disk disappears. You have to mount it again and start the database engine manually. I recommend creating a script that does this for you.