ION Enterprise 6 Installation Procedures

Schneider Electric Distributed Database ION Enterprise 6.0 SP1 + Win2008R2/Win2008x64 + SQL2008 R2

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 R2or

- 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 (RESL203767)

Introduction

Before you start

Table of Contents

1.Database Server Configuration

1.1.Install SQL 2008 R2 Standard

1.2.Install SQL Server 2005 Feature Packs from Microsoft

1.3.Install ION Enterprise 6

1.4.Run ION Enterprise 6.0 service pack 1

1.5.Create the IONUser

2.Application Server Configuration

2.1.Install Internet Information Services (IIS)

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

2.3.Install SQL 2008 R2 Standard

2.4.Install SQL Server 2005 Feature Packs from Microsoft

2.5.Enable xp cmd_shell

2.6.Enable Execute Permissions for IIS

2.7.Configure Reporting Services

2.8.Install ION Enterprise 6.0

2.9.Run ION Enterprise 6 Service Pack 1

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

2.11.Run RS2008WRConfigurationWizard.exe

2.12.Delete temporary Report Server database (optional)

1.Database Server Configuration

1.1.Install SQL 2008 R2 Standard

Insert the SQL Server 2008R2 CD…

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…

-Error Reporting > Next

-Installation Configuration Rules: everything should pass > Next

Install…

1.2.InstallSQL 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)

1.3.Install ION Enterprise 6

-ClickRun SetupInstall Server

click OK

-Database Server > Next

-Accept the terms > Next

-Enter Customer Information > Next

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

click Yes

-Select File Destinations: configure if necessary > Next

Next > Install

Finish

1.4.Run ION Enterprise 6.0 service pack 1

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

Next > Finish

1.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

2.Application Server Configuration

2.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:

Schneider Electric Distributed Database ION Enterprise 6.0 SP1 + Win2008R2/Win2008x64 + SQL2008 R2

Web Server

Schneider Electric ION Enterprise 6.0 SP1 + Windows 2008 R2 + SQL 2008 R2

Common HTTP Features:

Static Content

Default Document

Directory Browsing

HTTP Errors

Application Development Features:

ASP.NET

.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.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:

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

2.3.Install SQL 2008 R2 Standard

Insert the SQL Server 2008R2 CD…

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

2.4.InstallSQL 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)

2.5.Enable xp cmd_shell

-Open SQL Server Management Studio. Connect to the SQL Server 2008 instance on the database server (<dataserver name>\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.

2.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:

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

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

2.7.Configure Reporting Services

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

-Connect to the local Report Server instance (ION)

-On the left pane, click Database

-On the right pane, click Change Database

Action: Choose Create a new report server database

Database Server: Server Name = <dataserver name>\ION

Password = ION!Everywhere

Click Test Connection

OK > Next

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

2.8.Install ION Enterprise 6.0

Insert the ION Enterprise CD…

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

click to Install required components

click Next to continue

-Accept the licensing terms > Next

-Enter Customer Info and Product Key > Next

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

-Select File Destinations: > Next

-ION Web Configuration: use default settings > Next

-Install > Finish

2.9.Run ION Enterprise 6 Service Pack 1

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

-Next > Finish

2.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.

2.11.Run RS2008WRConfigurationWizard.exe

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

Report Server should be the local machine name > Next

Click Force

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

Choose the database server ION instance > Next

enter username “sa”, pw=ION!Everywhere

Click OK to test authentication > Next > Next

Yes

OK > Next

Next > Finish

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

2.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”

-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