Tools
Rss Categories

"Unable to locate the application's database" - network (2018)

Views: 401 Created: 2018-07-09 09:29 Last Updated: 2018-08-02 12:14

SYMPTOM

When opening a Yearli workstation the program may hang for a few seconds and a window will open displaying the following error message:
“Unable to locate the application's database”.

CAUSE

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.

RESOLUTION

Procedure 1 (Verify the Yearli Server name by checking the 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\20XX\GNWFPlus.exe" server\GREATLAND* where XX is the year of the software.

 Note: 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.

  1. Verify the server name. If it is incorrect, type the correct server name or IP Address.
  2. Attempt to open the workstation again.
  3. If the workstation opens correctly, reinstall all workstations using the correct server name or IP Address.

Procedure 2 (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.

Procedure 3 (Create Windows Firewall Exceptions)

  1. See the How do I create a Windows Firewall exception for Yearli? article for steps to do this.

Procedure 4 (Verify the SQL server instance is running by checking the SQL Server Service Manager)

  1. Go to the Server computer.
  2. Access the Microsoft SQL Server Configuration Manager.  For steps to do this see the How do I access SQL Server Configuration Manager? article.
  3. Click on SQL Server Services to display a list of the currently running services.
  4. Verify that SQL Server (GREATLAND) is running.
  5. Right click and select Start if it is not running.
  6. Proceed to Procedure 5 if the error persists.

Procedure 5 (Verify proper SQL protocols are enabled)

  1. Go to the Server computer.
  2. Access the Microsoft SQL Server Configuration Manager.  For steps to do this see the How do I access SQL Server Configuration Manager? article.
  3. Click on SQL Server Network Configuration (32bit) to display a list of the protocols for each SQL Server.
  4. Double click on Protocols for GREATLAND.
  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 step 10. If not, go to Procedure 6.
  10. Click on SQL Server Services.
  11. Right click on SQL Server (GREATLAND) and choose Restart.

Procedure 6 (Run database attach 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.

Procedure 7 (Check for Compressed Files/Folders)

  1. Navigate to C:\ProgramData\Yearli\20XX\Data*, where XX is the year of the software.*
  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
  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.

Procedure 8 (Changing First and Second 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 (GREATLAND) and choose Properties.
  5. Click on the Recovery tab.
  6. For First and Second failure choose Restart the Service.
  7. Click OK to save the changes.
*Note:  The ProgramData folder is a hidden folder.  You must show hidden folders in order to access it.  For steps to do this see the How do I show hidden folders? article.

APPLIES TO

  • Yearli 2018 - Current