Advanced Installation – Multiple Subnets
  • 05 Dec 2023
  • 1 Minute to read

Advanced Installation – Multiple Subnets


Article Summary

Attention:

These steps are intended for Network Administrators only.

If your configuration requires you to have your SQL Instance and Procare Licensing Service running on different Subnets/DNS Zones, you will get a message stating: “SQL Browser…error 26” if it is unable to connect to the SQL Browser over NETBIOS.

Image

If this happens, you will need to:

  • Assign Static IP to your Licensing Server/SQL Instance.
  • Assign Static Port to SQL Instance.
  • Edit SQLConfiguration on your Licensing Server.
  • Edit your static IP for licensing service

Detailed Steps

  1. Assign a static port to your SQL Instance.
    a. Launch the SQL Server Configuration Manager
    Under SQL Server Network Configuration’, Select Protocols for PROCARE (Assumes SQL Express with the default instance name of ‘PROCARE’)
    Image

    b. Double click the TCP/IP protocol to bring up the TCP/IP properties.
    c. On the Protocol Tab you can set ‘Listen All’ to ‘Yes’ if you want it to work on All Interfaces, this works with the ‘IPALL’ settings on the ‘IP Addresses’ tab. Alternatively if this method cannot be used, then enable and configure the specific IPv4 interface(s) that will be used, for the static port (which will not be used by any other service).
    Image
    d. Once the settings are input, click Apply and exit the screen.

  2. Edit your SQLConfig settings to use your static IP and port settings. To do so:
    a. Run ‘C:\Program Files\Procare\Server\SQLconfig.exe’
    b. On the SQL tab, the default entry is ‘lpc:(local)\PROCARE’
    Image
    c. The database server name/address field will need to be changed to reflect a TCP connection to your server’s IP address, SQL instance, and Static Port number. The example here is ‘tcp:10.1.1.1\PROCARE,1433’ , where your server’s IP is 10.1.1.1, Instance name is PROCARE, and the Static Port is 1433.
    Image
    d. Click Verify, and you should see a ‘Settings Verified Successfully……’ message.

  3. If any Procare client machine cannot find the Licensing server, you may need to change your client configuration, pointing it to the static IP of the licensing server.


Was this article helpful?