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.