Figure

A warning after enabling a protocol.

Warning

Any changes madewill be saved; however, they wiEF not take effect ontif the service is stopped and restarted.

4. If your connection makes use of the Named Pipes protocol, you can enable it in a similar fashion.

Next, you have to configure SQL Server to allow remote connections (for some reason, this is necessary even if you have installed SQL Server on the same computer as Access):

1. Select SQL Server Surface Area Configuration (see Figure 18.10) from the Configuration Tools group in the Microsoft SQL Server 2005 program group. If you are running Vista, you may get a message that the program has known compatibility issues. If so, you need to install the SP2 service pack for SQL Server 2005.

FIGURE 18.10

The SQL Server 2005 Surface Area Configuration dialog.

FIGURE 18.10

The SQL Server 2005 Surface Area Configuration dialog.

2. Click the Surface Area Configuration for Services and Connections item (see Figure 18.10).

3. Expand the Database Engine item (if necessary) and click Remote Connections.

4. Select Local and Remote connections, and select the appropriate protocol, usually "Using TCP/IP only" (Figure 18.11).

Surface area configuration for SQL Server.

Surface area configuration for SQL Server.

5. When you close this dialog, you will be back on the SQL Server 2005 Surface Area Configuration dialog. If needed, click the other link ("Surface Area Configuration for Features") and enable any features you plan to use (Figure 18.12).

FIGURE 18.12

Enabling SQL Server features.

FIGURE 18.12

Enabling SQL Server features.

6. Restart SQL Server by selecting Restart from the right-click menu for "SQL Server (SQLEXPRESS)" in the SQL Server 2005 Services folder.

Getting through the Firewall

After working your way through the SQL Server settings, SQL Server should be started and running. 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 Wizards 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 connections 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:

0 0

Post a comment