Next, you have to configure SQL Server to allow remote connections (for some reason, this is nec-
essary even if you have installed SQL Server on the same computer as Access):- 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.- Click the Surface Area Configuration for Services and Connections item (see Figure
18.10). - Expand the Database Engine item (if necessary) and click Remote Connections.
- Select Local and Remote connections, and select the appropriate protocol, usually “Using
TCP/IP only” (Figure 18.11).
Part III Adding More Functionality to Office