Using Named Instances

Microsoft SQL Server 2005 Express Edition (SQL Server Express) is typically installed as a named instance. If you do not specify a named instance during installation, the default named instance SQLExpress is used.

SQL Server 2005 Default and Named Instances

Client applications connect to an instance of Microsoft SQL Server 2005 to work with a SQL Server database. Each SQL Server instance is made up of a distinct set of services that can have unique settings. The directory structure, registry structure, and service name all reflect the specific instance name you identify during setup.

An instance is either the default, unnamed instance, or it is a named instance. When SQL Server 2005 is in installed in the default instance, it does not require a client to specify the name of the instance to make a connection. The client only has to know the server name.

A named instance is identified by the network name of the computer plus the instance name that you specify during installation. The client must specify both the server name and the instance name when connecting.

By default, SQL Server installs in the default instance unless you specify an instance name. SQL Server Express, however, always installs in a named instance unless you force a default installation during setup.

Note

If you do not specify an instance name when installing SQL Server Express, it is installed in a named instance, not in the default instance. This behavior differs from SQL Server, which installs by default in an unnamed instance.

SQL Server Express Default and Named Instances

In SQL Server Express, a named instance is always used by default. You specify an instance name when you install SQL Server Express, or the default named instance of SQLExpress is used. If the default named instance is used, you reference the instance as computername\SQLExpress.

You can install SQL Server Express as the default SQL Server instance if another version of SQL Server is not installed on the server as the default instance. To do so, install SQL Server Express in a named instance using an instance name of MSSQLSERVER. This forces Setup to install SQL Server Express as the default unnamed instance.

To determine if a SQL Server instance is running SQL Server Express, see How to: Identify a SQL Server Express Instance.

See Also

Concepts

Using SQL Server Browser

Other Resources

Connecting to SQL Server Express

Help and Information

Getting SQL Server 2005 Assistance