Next, you must enable network access — this is required even if you are connecting to SQL Server
on the same computer.
- Start by expanding the SQL Server 2005 Network Configuration folder in the left pane of
the SQL Server Configuration Manager, and select the Protocols for SQLEXPRESS folder
under it. - Enable the TCP/IP protocol from its right-click menu (Figure 18.8).
FIGURE 18.8
Enabling the TCP/IP protocol.- You will get a message, shown in Figure 18.9, that you have to stop and restart the serv-
ice. You can do this by right-clicking SQL Server (SQLEXPRESS) in the SQL Server 2005
Services folder and selecting Restart, or by shutting down and restarting Windows.
FIGURE 18.9
A warning after enabling a protocol.4.If your connection makes use of the Named Pipes protocol, you can enable it in a sim-
ilar fashion.Working with SQL Server Data 18