How Can You Correct the Error "The Computer Cannot Establish a Connection to Orthotrac Database" When Starting Orthotrac on All Workstations?

Document created by prcarter Employee on May 15, 2017Last modified by prcarter Employee on May 15, 2017
Version 1Show Document
  • View in full screen mode

What should you do if you receive the following error message when attempting to start Orthotrac?

The error message may also display as:

 

 

 

Issue is Happening on ALL Workstations and the Server As Well

 

A.  Checking PWSVR Status

1.   Look for the gold PWSvr key in the system tray (of the server.) If it is not visible, skip to step 3. If it is present, proceed to the next step.

2.  Right-click the gold key and select Exit PracticeWorks Server.

3.  Open My Computer (Computer on Windows Server 2003 / 2008).

4.  Browse to the folder where OrthoTrac is installed. This is usually C:\OMS  but may vary depending on the installation.

5.  Double-click the PWSvr folder.

6.  Double-click the PWSvr.exe  file to restart the PWSvr process.

7.  Try to launch OrthoTrac on the server. If it launches, the problem is resolved. Try the workstations as well.

 

B.  Check the status of the SQL service.

1.  Right-click My Computer.

2.  Left-click Manage.

3.  Click the + to expand Services and Applications in the left menu.

4.  Click Services in the left menu.

5.  Click the Standard tab on the right side.  This tab shows at the bottom of the right side.

6.  Locate SQL Server (ORSQLEXP).

If the SQL Server (ORSQLEXP) does not show as Started, right-click on it and left-click Start.

If the SQL Server (ORSQLEXP) already shows as Started, right-click on it and left-click Restart.

If the SQL Server (ORSQLEXP) does not show a Startup Type of Automatic, right-click on it and left-click Properties.  Use the Startup Type pull-down list to set it to Automatic then click Apply and OK.

 

C.  Verifying Settings for SQL Server

Use the SQL Server Configuration Manager to set the start mode for SQL Server to Automatic and verify that the network / protocols configuration is correct.

 

1.   Click Start, Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager on the server.

2.   Right-click the SQL Server (ORSQLEXP) in the right pane then left-click Properties.

NOTE:  If the SQL Server (ORSQLEXP) is not showing in the right pane of the window click on SQL Server 2005 Services in the left pane of the window.

3.   Select the Service tab.

4.   Use the pull-down list to the right of Start Mode to select Automatic.

5.   Click Apply.

6.   Click OK.

NOTE:  If the SQL Server (ORSQLEXP) shows as Stopped, right-click it then select Start.

7.   Repeat steps 02 through 06 for the SQL Server Browser lines.

8.  Click on the plus next to SQL Server 2005 Network Configuration in the left pane of the SQL Server Configuration Manager window to expand the choices.

9.  Click on Protocols for ORSQLEXP. The Protocols (Pipes) will be displayed in the right window. The Shared Memory, Named Pipes, and TCP/IP protocols must be set to Enabled.

10.  Right-click on any of the disabled protocols and left-click Enable. A warning will be presented stating the following.

Warning!

Any changes made will be saved; however, they will not take effect until the service is stopped and restarted.

11.   Click OK to acknowledge the warning.

12.   Repeat steps 10 and 11 for other protocols that should be enabled.

13.   Close the SQL Server Configuration Manager.

14.   Right-click My Computer.

15.  Left-click Manage.

16.  Click on the + to expand Services and Applications in the left menu.

17.  Click on Services in the left menu.

18.  Click on the Standard tab on the right side. This tab shows at the bottom of the right side.

19.  Locate SQL Server (ORSQLEXP).

20.  Right-click on SQL Server (ORSQLEXP) and select Restart.

21.  Locate the SQL Server Browser in the right pane of the Computer Managementwindow. It will be a few lines below SQL Server (ORSQLEXP). The SQL Server (ORSQLEXP) should be set to Started in the Description column.

22.  If the SQL Server (ORSQLEXP) is stopped, right-click on it and left-click on Restart.

23.  Close Computer Management.

 

D.  Setting Up and Restarting the SQLBrowser.exe

Occasionally, after a windows update, the SQL server browser (SQLBrowser.exe) will be disabled.  This can prevent access to the SQL database.

 

1.  Open the Task Manager on the data server. (Right-click on an empty spot on the task bar then left-click on Task Manager.)

2.  Select the Processes tab.

3.   Locate the SQLBrowser.exe .   If it is listed among the other processes then try the other possible causes of the problem.   If it is not listed, continue to the next step.

NOTE: Clicking on the Image Name column header will put all of the processes in alphabetical order, making it easier to find the SQLBrowser.exe .

4.   Close the Windows Task Manager.

5.   Right-click on My Computer and left-click on Manage.

6.  Double-click Services and Applications.

7.  Double-click Services.

8.  Right-click on SQL Server Browser and left-click Properties.

9.  Set Startup Type to Automatic.

10.  Click the Start button under Service status to restart the service.

11.  Click OK to close the SQL Server Browser Properties.

12.  Close Computer Management.

13.  Open the SQL Server Configuration Manager by clicking Start, Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.

14.  Select SQL Server 2005 Services.

15.  Right-click SQL Server Browser and select Restart.

16.  Right-click SQL Server (ORSQLEXP) and select Restart.

17.  Close the SQL Server Configuration Manager.

 

E.  Checking Windows Firewall

SQL needs ports 1433 and 1434 open in order to work.  If the Windows firewall is installed when OrthoTrac is installed these ports will be opened by the installation.  Otherwise, the local technician will have to open these ports.

 

Disable the Windows Firewall on the server and see if Orthotrac will start successfully.  If it will, the local technician must correct the firewall settings.

 

F.  Checking the Office Network

1.  Verify that the server has Internet access. If the server is not able to bring up any Internet sites there may be a network issue. Restart the server itself.

2.  After the server has been restarted, check to see if the Internet connectivity is working. If so, restart the other workstations to reestablish their connection to the server, and then try Orthotrac again.

3.  If there still is no network connectivity after the server has been restarted, the local technician should be informed.

 

 

 

If none of these suggestions corrects the problem, please contact Orthotrac Support at 866-722-2567 for assistance.

 

This document was generated from the following discussion: The specified item was not found.

Attachments

    Outcomes