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.

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.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |