ExecuteReader Requires an Open and Available Connection

This error usually indicates database corruption. Databases can become corrupt from power outages, improper shutdowns, or failing hard drives.

Force-Close the Program and Reboot

1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
2. Type "taskmgr" without the quotes in the Open field.
3. Click OK.
4. Choose the Yearli program in the list of running applications.
   • It may be listed as GNWFPlus.exe.
5. Click End Task.
6. Reboot the machine.
7. Open the Yearli program.

Enable SQL Protocols and Restart SQL Instance

If this is a network version of Yearli, these steps will need to be taken on the server machine.

1. Access the Microsoft SQL Server Configuration Manager.
   • For steps to do this see the How to Access SQL Server Configuration Manager article.
2. On the left, double click on SQL Server Network Configuration.
3. Choose Protocols for GREATLANDYD*.
4. If Shared Memory is Disabled, right click on Shared Memory and choose Enable.
5. If Named Pipes is Disabled, right click on Named Pipes and choose Enable.
6. If TCP/IP is Disabled, right click on TCP/IP and choose Enable.
7. Choose SQL Server Services.
8. Right click on SQL Server (GREATLANDYD)*.
9. Choose Restart.
10. Open the Yearli program to see if the issue 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.