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.
SELECT
SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘ProductLevel’) AS ProductLevel,
SERVERPROPERTY(‘Edition’) AS Edition
GO
Conclusion
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.
]]>