Workstation Connectivity Settings

We recommend that you install all Windows updates including Microsoft Office, before continuing.

To setup workstation connectivity:

  1. Press Windows logo key + R to open the Run window.

    Windows run window

  2. In the Open box, type CLICONFG.
  3. Click OK to open the SQL Server Client Network Utility window.

    Windows SQL server client network utility window

  4. Click the General tab.
  5. Select TCP/IP in the Disabled protocols list.
  6. Click the Enable >> button to add TCP/IP to the Enabled protocols by order list.
  7. Select Named Pipes in the Disabled protocols list.
  8. Click the Enable >> button to add Named Pipes to the Enabled protocols by order list.
  9. Use the up/down arrow buttons at the bottom of the Enabled protocols by order list to ensure that TCP/IP appears above Named Pipes.

    NOTE: If there are any other protocols listed in the Enabled protocols by order list, you need to remove them,

  10. Move all other protocols from the Enabled protocols by order list to the Disabled protocols list.

  11. Ensure that the Force protocol encryption and Enable shared memory protocol check boxes are NOT selected.
  12. Click the Properties button to open the TCP/IP window.

    Windows default port window

  13. In the Default port box, type the default port.

    NOTE: The Default port number is the same number you get form the server through either the Server Network utility or the SQL Error log.

  14. Click OK to save the setting and return to the General tab.

    Windows SQL Server network utility, alias tab

  15. Click the Alias tab.

    NOTE: If there are any alias configurations listed in the Server alias configurations list, they must be removed.

  16. Remove all alias configurations from the Server alias configurations list.

  17. Click OK to close the SQL Server Client Network Utility window.
  18. Now you need to set the protocol for the Juris.ini file (protocol) and for the workstation (local protocol), using the Juris Diagnostics tool.

Set protocol and local protocol

  1. Click the Windows Start button.
  2. Select Programs or All Programs in Windows 7 > Juris Diagnostics to open the Juris Diagnostics window.

    Juris diagnostics window

  3. Double-click the Juris License to expand it.

    Juris diagnostics window, license

  4. Double-click the [four digit Client Code]000 to expand it.

  5. Select Set Protocol to open the Set Network Protocol window that controls the setting for the Juris.ini file.

    Juris diagnostics, set network protocol window

  6. Select CliConfg.
  7. Click OK.

    Your changes are saved and you are returned to the Juris Diagnostics window.

    Juris diagnostics window, select set local protocol

  8. Click Set Local Protocol to open the Set Network Protocol window that controls the setting for the PC

    Juris diagnostics window, set local protocol

  9. Select CliConfg.
  10. Click OK.
  11. Click the window Close button to close the Juris Diagnostics window.