Sql Server 2008 Installation

Version 3 Installation Guide for SQL Server 2008 R2 Express Advanced Services

Copyright © TEC Solutions Ltd. All rights reserved.

Last update: Sep 2012 (By Tommy)

IP-guard v3 Installation Guide for SQL Server 2008 R2 Express

P. 2

Table of contents

Page

Section 1 Prerequisites for Installation ………………………………………………………… Section 2 Setup SQL Server 2008 R2 Express Edition ……………………..…………………. Section 3 Upgrade to SQL Server 2008 R2 ……………………………………………………

3 4 20

Copyright © TEC Solutions Ltd. All rights reserved.

Last update: Sep 2012 (By Tommy)

Section 1 Prerequisites for Installation

P. 3

Section 1 Prerequisite for Installation
Download link of SQL Server 2008 R2 Express with Advanced Services: http://www.microsoft.com/en-us/download/details.aspx?id=25174 (If you are using 64bits OS, please select to download 64bits SQL server in the link above)

SQL Server 2008 R2 Express with Advanced Services supports the following operating systems:
Component Windows Server 2003 OS Windows 7 Windows Server 2008 Windows Server 2008 R2 Requirement

Before the installation of SQL Server 2008 R2,You have to automatically install the following components: Windows Installer 4.5 Microsoft .NET Framework 3.5 SP1 Windows Power Shell 1.0

Note:Before starting the SQL Server 2008 R2 installation, you have to reboot the system after Windows Installer 4.5 and .NET Framework 3.5 SP1 installed.

Copyright © TEC Solutions Ltd. All rights reserved.

Last update: Sep 2012 (By Tommy)

Section 2 Install SQL Server 2008 R2 Express

P. 4

Section 2 Install SQL Server 2008 R2 Express
Step 1:Double-click the program; the Installation Wizard will pop up after extraction completed. Select Installation > New installation or add features to an existing installation. See the following Figure 2.1:

Figure 2.1 Installation Step 2: License Terms: Please check the option I accept the license terms, and click Next button to continue. See the following figure:...