How to: Install SQL Server Express with Advanced Services

New: 14 April 2006

This topic describes how to install Microsoft SQL Server 2005 Express Edition with Advanced Services.

To install SQL Server Express

  1. To start installation, double-click sqlexpr_adv.exe.


SQL Server Express is available as a self-extracting executable file (sqlexpr_adv.exe) from the SQL Server Express Web site. sqlexpr_adv.exe installs on x86-based computers and to the 32-bit subsystem (WOW64).

  1. On the End User License Agreement page, read the license agreement, and then select I accept the licensing terms and conditions check box. Click Next.

  2. The Installing Prerequisites page installs the software required before you install SQL Server Express. Click Next.


      The .NET Framework 2.0 is not installed when SQL Server Component Update runs, but SQL Server Express Setup requires the .NET Framework 2.0 to be installed before you run sqlexpr_adv.exe. If the .NET Framework 2.0 is not installed, you will experience an error. Make sure that you uninstall all earlier versions of the .NET Framework and install the .NET Framework 2.0. from the .NET Framework 2.0 Download Center before you start SQL Server Express Setup.

  3. The Welcome to the Microsoft SQL Server Installation Wizard page appears. Click Next.

  4. When the System Configuration Check page appears, the computer is scanned for potential installation problems. To interrupt the scan, click Stop. To continue with setup after the scan finishes, click Next.

  5. On the Registration Information page, enter information in the Name and Company text boxes. Click Next.

    1. Because SQL Server Express is free, there is no product key text box on this page.
    2. If you select the Hide advanced configuration options check box, the Instance Name, Service Account, Collation Settings, and User Instances pages do not appear during setup, and the default settings are used.
  6. On the Feature selection page, select the program features to install. Click Next.


    You can expand a feature to view its subfeatures by clicking the "+" symbol. If you want to install all the components that are available under every available feature in the Feature Tree, click the arrow next to the feature and select Entire feature will be installed on local hard drive.

  7. On the Instance Name page, select a Default instance or a Named instance for your installation. If you select Default instance, an existing default instance will be upgraded. If you select Named Instance, specify an instance name. Otherwise, the default named instance of SQLExpress is used. Click Next.

  8. The Service Account page lets you assign a login account to the SQL Server service. You can specify an individual account for each service, or you can use one account for all the services. This page does not appear if you select the Hide advanced configuration options check box. Click Next.
    For more information about how to set options on this page, see Service Account (SQL Server Express).

  9. On the Authentication Mode page, specify the security mode that is used to connect to your instance of SQL Server. If you select Windows Authentication, Setup creates an sa account that is disabled by default. To activate the sa account after the Setup program is finished, see the How to: Change Server Authentication Mode and ALTER LOGIN (Transact-SQL) topics in SQL Server 2005 Books Online. If you select Mixed Mode Authentication you must set strong passwords for all SQL Server login accounts. Enter and confirm a strong sa login password. Click Next.

  10. On the Collations Settings page, change the default Collation designator and sort order only if you must match collation settings in another instance of SQL Server or on another computer. Select SQL collations to match the sort order settings that you designated in earlier versions of SQL Server. This page does not appear if you select the Hide advanced configuration options check box. Click Next.

  11. On the User Instances page, specify if you want to generate a separate instance of the Database Engine for non-administrator users. By default, user instance functionality is enabled. To turn off user instances, clear the check box. This page does not appear if you select the Hide advanced configuration options check box. Click Next.

  12. On the Report Server Installation Options page, specify options that determine how a report server instance is installed. For more information, see Report Server Installation Options and Report Server Installation Details. Click Next.

  13. On the Error and Usage Report Settings page, select whether to turn on error reporting and usage reporting for SQL Server and its components. Click Next.

  14. On the Ready to Install page, click Install to finish installing SQL Server.

  15. On the Setup Progress page, you can monitor installation progress as setup proceeds. Click Next.

  16. On the Completing the Microsoft SQL Server Installation Wizard page, you can view the setup summary log by clicking the link provided on this page. To complete the SQL Server Installation Wizard, click Finish.

See Also

Other Resources

How to: Install SQL Server 2005 from the Command Prompt

Help and Information

Getting SQL Server 2005 Assistance