Server Firewall Configuration
After you install the Admin module on the server, it is possible that access to it from other computers on the network may be blocked by a firewall. Most commercial firewalls will ask if you want to make an exception for SQL Server when it is installed. Respond affirmatively when it asks. However, the Windows firewall does not. You must explicitly bring it up and configure the exception.
Click on the Exceptions tab and then click on the Add Program button.
Click on the Browse button and locate the “C:\Program Files\Microsoft SQL Server\90\Shared\sqlBrowser.exe”. Click on it and then click the OK button.
Repeat the same process for “C:\Program Files\The Monticello Corporation\MSSQL.X\MSSQL\binn\SQLServer.exe”. The “X” in the MSSQL.X folder name will normally be 1, but can be any number form 1 to 7 depending on how many instances of SQL Server are installed on the computer.
Now the exception should be working and The Paper Tiger should be able to find the server even when the firewall is turned off.
0 Comments