Tools
Rss Categories

The login failed (Yearli 2018 and newer)

Views: 51 Created: 2019-08-14 09:04 Last Updated: 2019-08-14 09:04

SYMPTOM

When opening up Yearli the program may hang for a few seconds and a window will open displaying the following error:

“Following is the error message when trying to connect to the database after running the utility to attach it:
Cannot open database "Yearli20XX"* requested by the login. The login failed.
Login failed for user 'Yearli20XX'.”*

or

"Unable to locate the application's database.

SPECIFIC ERROR WAS:
Cannot open database "Yearli20XX"* requested by the login. The login failed.
Login failed for user 'Yearli20XX'."*

*The user name will differ depending on tax year.

CAUSE

This message will occur when Yearli is unable to login to the database attached to the SQL Server.  This usually results from an incomplete installation, corrupt data, or changing the SA password during the SQL install.  

RESOLUTION

Note:  If the SA password was changed during the SQL installation please contact Technical Support as these procedures will not work.

Procedure 1 (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.
  2. Choose Create / Update database.
  3. Open Yearli to see if the error persists.

Procedure 2 (Verify SQL instance is installed and running)

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

Procedure 3 (Install a new Yearli database)

Note: Only follow this procedure if this is a new installation of Yearli.

  1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  2. Type "appwiz.cpl" without the quotes in the Open field.
  3. Click OK.
  4. Double click on the appropriate version of Yearli in the list of programs.
  5. Choose Uninstall and click Next.
  6. Click Finish.
  7. Navigate to C:\ProgramData\Yearli.
  8. Right click on the folder for the affected year of Yearli.
  9. Choose Rename.
  10. Rename the folder to "20XX.old" without the quotes, where XX is the year of the software.
  11. Reinstall Yearli.

*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