Failed SQL Installation - An error occurred during the setup process of the feature.

Issue:

When trying to install SQL Express, you receive this error:

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

Cause:

This usually happens when installing SQL Server on a Domain Controller (please note, this is not recommended best practice).

However, there are sometimes strict security policies in place and service account permissions may have been changed from the IT department.

Solution/Workaround:

When we come to Server Configuration screen, during the installation, you will need to change the Account Name (Default would be NT Service\MSSQL$SQLEXPRESS), of the Database Engine Service, to either:

NT AUTHORITY\NETWORK SERVICE or NT AUTHORITY\LOCAL SERVICE.

Just clicking the box and typing it in (Not to be confused with clicking the dropdown and manually searching/selecting it from the menu)

 

Use the Account Name, used for running the SQL Server Browser or SQL Server Replication (Depending what installation options have been chosen.)

And you should be able to continue with installation.

• Related Articles

• Installation Guide

  Please click on the attachment tab. The Forecast 5 Installation Guide is available to assist all with installing Forecast 5. Note: The installation guide refers to SQL Express 2017 but the process will be the same for newer versions of SQL Express. ...

• Consolidations: An error has occurred while creating/opening the forecast.

  Issue: When trying to complete a consolidation, you are receiving the following error: "An error has occured while creating/opening the forecast. If this is a consolidation, please check that all records are named correctly to avoid duplicate record ...

• Import Error: SQL Exception: Incorrect Syntax near "s"

  Issue: Receiving this error message when trying to import records, sections or folders. SQL Exception Incorrect Syntax near "s" Unclosed quotation mark after the character string 'WHERE' This error is caused because there is a single quote character ...

• TypeInitializationException: A network-related or instance-specific error... [Error: 26]

  Issue: You receive the following error when trying to login to Forecast 5. Forecast 5 cannot continue because of an exception occurred. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified. Cause: This error indicates that ...

• Cannot open database "...." requested by the login. The login failed.

  Issue: When trying to open Forecast 5, you are receiving the error below: SqlException Cannot open database "Forecast5V3_2018" requested by the login. The login failed. Login failed for user 'Navsoft\JohnDoe'. at ...