Overview of SQL Server 2008 R2 Express Edition
11. In the Error Reporting Screen select the checkbox to send Windows and SQL Server error reports to Microsoft to improve future releases of SQL Server. Click Next to continue with the installation.
12. In the Installation Configuration Rules screen you can quickly review the features selected for installation. Click Next to begin the installation of SQL Server 2008 R2 Express Edition.
13. In the Complete screen the location of the SQL Server 2008 R2 Express Edition Installation Summary log is provided. Finally click Close button to complete the SQL Server 2008 R2 Express Edition installation.
14. Execute the below TSQL query to verify the SQL Server 2008 R2 Express Edition installation.
SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘ProductLevel’) AS ProductLevel,
SERVERPROPERTY(‘Edition’) AS Edition
In this article you have gone through the steps which you need to follow in order to install a SQL Server 2008 R2 Express Edition.