ION Enterprise 6 installation Procedures



Distributed ION Enterprise 6 installation

- Database Server + Application Server

Windows 2008 R2 / SQL 2008 R2 Standard, or

Windows 2008 64bit / SQL 2008 R2 Standard

Introduction

This document describes the installation procedure of a new ION Enterprise 6 SP1 system with the following parameters:

• Server topology - Distributed system with a database server housing the ION database and an application server housing the ION Enterprise application and Reporting Services.

• Operation Systems (assumed to be already installed):

- Windows 2008 Server R2 or

- Windows 2008 Server 64bit

• SQL Server Version - SQL Server 2008 R2 Standard

Before you start

• Have SQL 2008 Server R2 installation CD

• Have ION Enterprise 6.0.1 CD (build 1300 has Service Pack 1 included)

• Download the SQL Server 2005 Feature Packs from Microsoft



- SQLServer2005_BC_x64.msi (SQLServer2005_BC_x64.msi)

- sqlncli_x64.msi (sqlncli_x64.msi)

- SQLServer2005_XMO_64.msi (SQLServer2005_XMO_x64.msi)

• Have a copy of the RS2008WRConfigurationWizard (RESL 203767)

Table of Contents

Introduction 1

Before you start 1

Table of Contents 2

1. Database Server Configuration 3

1.1. Install SQL 2008 R2 Standard 3

1.2. Install SQL Server 2005 Feature Packs from Microsoft 4

1.3. Install ION Enterprise 6 4

1.4. Run ION Enterprise 6.0 service pack 1 5

1.5. Create the IONUser 5

2. Application Server Configuration 6

2.1. Install Internet Information Services (IIS) 6

2.2. Allow 32-bit Applications to run on 64-bit Windows 6

2.3. Install SQL 2008 R2 Standard 7

2.4. Install SQL Server 2005 Feature Packs from Microsoft 8

2.5. Enable xp cmd_shell 8

2.6. Enable Execute Permissions for IIS 8

2.7. Configure Reporting Services 9

2.8. Install ION Enterprise 6.0 11

2.9. Run ION Enterprise 6 Service Pack 1 12

2.10. Change the Start-up type of the ION Connection Management 12

2.11. Run RS2008WRConfigurationWizard.exe 12

2.12. Delete temporary Report Server database (optional) 15

Database Server Configuration

1 Install SQL 2008 R2 Standard

Insert the SQL Server 2008R2 CD…

[pic] click OK to install .NET

-On the SQL Server Installation Center, select “Installation” on the left pane and select “New Installation or add features to an existing installation” on the right pane

-Setup Support Rules: everything should pass > click OK

-Product Key: enter product key > Next

-License Terms: accept the license terms > Next

-Setup Support Files > Install

-Setup Support Rules: everything should pass > click Next

-Setup Role: choose SQL Server Feature Installation > Next

-Feature Selection: install - Database Engine services

- Management Tools – Complete

> Next

**IMPORTANT! Do not install Reporting Services!

-Installation Rules: everything should pass > click Next

-Instance Configuration: create a Named Instance called ION > Next

-Disk Space Requirements > Next

-Server Configuration: click ‘use the same account for all SQL services’, select the local system account

(NT AUTHORITY\SYSTEM) no password is necessary >click OK, Next

-Database Engine Configuration:

1. Choose Mixed Mode

2. Enter password for the “sa” user (ION!Everywhere)

3. Click ‘Add current user’ to SQL server administrators, see below…

[pic]

Next

-Error Reporting > Next

-Installation Configuration Rules: everything should pass > Next

Install…

2 Install SQL Server 2005 Feature Packs from Microsoft

Install the three packages in the order below…

• SQLServer2005_BC_x64.msi (SQLServer2005_BC_x64.msi)

• sqlncli_x64.msi (sqlncli_x64.msi)

• SQLServer2005_XMO_64.msi (SQLServer2005_XMO_x64.msi)

3 Install ION Enterprise 6

-Click Run Setup > Install Server

[pic] click OK

-Database Server > Next

-Accept the terms > Next

-Enter Customer Information > Next

-Select SQL Server Instance: select the local ION instance > Next

[pic] click Yes

-Select File Destinations: configure if necessary > Next

[pic] Next > Install

Finish

4 Run ION Enterprise 6.0 service pack 1

- Double click ServicePack1.exe from the install media (D:\ServicePack\ServicePack1.exe)

Next > Finish

5 Create the IONUser

- Navigate to Computer Management > Local Users and Groups

- Create the IONUser with password=IONisgreat!

- Set the password to never expire

- Add the IONUser to the administrators group

Application Server Configuration

1 Install Internet Information Services (IIS)

- Start > Administrative Tools > Server Manager

- Under Roles Summary click Add Roles and check Web Server (IIS)

- Expand each sub-folder and ensure the following IIS options are checked:

• Web Server

• Common HTTP Features:

➢ Static Content

➢ Default Document

➢ Directory Browsing

➢ HTTP Errors

• Application Development Features:

➢

➢ .NET Extensibility

➢ ASP

➢ ISAPI Extensions

➢ ISAPI Filters

• Health and Diagnostics:

➢ HTTP Logging

➢ Request Monitor

• Security:

➢ Request Filtering

• Performance Features:

➢ Static Content Compression

• Management Tools:

➢ IIS Management Console

• IIS 6 Management Compatibility:

➢ IIS 6 Metabase Compatibility

➢ IIS 6 WMI Compatibility

➢ IIS 6 Scripting Tools

2 Allow 32-bit Applications to run on 64-bit Windows

Run the command:

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

- Ensure IIS is working: In Internet Explorer type:

[pic]

If IIS did not install successfully and you do not see this screen, then stop and resolve before continuing with the install!

3 Install SQL 2008 R2 Standard

Insert the SQL Server 2008R2 CD…

[pic] click OK to install .NET

-On the SQL Server Installation Center, select “Installation” on the left pane and select “New Installation or add features to an existing installation” on the right pane

-Setup Support Rules: everything should pass > Click OK

-Product Key: enter product key > Next

-License Terms: accept the license terms > Next

-Setup Support Files > Install

-Setup Support Rules: everything should pass > Click Next

-Setup Role: choose SQL Server Feature Installation > Next

-Feature Selection: install - Reporting Services

- Management Tools – Complete

> Next

-Installation Rules: everything should pass > Next

-Instance Configuration: create a Named Instance called ION

-Disk Space Requirements > Next

-Server Configuration: click ‘use the same account for all SQL services’

Run all services under the local SYSTEM account. (May be listed as NT AUTHORITY\SYSTEM.) No need to specify password.

Reporting Services Configuration: install but do not configure the report server > Next

-Error Reporting > Next

-Installation Configuration Rules: everything should pass > Next

-Ready to install: Install

4 Install SQL Server 2005 Feature Packs from Microsoft

Install the three packages in the order below choosing all the default options…

• SQLServer2005_BC.msi (SQLServer2005_BC.msi)

• sqlncli_x64.msi (sqlncli_x64.msi)

• SQLServer2005_XMO_64.msi (SQLServer2005_XMO_x64.msi)

5 Enable xp cmd_shell

- Open SQL Server Management Studio. Connect to the SQL Server 2008 instance on the database server (\ION) .

- In the Object Explorer window, right-click on the server. In the pop-up menu, click Facets.

- In the Facets dialog box, in the “Facet:” drop-down list, choose Surface Area Configuration.

- The last item in the list in XPCommandShellEnabled. Change it to True and click OK.

6 Enable Execute Permissions for IIS

- Start > Run > inetmgr

- In the left pane select Default Web Site

- In the middle pane double click and open Handler Mappings…

- In the right pane, select Edit Feature Permissions… as shown below:

[pic]

Ensure the IIS Default Web Site has Read, Script and Execute permissions.

************************************

7 Configure Reporting Services

Click Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manager

[pic]

- Connect to the local Report Server instance (ION)

- On the left pane, click Database

- On the right pane, click Change Database

[pic]

Action: Choose Create a new report server database

[pic]

Database Server: Server Name = \ION

Password = ION!Everywhere

Click Test Connection

[pic] OK > Next

[pic]

Database: Database name = temp > Next (we will later delete this database!)

Credentials: choose SQL Server Credentials, username=sa, password=ION!Everywhere > Next

Summary: Next

Progress and Finish: everything should Succeed > Finish

8 Install ION Enterprise 6.0

Insert the ION Enterprise CD…

Click Run Setup > Install Server > Primary Server > SQL Instance

[pic] click to Install required components

click Next to continue

- Accept the licensing terms > Next

- Enter Customer Info and Product Key > Next

- Select the \ION server instance > Next (choose the dataserver instance of ION)

- Select File Destinations: > Next

- ION Web Configuration: use default settings > Next

- Install > Finish

9 Run ION Enterprise 6 Service Pack 1

- Double click ServicePack1.exe (usually D:\ServicePack\ServicePack1.exe)

- Next > Finish

10 Change the Start-up type of the ION Connection Management

- Use the Services Control Panel applet to change the Startup type of the ION Connection Management service from Automatic to Manual.

11 Run RS2008WRConfigurationWizard.exe

The RS2008WRConfigurationWizard.exe must be run from the system\bin folder, so copy it there and double click to run…

[pic] Report Server should be the local machine name > Next

Click Force

[pic] Choose the second option to install RS on a different Machine > Next

[pic] Choose the database server ION instance > Next

[pic] enter username “sa”, pw=ION!Everywhere

Next

[pic] Click OK to test authentication > Next > Next

[pic] Yes

[pic] Yes

[pic] OK > Next

Next > Finish

- Now manually copy PMLMSDEManager.dll (system\bin) to the same location on the database server (over writing the existing copy).

12 Delete temporary Report Server database (optional)

- Open Microsoft SQL Server Management Studio

- In the left pane, expand Databases

- Right click on the ‘temp’ database and select “Delete”

[pic]

[pic]

- Check the Close existing conections checkbox > click OK

- Right click on the ‘tempTempDB’ database and select “Delete”

- Check the Close existing conections checkbox > click OK

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download