Export (0) Print
Expand All

Protocols Supported by SQL Server Express

If you are developing an application that connects to an instance of Microsoft SQL Server 2008 Express (SQL Server Express) over a network, there are several considerations you must take into account:

  • For security reasons, networking protocols are disabled by default in SQL Server Express. Individual protocols can be enabled manually or during installation of SQL Server Express.

  • SQL Server Express is typically installed as a named instance. The default name of the instance is SQLExpress.

  • SQL Server Browser is used by some networking protocols to associate named instances with TCP/IP port numbers. However, if SQL Server Express is installed on the same computer as a pre-SP3 version of MSDE or SQL Server 2000, there might be conflicts. Also, the SQL Server Browser service does not start automatically after installation. For more information, see SQL Server Browser Service.

The following table describes the network protocols that are supported by 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

NoteNote

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 2008 before you can use VIA.

Important noteImportant

The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft