This message will occur when Yearli is unable to find the server or the database is not attached to the SQL Server. This could also occur if the SQL server is not running.
Verify the Yearli Server Name
- Go to a Yearli workstation.
- Right click on the workstation icon on the desktop and select Properties.
- Under the Shortcut tab check the Target listing. It should display the following: "C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli Workstation\20XX\GNWFPlus.exe" "server\WFP_SS8E or YD2015_SS8E"*
- The server name must be precisely the same as the computer name on the server (It does not support UNC paths, i.e. \\servername). If the server has a static IP, it may be used in place of the server name.
- Verify the server name. If it is incorrect, type the correct server name or IP Address.
- Attempt to open the workstation again.
- If the workstation opens correctly, reinstall all workstations using the correct server name or IP Address.
*The Target listing will differ depending on the version of the program. Please see the Important Program Directories and File Locations article for more information.
Disable Windows Firewall on the Server
- Go to the Server computer.
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "firewall.cpl" without the quotes in the Open field.
- Click OK.
- Choose Turn Windows Firewall on or off.
- Under Private network settings, choose Turn off Windows Firewall.
- Under Public network settings, choose Turn off Windows Firewall.
Create Windows Firewall Exceptions
See the How to Create a Windows Firewall Exception for Yearli article for steps to do this.
Verify the SQL Server Instance is Running
-
Go to the Server computer.
-
Access the Microsoft SQL Server Configuration Manager.
-
For steps to do this see the How to Access SQL Server Configuration Manager article.
-
-
Click on SQL Server Services to display a list of the currently running services.
-
Make sure it says Running for the corresponding Yearli Server service*.
-
Right click and select Start if it is not running.
*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.
Verify Proper SQL Protocols are Enabled
- Go to the Server computer.
- Access the Microsoft SQL Server Configuration Manager.
- Click on SQL Server Network Configuration to display a list of the protocols for each SQL Server.
- Double click on Protocols for WFP_SS8E or YD2015_SS8E*.
- Verify that Shared Memory is enabled. If it is not, right click on Shared Memory and click Enable.
- Verify that Named Pipes is enabled. If it is not, right click on Named Pipes and choose Enable.
- Verify that TCP/IP is enabled. If it is not, right click on TCP/IP and choose Enable.
- Verify that VIA is disabled. If it is not, right click on VIA and choose Disable.
- Click on SQL Server Services.
- Right click on SQL Server and choose Restart.
*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.
Run Database Attach Executables
- Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli Server\20XX\Utilities\* for the affected version of Yearli Server.
- Run the database attach executable located in the Utilities folder (AttachDB_Yearli_20XX)*.
- There will be no need to browse for the database unless it is installed to a non-default path or if it’s being run on a machine acting as a Yearli server.
- Open the Yearli workstation on the server, or on another machine if a workstation has not been installed on the server machine.
*The file directory 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
This will need to be done for each affected year of the program.
- 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, choose Properties.
- Click Advanced.
- Ensure "Compress contents to save to disk space" and "Encrypt contents to secure data" are not checked.
- 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 will differ depending on the version of the program. Please see the Important Program Directories and File Locations article for more information.