On multiple terminal systems, you may need to allow SQL Server to communicate through the firewall on the main computer only. The main computer is the computer where SQL Server is installed.
The following link may also be useful, if you need to know where the main install of CashFootprint is connected.
Note: this is where you'll connect the subsequent terminals to as well.
How do I know which server instance and/or database CashFootprint is connected to?
Two firewall ports will need to be opened to allow the connection:
- UDP port 1434 is needed and is used to allow network visibility to the available servers.
- A TCP port that corresponds to the server instance already setup on the main computer.
Here is how to obtain the proper TCP port number:
- Click the Windows Start button > All Programs > Microsoft SQL Server Express 200 R2 > Configuration Tools > SQL Server Configuration Manager.
- Click SQL Server Network Configuration from the left tree view.
- On the right you should see Protocols for CashFootprint or Protocols for SQL Server SQLEXPRESS.
- Double-click the protocol for your server instance.
- A new list will appear. Right-click TCP/IP and select Properties from the pop-up context menu.
- A new screen will appear: TCP/IP Properties
- On the Protocol tab, Change Enabled to Yes.
- On the IP Addresses tab, scroll to the bottom of the properties and write down the TCP Dynamic Ports value.
This is the TCP port number that you need to allow through your firewall.
- Click Cancel to close the Properties window.
- Close the SQL Server Configuration Manager window.