Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table describes the network protocols that are supported by Microsoft SQL Server 2005 Express Edition (SQL Server Express).
| Network Protocol | Description | If the value of DISABLENETWORKPROTOCOL=1 | If the value of DISABLENETWORKPROTOCOL=0 |
|---|---|---|---|
Shared Memory |
Lets you connect to an instance of SQL Server that is running on the same computer. Cannot be used for access from other computers on the network. |
Enabled |
Enabled |
TCP/IP |
Permits network access to SQL Server Express by specifying the computer name and instance name or the IP address and instance name. |
Disabled |
Enabled |
Named Pipes |
Permits network access to SQL Server Express by supporting numerous network protocols, including NetBEUI, TCP/IP, and IPX/SPX. Automatically selects the network protocol based on the client configuration. |
Enabled, local only |
Enabled |
Virtual Interface Architecture (VIA) |
Used for System Area Networks, which are high-speed networks connecting servers or clusters of servers. |
Not Supported |
Not Supported |
Note
Although VIA is not supported, you can design a database that will work in a VIA environment. However, you must migrate your SQL Server Express database to SQL Server 2005 before you can use VIA.
SQL Server Browser
If the value of DISABLENETWORKPROTOCOL = 1, SQL Browser is turned off. For more information on SQL Browser, see Using SQL Server Browser and How to: Enable Network Access During Installation (SQL Server Express).
See Also
Concepts
Enabling Network Access to SQL Server Express
Other Resources
Connecting to SQL Server Express