







SQL Server Setup Help | |
Instance Name (SQL Server Express) | |
![]() ![]() |
Setup User Interface Reference > Setup User Interface Reference (SQL Server Express) > |
Use the Instance Name page of the Microsoft SQL Server Installation Wizard to specify whether to create a default instance or a named instance of SQL Server Express. SQL Server Express always installs a named instance (SQLExpress) unless you select a default instance. This behavior differs from SQL Server 2005, which installs a default instance unless a named instance is selected.
Options
Option | Description | ||
---|---|---|---|
Default instance |
If you select Default instance and a default instance already exists on the machine, SQL Server Setup will upgrade the default instance. Choose this option to install a default instance of SQL Server Express. A computer can host only one default instance.
To upgrade the default instance of a previous SQL Server installation, click Default Instance and then click Next. |
||
Named instance |
When you run SQL Server Express, by default, the named instance option is selected with SQLExpress as the instance name. Choose this option to create a new named instance. Consider the following when you name an instance of SQL Server:
|
||
Installed Instances |
Use the Installed Instances page of the SQL Server Installation Wizard to view a list of installed SQL Server Express instances and components on the computer where SQL Server Setup is running. The Installed Instance Details pane displays upgrade options for installed instances. To select a component or instance to upgrade, click the instance name and then click OK. |