"Unable to locate the application's database" after Windows update

Views: 248 Created: 2019-08-14 13:25 Last Updated: 2019-08-14 13:25

SYMPTOM

When opening up Yearli the program may hang for a few seconds and a window will open displaying the following error:
“Unable to locate Yearli database”.

CAUSE

This message will occur when Yearli is unable to find the database attached to the SQL Server. This usually results after a Windows update.

RESOLUTION

Procedure 1 (Verify SQL instance is installed and running)

Access the Microsoft SQL Server Configuration Manager. For steps to do this see the How do I access SQL Server Configuration Manager? article.
Click on “SQL Server Services” to display a list of the currently running services.
Right click on SQL Server (GREATLAND) and select Start.

Procedure 2 (Changing First and Second failure to Restart the Service)

Access the Windows Run window by pressing the Windows key and R key on the keyboard.
Type "services.msc" without the quotes in the Open field.
Click OK.
Right click on SQL Server (GREATLAND) and choose Properties.
Click on the Recovery tab.
For First and Second failure choose Restart the Service.
Click OK to save the changes.

APPLIES TO

Yearli 2018 - Current