"Unable to Locate the Application's Database" - Standalone (2018 and Newer)

This message will occur when Yearli is unable to find the database attached to the SQL Server. This usually results from an incomplete installation.

Disable Anti-Virus, Anti-Spyware, and Reinstall Yearli

1. Disable all anti-virus and 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.

Run Database Attach Executables

1. Navigate to C:\ProgramData\Yearli\20XX, where XX is the year of the software, for the affected version of Yearli.
2. Check to see if a folder called Data exists in this directory.
   
   • If the folder exists, open it to see if Yearli20XX_Primary.ldf and Yearli20XX_Primary.mdf are present. 
3. Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX, where XX is the year of the software.
4. Double-click the Utilities folder to open it.
5. Right click the SQLUtility, and click "run as administrator". 
   • If the Data folder in step 2 contained the Yearli20XX_Primary.ldf and Yearli20XX_Primary.mdf files, click the "attach database" button.
   • If there was no data folder found in step 2, or the folder was empty, click the Create / Update database button.
6. Wait for the utility to complete, and make note of the result in the white text box on the left.
   • If the result lists "successfully created" or "successfully attached/successfully assigned", open Yearli to see if the error persists.
   • If the result is failure, unsuccessful, could not be attached/assigned, etc., make note of the specific result and contact support for further assistance.

1. Access the Microsoft SQL Server Configuration Manager.
   • For steps to do this see the How to 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 (GREATLANDYD)* is running.
4. Right click and select Start if required.
5. Open Yearli to see if the error persists.

*The SQL Server instance will differ depending on the version of the program. Please see the Important Program Directories and File Locations article for more information.

Check for Compressed Files/Folders

1. Navigate to C:\ProgramData\Yearli\20XX\Data, where XX is the year of the software.
   • The Program Data folder is a hidden folder. You must show hidden folders in order to access it.
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.