Tools
Rss Categories

"Unable to locate the application's database" - standalone (2018)

Views: 276 Created: 2018-07-09 07:43 Last Updated: 2018-08-02 12:28

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 from an incomplete installation.  

RESOLUTION

Procedure 1 (Check for anti-virus or anti-spam / Run database attach executables)

  1. Determine if anti-virus or anti-spyware software was running during the installation. If they were running, go to Procedure 2; otherwise proceed to the next step.
  2. Navigate to C:\ProgramData\Yearli\20XX* where XX is the year of the software, for the affected version of Yearli.
  3. Check to see if a folder called Data exists in this directory. If the folder does not exist, go to Procedure 2; otherwise proceed to the next step.
  4. Run the SQLUtility in the Utilities folder located at C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX* where XX is the year of the software.
  5. Choose Create / Update database.
  6. Open Yearli to see if the error persists.

Procedure 2 (Verify SQL instance is installed and running)

  1. Access the Microsoft SQL Server Configuration Manager.  For steps to do this see the How do I access SQL Server Configuration Manager? article.
  2. Click on “SQL Server Services” to display a list of the currently running services.
  3. Verify that SQL Server (GREATLAND) is running.
  4. Right click and select Start if required.
  5. Proceed to Procedure 3 if the error persists.

Procedure 3 (Disable Anti-Virus, Anti-Spyware, and Reinstall Yearli)

  1. Disable all anti-virus or anti-spyware programs.
  2. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  3. Type "appwiz.cpl" without the quotes in the Open field.
  4. Click OK.
  5. Uninstall Yearli for the specified tax year.
  6. Reinstall Yearli.

Procedure 4 (Check for Compressed Files/Folders)

  1. Navigate to C:\ProgramData\Yearli\20XX\Data*, where XX is the year of the software.
  2. Right click the .mdf and .ldf files and, for each, select Properties.
  3. Click Advanced.
  4. Ensure "Compress contents to save to disk space" and "Encrypt contents to secure data" are not checked.
  5. Run the SQLUtility in the Utilities folder located at C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX* where XX is the year of the software..
  6. Choose Create / Update database.
  7. Open Yearli to see if the error persists.

Procedure 5 (Install a new database)

Note: Only take the following steps if there has not be any data entered for the year of Yearli that is receiving this error.

  1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  2. Type "appwiz.cpl" without the quotes in the Open field.
  3. Click OK.
  4. Uninstall Yearli for the specified tax year.
  5. Navigate to C:\ProgramData\Yearli.
  6. Right click on the fold for the affected year of Yearli.
  7. Choose Rename.
  8. Rename the folder to "20XX.old" without the quotes, where XX is the year of the software.
  9. Reinstall Yearli.

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

  1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  2. Type "services.msc" without the quotes in the Open field.
  3. Click OK.
  4. Right click on SQL Server (GREATLAND) and choose Properties.
  5. Click on the Recovery tab.
  6. For First and Second failure choose Restart the Service.
  7. Click OK to save the changes.
*Note:  The ProgramData folder is a hidden folder.  You must show hidden folders in order to access it.  For steps to do this see the How do I show hidden folders? article.

APPLIES TO

  • Yearli 2018 - Current