Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy)
Version 3
Installation Guide
for
IP-guard v3 Installation Guide for SQL Server 2008 R2 Express P. 2
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy)
Table of contents Page
Section 1 Prerequisites for Installation ……… 3 Section 2 Setup SQL Server 2008 R2 Express Edition ………..………. 4 Section 3 Upgrade to SQL Server 2008 R2 ……… 20
Section 1 Prerequisites for Installation P. 3
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy)
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 Requirement
OS
Windows Server 2003 Windows 7
Windows Server 2008 Windows Server 2008 R2
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.
Section 2 Install SQL Server 2008 R2 Express P. 4
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy)
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:
Section 2 Install SQL Server 2008 R2 Express P. 5
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.2 License Terms
Step 3: Setup Support Files: The setup will install the support files automatically. See the following figure:
Section 2 Install SQL Server 2008 R2 Express P. 6
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.3 Setup Support Files
Section 2 Install SQL Server 2008 R2 Express P. 7
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.4 Feature Selection
Step 5: Installation Rules: If the rule listed the status is failed, the Next button should be disable. If so, please according to the recommendation to fix the failed item and then click the Re-run button to check again.
Section 2 Install SQL Server 2008 R2 Express P. 8
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.5 Result of Installation Rules
Step 6: Instance Configuration: For SQL 2008 R2 Express version, the default named instance is SQLExpress. Here you need select Named Instance and then change it to MSSQLSERVER in the named instance (see Figure2.6).
Note that for Enterprise or other version of SQL SERVER other than Express version, Default Instance can be selected directly during installation.
Section 2 Install SQL Server 2008 R2 Express P. 9
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.6 Instance Configuration
Step 7: Server Configuration - SQL Server Service User Account Rights
If no other requirements, recommend the user account of SQL Server Database Engine as NT Authority\System. Click Next to continue.
Section 2 Install SQL Server 2008 R2 Express P. 10
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.7 Change the service account to NT AUTHORITY\SYSTEM
Step 8: Database Engine Configuration
8.1 In the Authentication mode, select Windows authentication mode.
8.2 Specify SQL Server administrators – 1) click the Add Current User button to add the current logon account and 2) click Add… button to add System account
Section 2 Install SQL Server 2008 R2 Express P. 11
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.8 Add current user
Section 2 Install SQL Server 2008 R2 Express P. 12
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.9 Adding System account
Section 2 Install SQL Server 2008 R2 Express P. 13
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.11 Confirm the selection of System account
Section 2 Install SQL Server 2008 R2 Express P. 14
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.12 Final confirmation of account settings
Step 9: Reporting Services Configuration. If there is no special requirement, just select the default setting Native mode default configuration and click Next to continue.
Section 2 Install SQL Server 2008 R2 Express P. 15
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.13 Reporting Services Configuration
Section 2 Install SQL Server 2008 R2 Express P. 16
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.14 Error Reporting
Step 11: Installation Configuration Rules: if there is no error, system message Operation completed. Passed showed, and it will start the installation progress automatically.
Section 2 Install SQL Server 2008 R2 Express P. 17
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.15 Installation Configuration Rules
Section 2 Install SQL Server 2008 R2 Express P. 18
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.16 Installation progress
Step 12: After installation completed, all installed components are listed and showed the status. To complete the SQL Server installation process, click Close.
Section 2 Install SQL Server 2008 R2 Express P. 19
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy) Figure 2.17 Complete
Section 3 Upgrade to SQL Server 2008 P. 20
Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy)
Section 3 Upgrade to SQL Server 2008 R2
Although there are many upgrade solutions for SQL Server 2008 R2, the new SQL Server management tools are required to install manually. Because of this inconvenient operation, we recommend you to uninstall the old version of SQL Server before you install SQL Server 2008 R2.
HOW TO: Uninstall the older version of SQL Server: 1) Firstly, uninstall SQL Server engine;
2) Secondly, uninstall SQL Server components.
HOW TO: install SQL Server2008 R2