Remote CurrentWare Console is unable to connect to CurrentWare Server using SQL database

Remote CurrentWare Console is unable to connect to CurrentWare Server using SQL database

If you have setup a Remote CurrentWare Console to be able to access your CurrentWare server running off a SQL database and are having connection issues. This is usually caused by either Firewall blocking or SQL Server settings.

Solutions

  1. Turn OFF Windows Firewall
  2. SQL Server Configuration Manager Network Settings

Enable the TCP protocol for the SQL Instance

  1. Go to SQL Server Configuration Manager (C:\Windows\SysWOW64\SQLServerManager)
  2. Expand “SQL Server Network Configuration” and select Protocols for your SQL instance (Protocols for CWSQL).
  3. On the right side pane, Right click on TCP/IP and select Enable.
  4. Select SQL Server Service tab from the left side menu.
  5. Right click on the SQL Server (CWSQL) and click restart to restart the SQL Server Service.

Turn OFF Windows Firewall on both the CurrentWare Server, SQL Server and Console machine


If the firewall changed fixed the issues, then please add the following exceptions on the Firewall on the SQL Server, CurrentWare Server and the console machines.

  1. Allow 1433 and 1434 (Both TCP and UDP) ports for inbound and outbound rules.
  2. Allow sqlservr.exe for all TCP ports on both the inbound and outbound rules. By default, SQL Server is at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe.

SQL Server Configuration Manager Network Settings

  1. Open the SQL Server Configuration Manager. By Default, it should be at C:\Windows\SysWOW64\SQLServerManager
  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

  1. Select SQL Server Service tab from the left side menu.
  2. Right click on the SQL Server (CWSQL) and click restart to restart the SQL Server Service.

    • Related Articles

    • Security & SQL Database Best Practices

      Security and Workflows Connection to the Web Console Starting with v8.0.1, the CurrentWare web console will have a preconfigured self-signed SSL certificate that is enabled by default. This will ensure that network communication to and from the ...
    • Move the CurrentWare server to another computer with network SQL database

      When moving your CurrentWare software to a new server/PC you need to make sure you do not have both consoles connecting to the same networked database. Here are the steps to take. #1 Back up your existing cwServer Database Before you migrate your ...
    • 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 ...
    • 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 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: ...