Adjusting the Firewall

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.4.
This help file does not exist in MainBoss 4.2.4, but the index for that version can be found here.

< Previous section | Table of Contents | Index | Next section >

In order for other computers to access SQL Server on the Server machine, you must configure the Server machine's firewall to allow such access. (If SQL Server is already in use at your site, the Server machine is probably configured appropriately all ready.)

The following considerations apply:

If you're running an anti-virus program, it has probably installed its own firewall. Check the program's documentation for how to grant access to SQL Server.
If you're using the Windows XP or Windows Server 2003 firewall, check the MainBoss web site for a program that will create a rule to allow access through the firewall. You can determine the pathname as follows:

Start the SQL Server Configuration Manager on the computer where SQL Server is running.
In the left-hand panel, click the entry for SQL Server Services.
In the right-hand panel, right-click the entry for SQL Server (MAINBOSS) or whatever entry there is for SQL Server itself.
In the resulting menu, click Properties.
In the properties window, go to the Service section.
Double-click on the Binary Path entry. Windows will display the name of the SQL Server executable file; grant access through the firewall to this file, as described in the next section.
Repeat steps 3-6 for SQL Server Browser in the right-hand panel.