Troubleshooting SQL Server Connection Issues with CurrentWare Server

Troubleshooting SQL Server Connection Issues with CurrentWare Server

If the CurrentWare Server is unable to connect to the SQL server, you may need to configure the Windows Firewall and SQL Server Configuration Manager to allow SQL Server access.

Add the sqlsvr.exe into Window’s Firewall Inbound Rule list

  1. Go to Control Panel > System and Security > Windows Firewall > Advanced Settings
  2. Right click on Inbound Rule and select New Rule…
  1. For Rule Type, select Program and click Next
  2. For Program, browse to your SQL Server installed path and select sqlservr.exe
  3. For Action, select Allow the connection and click Next.
  4. For Profile, leave all 3 profiles checked.
  5. Enter the name as “CurrentWare SQL” and click Finish.

Add port 1433 (TCP) and port 1434 (UDP) into Window’s Firewall Inbound Rule list.

  1. Go to Control Panel > System and Security > Windows Firewall > Advanced Settings
  2. Right click on Inbound Rule and select New Rule…
  3. For Rule Type, select Port and click Next
  4. For Protocol and Ports, select TCP and type in 1433 for the specific local ports.
  5. For Action, select Allow the connection and click Next.
  6. For Profile, leave all 3 profiles checked.
  7. Enter the name as “CurrentWare TCP for SQL” and click Finish.
  8. Repeat steps 2 to 7: select UDP instead as the protocol and name it “CurrentWare UDP for SQL”

Summary of the Firewall Policies on your SQL Server

Rule TypeApplication/PortActionProfile
Inbound Rule > Programsqlservr.exe from SQL server
installation path		AllowDomain, private,
Public
Inbound Rule > PortTCP 1433AllowDomain, private,
Public
Inbound Rule > PortUDP 1434AllowDomain, private,
Public

SQL Server Configuration Manager Service and TCP/IP Settings

  1. Open the SQL Server Configuration Manager
  2. Ensure that the SQL Server Browser service is running and the start mode is set to
    automatic
  1. Under SQL Native Client Configuration > Client Protocols, ensure TCP/IP is enabled.
  1. Right click on TCP/IP and select Properties.
  2. Ensure the Default Port is 1433
  1. Under SQL Server Network Configuration > Protocols for MSSQLSERVER, right click on TCP/IP and select Properties
  2. Click on the IP addresses tab and ensure the TCP Dynamic Ports is set to 0

If you have further issues with your CurrentWare Solutions, contact our technical support team.

    • Related Articles

    • How do I connect CurrentWare to my SQL Server?

      From your CurrentWare Server, go to C:\Program Files (x86)\CurrentWare\cwServer\ In this folder you can run the CWSM.exe file. This will bring up the CurrentWare Server Manager. Select Database > Selection > SQL Server. Enter your SQL Server details: ...

    • Troubleshooting Logs

      Starting from version 8.0, the web console now has a Troubleshooting section that provides access to logs for troubleshooting purposes. Administrators no longer have to reach out to Currentware Support for the first level of troubleshooting as they ...

    • Client Connection Issues – My computer is not showing up on CurrentWare

      You are encountering a client connection issue when your computers are not showing up as “connected” on the CurrentWare Console. There are a few possible causes that will prevent your CurrentWare client from connecting to the CurrentWare Console. ...

    • Renamed The CurrentWare Server PC

      If you renamed your CurrentWare server PC and find yourself having issues opening your web console, it’s likely due to the backend SQL connection properties. The easiest way to fix this issue is to do a quick uninstall and reinstall of the server ...

    • How do I Setup CurrentWare with SQL Express

      Welcome to the SQL Express Database Installation and Setup page. Benefits of using a SQL Database with the cwServer are an increase in overall performance and stability of client connections. Here are the steps to download, setup and configure your ...