This message will occur when Yearli is unable to find the database attached to the SQL Server. This usually results from an incomplete installation.
Check for anti-virus or anti-spam / Run database attach executables
- 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.
- Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX\* where XX is the year of the software, for the affected version of Yearli.
- 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.
- Run the database attach executable located in the Utilities folder (AttachDB_Yearli_20XX), located at C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX\*.
- Open Yearli to see if the error persists.
*The file directory will differ depending on the version of the program. The file directories associated with each version of the program are:
- WinFiler: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler
- WinFiler Plus and Yearli 2014: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus
- Yearli: C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli
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.
- Verify that SQL Server (YD2015_SS8E)* is running.
- Right click and select Start if required.
- Proceed to Procedure 3 if the error persists.
*The SQL Server instance will differ depending on the version of the program. The SQL servers associated with each version of the program are:
- WinFiler 2012 - 2013: WF_SS8E
- WinFiler Plus 2013 - 2014: WFP_SS8E
- Yearli 2014: WFP_SS8E
- Yearli 2015: WFP_SS8E or YD2015_SS8E
- Yearli 2016: WFP_SS8E or YD2015_SS8E
Disable Anti-Virus, Anti-Spyware, and Reinstall Yearli
- Disable all anti-virus or anti-spyware programs.
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "appwiz.cpl" without the quotes in the Open field.
- Click OK.
- Uninstall Yearli for the specified tax year.
- Reinstall Yearli.
Check for Compressed Files/Folders
- Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX\Data*, where XX is the year of the software.
- Right click the .mdf and .ldf files and, for each, select Properties.
- Click Advanced.
- Ensure "Compress contents to save to disk space" and "Encrypt contents to secure data" are not checked.
Note: This must be done for each affected year of the program.
- Run the database attach executable (AttachDB_Yearli_20XX) located in C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli \20XX\Utilities\*.
*The file directory and attach executable will differ depending on the version of the program. The file directories and attach executables associated with each version of the program are:
- WinFiler: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler\20XX\Utilities\AttachDB_WF_20XX
- WinFiler Plus and Yearli 2014: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus\20XX\Utilities\AttachDB_WFP_20XX
- Yearli: C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli\20XX\Utilities\20XX\Utilities\AttachDB_Yearli_20XX
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.
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "appwiz.cpl" without the quotes in the Open field.
- Click OK.
- Uninstall Yearli for the specified tax year.
- Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli*.
- Right click on the fold for the affected year of Yearli.
- Choose Rename.
- Rename the folder to "20XX.old" without the quotes, where XX is the year of the software.
- Reinstall Yearli.
*The file directory will differ depending on the version of the program. The file directories associated with each version of the program are:
- WinFiler: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler
- WinFiler Plus and Yearli 2014: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus
- Yearli: C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli