The SQL server is paused or stopped, or the workstation is unable to connect to the server machine.
Verify the SQL instance is installed and running on the server
- On the server, access the Microsoft SQL Server Configuration Manager. For steps to do this see the How do I access the SQL Server Configuration Manager? article.
- Click on “SQL Server Services” to display a list of the currently running services.
- Verify that SQL Server (GREATLANDYD)* is running.
- Right click and select Start if the service is stopped or paused.
- On the left, double click on SQL Server Network Configuration.
- Select Protocols for GREATLANDYD*.
- Right click on TCP/IP and select Enable.
- Right click on Named Pipes and select Enable.
- On the left, double click on SQL Native Client 10.0 Configuration.
- Select Client Protocols.
- Right click on Named Pipes and select Enable.
- Click on SQL Server Services in the left pane.
- Right click on SQL Server (GREATLANDYD)* and select Restart.
- Right click on SQL Server Browser and select Restart.
- Proceed to Procedure 2 if the error persists, or the SQL instance does not exist.
*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-2017: WFP_SS8E or YD2015_SS8E
- Yearli 2018-2021: GREATLAND
- Yearli 2022-Current: GREATLANDYD
Disable anti-virus, anti-spyware, and reinstall Yearli
- Disable all anti-virus or anti-spyware programs.
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "appwiz.cpl" without the quotes in the Open field.
- Click OK.
- Uninstall Yearli Server for the specified tax year.
- Reinstall Yearli Server. Take note of any errors that may occur during the installation.
- Repeat steps 1 through 6 on each workstation, uninstalling and reinstalling each Yearli Workstation for the specified tax year.
Verify Administrator rights and reinstall
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "compmgmt.msc" without the quotes in the Open field.
- Click OK.
- In the Computer Management screen, expand Local Users and Groups.
- Click on Groups.
- In the list on the right, double click on Administrators.
- Verify that the active user account is listed in the Members section.
- Close the Computer Management window.
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "appwiz.cpl" without the quotes in the Open field.
- Click OK.
- Uninstall Yearli Workstation for the specified tax year.
- Reinstall Yearli Workstation. Take note of any errors that may occur during the installation.
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.
- See the Create Windows Firewall Exception article for steps to do this.
Changing the target line of the workstation
- On the server machine open a command prompt and type in"ipconfig" without the quotes.
- Take note of the IPv4 Address.
- Go back to the affected workstation and right click on the Yearli Workstation icon.
- Select Properties.
- 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 from the Create Windows Firewall Exceptions article.
- Click OK to apply the changes and close the Properties window.
Uninstall the SQL instance and re-install Yearli
- On the server machine, access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "appwiz.cpl" without the quotes in the Open field.
- Click OK.
- Choose Microsoft SQL Express 2019 from the list of programs.
- Choose Uninstall/Change.
- Choose the Remove option.
- Click OK.
- From the Instance to remove features from drop down menu, choose GREATLANDYD*.
- Click Next.
- Check the box next to Database Engine Services.
- Click Next.
- Click Next.
- Click Remove.
- Install the Yearli Server program again. If any errors appear during the installation, take note of the errors that occur.
*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-2017: WFP_SS8E or YD2015_SS8E
- Yearli 2018-2021: GREATLAND
- Yearli 2022-Current: GREATLANDYD