Link:How to Install SQL Server 2008 R2 (Express Edition)

Overview:

With the release of the SQL Server 2008 R2 November, we have simplified the SQL Server Express (all editions and package) installation process.  In this release, we have completed the following:

  1. Reduced the number of clicks by 50% when performing an install.
  2. All inputs are defaulted on Vista and above operating systems.  (many inputs are defaults on Windows XP and Windows 2003, except for the service accounts)
  3. Skip (auto advance) through the UI, meaning non-essential dialogs will still be skipped.
  4. Reduced the size of the Express basic package

 

Available Express editions for download:

Express Package

If your system is?

If your system is?

If your system is?

Microsoft® SQL Server® 2008 R2 Express

X86

X64

WOW64

Microsoft® SQL Server® 2008 R2 Express with Tools

X86

X64

.

Microsoft® SQL Server® 2008 R2 Express with Advanced Services

X86

X64

.


Microsoft® SQL Server® 2008 R2 Management Studio Express

X86

X64

.

 

Below I show the steps to install SQL Server 2008 R2 Express.


1. Launch the package, you will then see the contents extracted to a temporary location.

How to Install SQL Server 2008 R2 (Express Edition)_sql

 

2. SQL Server Setup checks to determine pre-reqs are installed. If not, you will be prompted to install.

 How to Install SQL Server 2008 R2 (Express Edition)_sed_02

3. The Installation Center will then launch. Click on “New installation or add feature to an existing installation” to start the Installation Wizard.

How to Install SQL Server 2008 R2 (Express Edition)_JAVA_03

 

4. Accept the license terms.

How to Install SQL Server 2008 R2 (Express Edition)_microsoft_04

 

5. Review the features to installed and where SQL Server will be installed. Make any changes that are necessary for your environment.

How to Install SQL Server 2008 R2 (Express Edition)_JAVA_05

 

6. Review the Instance Name and change if necessary.

How to Install SQL Server 2008 R2 (Express Edition)_sql_06

 

7. Review the credentials that will be used for the services that will be created. 

How to Install SQL Server 2008 R2 (Express Edition)_JAVA_07

 

8. Review the Authentication Mode and the administrators that will be added to the Database Engine.

How to Install SQL Server 2008 R2 (Express Edition)_sql_08

 

9. Review the Error Reporting settings. We encourage you to keep this option checked, as we review the product feedback on an ongoing basic.  This helps us to continually improve SQL Server.

How to Install SQL Server 2008 R2 (Express Edition)_sed_09

 

10. That’s it!

How to Install SQL Server 2008 R2 (Express Edition)_sql_10

 

Support/Feedback

If you have further questions or feedback, you have a few options: