Access.2007.VBA.Bibl..

Getting through the Firewall....................................................................................

After working your way through the SQL Server settings, SQL Server should be started and run-

ning. At this point, if you open an Access database and start the Upsizing Wizard in an attempt to

upsize the database, you will see the SQL Server instance in the Upsizing Wizard’s second screen —

but that doesn’t mean you can connect to it. Most likely access will be blocked by the Windows

firewall. To prevent this problem, you will need to first set up the Windows firewall to allow con-

nections to SQL Server and the SQL Server Browser. The following sections explain how to get

through the Windows XP and Windows Vista firewalls, respectively.

Windows XP ..................................................................................................

Follow these steps to allow access to SQL Server through the Windows XP firewall:

If you are using another firewall, the steps needed to allow access to SQL Server will be

somewhat different.

1. Open the Security Center from the Control Panel, and click the Windows Firewall item
   (see Figure 18.13).

FIGURE 18.13

The Windows XP Security Center.

2. Click the Exceptions tab.


3. Click the Add Programs button.


4. SQL Server will probably not appear on the list of programs available for selection on the
   Add a Program screen, so click the Browse button, as shown in Figure 18.14.

NOTENOTE

Part III Adding More Functionality to Office