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.
svg%3E
  1. Right click on TCP/IP and select Properties.
  2. Ensure the Default Port is 1433
svg%3E
  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
svg%3E
  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.

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

Don't have CurentWare Installed? Download & Get started with a free trial!