• No results found

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

N/A
N/A
Protected

Academic year: 2021

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

Copied!
20
0
0

Loading.... (view fulltext now)

Full text

(1)

Copyright © TEC Solutions Ltd. All rights reserved. Last update: Sep 2012 (By Tommy)

Version 3

Installation Guide

for

(2)

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

(3)

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.

(4)

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:

(5)

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:

(6)

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

(7)

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.

(8)

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.

(9)

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.

(10)

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

(11)

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

(12)

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

(13)

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

(14)

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.

(15)

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

(16)

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.

(17)

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

(18)

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.

(19)

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

(20)

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

Figure

Figure 2.1 Installation
Figure 2.10 Select System account from Select Users or Groups

References

Related documents

The following procedure explains how to install a new instance of Microsoft SQL Server 2008 R2 Express Edition with Advanced Services (64-bit).. Download the SQL Server 2008 R2

If you first look at the settings for SQL Server 2008 Services, both the SQL Server Browser and the SQL Server services for the database instance are not enabled by default

8 Installing SQL Server 2008 R2 Express Edition with Advanced Services 11 Post-Installation Setup and Configuration .... 24 Verifying the “Allow remote connections to this

An automated installation script which installs and configures the SQL Server 2005 Express SP4 for use with NaviEdit can be found at the EIVA installation DVD.. The SQL Server

An automated installation script which installs and configures the SQL Server 2005 Express SP4 for use with NaviEdit can be found at the EIVA installation DVD.. The SQL Server

2.1 Standalone Server Installation (SQL Express 2008 R2 Advanced) • Install IIS, SQL Express Advanced Edition with Reporting Services and Marshal Reporting Console.. on a

Open the Microsoft SQL Server Management Studio Express program (the link to install this program is included in the SQL Server 2005 Express Installation instructions above)b.

The Server Farm Installation option selected previously does not automatically install the Microsoft SQL Server 2008 R2 Express Edition and thus you will need to already have