Yearli Guide
Have questions? Our knowledge base has answers.
  1. Yearli Guide
  2. Yearli Desktop
  3. Errors

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

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 in Shortcut Properties

  1. Go to a Yearli workstation.
  2. Right click on the workstation icon on the desktop and select Properties.
  3. 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\GREATLAND* where XX is the year of the software.
    • 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.
  4. Verify the server name. If it is incorrect, type the correct server name or IP Address.
  5. Attempt to open the workstation again.
  6. If the workstation opens correctly, reinstall all workstations using the correct server name or IP Address.

Disable Windows Firewall on the Server

  1. Go to the Server computer.
  2. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  3. Type "firewall.cpl" without the quotes in the Open field.
  4. Click OK.
  5. Choose Turn Windows Firewall on or off.
  6. Under Private network settings, choose Turn off Windows Firewall.
  7. 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.

Change the Target Line of the Workstation

  1. On the server machine open a command prompt and type in "ipconfig" without the quotes.
  2. Take note of the IPv4 address.
  3. Go back to the affected workstation and right click on the Yearli Workstation icon.
  4. Select Properties.
  5. In the Target line locate the name/IP Address of the server machine. Change to the IP address noted in the previous step followed by a comma and then the dynamic port.
  6. Click OK to apply the changes and close the Properties window.

Verify the SQL Server Instance Is Running

  1. Go to the Server computer.

  2. Access the Microsoft SQL Server Configuration Manager.

  3. Click on SQL Server Services to display a list of the currently running services.

  4. Verify that SQL Server (GREATLANDYD) is running.

  5. Right click and select Start if it is not running.

Verify Proper SQL Protocols Are Enabled

  1. Go to the Server computer.
  2. Access the Microsoft SQL Server Configuration Manager.
  3. Click on SQL Server Network Configuration to display a list of the protocols for each SQL Server.
  4. Double click on Protocols for GREATLANDYD.
  5. Verify that Shared Memory is enabled.
    • If it is not, right click on Shared Memory and click Enable.
  6. Verify that Named Pipes is enabled.
    • If it is not, right click on Named Pipes and choose Enable.
  7. Verify that TCP/IP is enabled.
    • If it is not, right click on TCP/IP and choose Enable.
  8. Verify that VIA is disabled.
    • If it is not, right click on VIA and choose Disable.
  9. If any changes were made to any of these protocols, go to the next step. If no changes were made, skip to the next section.
  10. Click on SQL Server Services.
  11. Right click on SQL Server (GREATLANDYD) and choose Restart.

Run Database Update Executables

  1. 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, for the affected version of Yearli.
  2. Choose Create / Update database.
  3. Open the Yearli workstation on the server, or on another machine if a workstation has not been installed on the server machine.

Check for Compressed Files/Folders

  1. Navigate to C:\ProgramData\Yearli\20XX\Data, where XX is the year of the software.
    • The ProgramData 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, choose Properties.
  3. Click Advanced.
  4. Ensure "Compress contents to save to disk space" and "Encrypt contents to secure data" are not checked.
    • If checked, uncheck.
  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. Wait for the process to complete and display text in the white box on the left.
  8. Open Yearli to see if the error persists.

Change First, Second, and Subsequent 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 (GREATLANDYD) and choose Properties.
  5. Click on the Recovery tab.
  6. For First, Second, and Subsequent Failure choose Restart the Service.
  7. Click OK to save the changes.
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more