com.esri.arcgis.datastore.common.DataStoreException: Attempt to configure datastore failed.. Extended error message: Database upgrade failed.. Extended error message: Failed to start relational data store

Error Message

In the ArcGIS Data Store Configuration wizard, attempting to configure a relational data store returns the following error on the Prerequisite Check page:

Error:   
com.esri.arcgis.datastore.common.DataStoreException: Attempt to configure datastore failed.. Extended error message: Database upgrade failed.. Extended error message: Failed to start relational data store

Cause

The following are possible causes:

• The relational data store machine is unreachable.
• ArcGIS Data Store is upgraded before Portal for ArcGIS and ArcGIS Server. Refer to Portal for ArcGIS: Upgrade ArcGIS Data Store – Upgrade order for more information.

Solution or Workaround

To resolve this issue:

Warning:
The following solution wipes data from the data store. It is recommended that the data is backed up before proceeding with these steps.

1. Run the Windows Command Prompt as an administrator.
2. Navigate to the ArcGIS Data Store utilities folder located at:

C:\Program Files\ArcGIS\DataStore\tools

3. Run the unregisterdatastore command utility to unregister the relational data store using the following command:

 unregisterdatastore.bat –stores relational –prompt yes

4. Uninstall ArcGIS Data Store.
5. Navigate to the following directory on the machine:

C:\Program Files\ArcGIS

6. Rename or delete the contents in the DataStore folder.
7. Navigate to the following directory on the machine:

C:\

8. Rename or delete the contents in the arcgisdatastore folder.
9. Reinstall ArcGIS Data Store.
10. Navigate to the Data Store Configuration Wizard for the primary ArcGIS Server machine, and re-register the primary Data Store. The following is an example of the Data Store Configuration Wizard directory:

https://datastoremachine.domain.com:2443/arcgis/datastore