Tools
Rss Categories

The program will now attempt to run a utility - network

Views: 1048 Created: 2016-07-21 14:06 Last Updated: 2016-08-11 12:32

SYMPTOM

When opening up Yearli the program may hang for a few seconds and a window will open displaying the following error:
“The program will now attempt to run a utility for you to re-start SQL Server.
The utility is:
C:\\Windows\SysWOW64\mmc.exe /32
c:\\Windows\SysWOW64\SQLServerManager10.msc
Double-click on the line that says 'SQL Server Services',
then Right-click on 'Sql Server (YD2015_SS8E)' or on 'Sql Server (WFP_SS8E)' and
choose 'Start' if that is an option.
Close the program when finished.”

CAUSE

The SQL server is paused or stopped, or the workstation is unable to connect to the server machine.

RESOLUTION

Procedure 1 (Verify the SQL instance is installed and running on the server)

  1. 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.
  2. Click on “SQL Server Services” to display a list of the currently running services.
  3. Verify that SQL Server (YD2015_SS8E)* is running.
  4. Right click and select Start if the service is stopped or paused.
  5. On the left, double click on SQL Server Network Configuration (32bit).
  6. Select Protocols for YD2015_SS8E*.
  7. Right click on TCP/IP and select Enable.
  8. Right click on Named Pipes and select Enable.
  9. On the left, double click on SQL Native Client 10.0 Configuration (32bit).
  10. Select Client Protocols.
  11. Right click on Named Pipes and select Enable.
  12. Click on SQL Server Services in the left pane.
  13. Right click on SQL Server (YD2015_SS8E)* and select Restart.
  14. Right click on SQL Server Browser and select Restart.
  15. 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: WFP_SS8E or YD2015_SS8E
  • Yearli 2016: WFP_SS8E or YD2015_SS8E

Procedure 2 (Disable anti-virus, anti-spyware, and reinstall Yearli)

  1. Disable all anti-virus or anti-spyware programs.
  2. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  3. Type "appwiz.cpl" without the quotes in the Open field.
  4. Click OK.
  5. Uninstall Yearli Server for the specified tax year.
  6. Reinstall Yearli Server. Take note of any errors that may occur during the installation.
  7. Repeat steps 1 through 6 on each workstation, uninstalling and reinstalling each Yearli Workstation for the specified tax year.

Procedure 3 (Verify Administrator rights and reinstall)

  1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  2. Type "compmgmt.msc" without the quotes in the Open field.
  3. Click OK.
  4. In the Computer Management screen, expand Local Users and Groups.
  5. Click on Groups.
  6. In the list on the right, double click on Administrators.
  7. Verify that the active user account is listed in the Members section.
  8. Close the Computer Management window.
  9. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  10. Type "appwiz.cpl" without the quotes in the Open field.
  11. Click OK.
  12. Uninstall Yearli Workstation for the specified tax year.
  13. Reinstall Yearli Workstation. Take note of any errors that may occur during the installation.

Procedure 4 (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 5 (Create Windows Firewall Exceptions)

  1. See the Create Windows Firewall Exception article for steps to do this.

Procedure 6 (Uninstall the SQL instance and re-install Yearli)

  1. On the server machine, 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. Choose Microsoft SQL Server 2008 R2 from the list of programs.
  5. Choose Uninstall/Change.
  6. Choose the Remove option.
  7. Click OK.
  8. From the Instance to remove features from drop down menu, choose YD2015_SS8E*.
  9. Click Next.
  10. Check the box next to Database Engine Services.
  11. Click Next.
  12. Click Next.
  13. Click Remove.
  14. 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: WFP_SS8E or YD2015_SS8E
  • Yearli 2016: WFP_SS8E or YD2015_SS8E

APPLIES TO

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