Tools
Rss Categories

"Unable to locate the application's database" - network

Views: 3025 Created: 2016-07-21 13:52 Last Updated: 2016-10-28 16:33

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 Workstation\20XX\GNWFPlus.exe" "server\YD2015_SS8E or WFP_SS8E"*

 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.

*The Target listing will differ depending on the version of the program. The correct Target listings are as follows:

  • WinFiler 2012 and 2013 - "C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Workstation\2012 or 2013\GNWF.exe" "server\WF_SS8E"
  • WinFiler Plus 2013  - "C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus Workstation\2013\GNWFPlus.exe" "server\WFP_SS8E"
  • Yearli 2014  - "C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus Workstation\2014\GNWFPlus.exe" "server\WFP_SS8E"
  • Yearli 2015 and 2016  - "C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli Workstation\20XX\GNWFPlus.exe" "server\YD2015_SS8E or WFP_SS8E"

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. Make sure it says Running for the corresponding Yearli Server service*.
  5. Right click and select Start if it is not running.
  6. Proceed to Procedure 5 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 - Current: WFP_SS8E or YD2015_SS8E

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 YD2015_SS8E*.
  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 (YD2015_SS8E)* and choose Restart.

*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 - Current: WFP_SS8E or YD2015_SS8E

Procedure 6 (Run database attach executables)

  1. Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli Server\20XX\Utilities\* for the affected version of Yearli Server.
  2. Run the database attach executable located in the Utilities folder (AttachDB_Yearli_20XX)*.

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

  1. 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 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

Procedure 7 (Check for Compressed Files/Folders)

  1. Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\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.

Note:  This must be done for each affected year of the program.

  1. 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

APPLIES TO

  • WinFiler 2012 - 2013
  • WinFiler Plus 2013
  • Yearli 2014 - Current