These instructions will help you properly configure SQL Server to allow connection of client computers to a server computer in a network with Norton Security enabled. These instructions do not extend to any other antivirus firewalls that may also be installed on your workstations. For help with these, refer to vendor specific support literature or a local computer technician.
Configuring SQL Server
To connect client computers in a network environment, the SQL Server instance you’ll be using needs to be properly configured to allow client computer connections.
On the Server computer navigate to SQL Server Configuration Manager. Click Windows Start > All Programs > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager. If you cannot find it under that path, open File Explorer and navigate to C:\Windows\SysWOW64 and then select SQLServerManager.
In the left pane, double-click on SQL Server Network Configuration and highlight Protocols for CMJ.
In the right pane, right click on TCP/IP and select Enable if it’s not already. You should get a warning window to restart SQL Server. Click OK. Right click on TCP/IP again and select Properties.
In the TCP/IP Properties window, click the IP Addresses tab. Scroll to the bottom and in the IP All section, delete whatever contents are in the TCP Dynamic Ports row and type 1433 in the TCP Port row. Click Apply once completed.
You should get a warning to restart SQL Server. Click OK.
Click OK to close the TCP/IP Properties window then click SQL Server Services in the left pane.
Right click on SQL Server (CMJ) and select Restart.
Close the SQL Server Configuration Manager. SQL Server is now configured properly to allow client connections to the server computer.
Configuring Norton Security Firewall
To connect a client to a server in a network environment, Norton Security will likely need added rules and/or exceptions. If you cannot connect your client to the server with Norton Security enabled, then follow these steps on all computers in your network to configure it properly to allow connections.
Right click on the Norton Security icon, which is typically located in the system tray in the bottom right of the screen, and select Open Norton Security.
Click Settings in the top right corner.
Select Firewall.
Click on the Traffic Rules tab.
Scroll down the list of items until you locate Default Block Inbound and Outbound ICMP. Uncheck the box to disable the rule.
Scroll down the list of items until you locate Default Block All Inbound Windows Services (Public Networks). Uncheck the box to disable the rule.
Press the Add button.
On the new window that comes up, select Allow. Press Next.
Select the option for Connects to and from other Computers. Press Next.
Select the option for Any Computer. Press Next.
From the drop down list, select TCP and UDP. You will then want to select The rule will apply only if it matches all of the ports listed below.
Press Add.
On the Specify ports window, select Known port from list for the Filter by option and select Remote for the Locality option. Scroll down the list and locate ports 1433 and 1434. Check both boxes and press OK.
The window you have open should match the picture below. If everything matches, press Next.
Verify that the option for "Create a Security History log entry" is unchecked and the option for If Explicitly requested is enabled. Press Next.
When asked what to call the rule, enter SQL Server (TCP and UDP). Press Next.
Verify that the settings on screen match the picture below. If not, go back and follow the previous steps for creating this new rule. Once everything matches, press Finish.
Press Apply to save all of these changes. You can then close all of the windows for Norton Security.
These are all the exceptions Norton Security requires to be enabled and allow client connections to the server. If you still cannot connect with Norton Security disabled, and you are certain your network is functioning properly, then it is likely you will need to create exceptions in other anti-virus or hardware firewalls installed on your workstations. The same ports (1433 & 1434) detailed herin are the ones that will need to be opened on those firewalls.