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

    • SQL Server Database and Password FAQS

      This page has some of the most frequently asked questions with how your SQL server interacts with CurrentWare. What is the default SA password for the CurrentWare SQL database? The CurrentWare installer is prepackaged with SQL Express. If you don’t ...

    • 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 ...

    • 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 ...

    • 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: ...

    • How do I move the CurrentWare Server to another computer?

      #1 Back up your existing cwServer Database Before you migrate your server, back up your existing CurrentWare database. From the CurrentWare Web Console go to Tools > Database Backup Scheduler Click the Run Backup Now button at the bottom By Default ...