Connecting to SQL Server Express
This section provides information about using Microsoft SQL Server 2005 Express Edition (SQL Server Express) on a network. If you are developing an application that connects to an instance of 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 Using SQL Server Browser.
In This Section
This section includes the following topics:
Describes how to reference an instance of SQL Server Express that is in a named instance.
Describes networking protocols supported by SQL Server Express.
Describes how SQL Server Browser works.