ENVÍOS POSTALES O MULTIMODALES Cláusula 6a. Vigencia del seguro

This section describes how to install the RCS in database mode.

Note:

• Before starting the installation, make sure that this is the mode that you require (seeSelecting the Type of Installationon page 33)

• If you are installing the RCS in database mode, the Microsoft SQL Server Native Client must be installed on the computer. Currently, the installers do not verify that this client is installed. If the client is not installed, the RCS cannot connect to the database. The RCS folder contains a folder named

“SQLNativeClient” with the 32-bit and 64-bit installers for this client.

3.6.1 Supported SQL Server Versions

In database mode the data is stored in an SQL database. You can install the database on a computer running any of these Enterprise versions of SQL Server:

• Microsoft* SQL Server* 2008 x32/x64 (SP1)

• Microsoft SQL Server 2008 R2 x64 (SP1)

• Microsoft SQL Server 2005 x32 (SP4)

Note:

Intel SCS supports case-sensitive and case-insensitive installations.

3.6.2 Installation Permissions in SQL Server

The database is created using the Database Tool. The Database Tool can also give the RCS permissions on the Intel SCS database. To do these tasks, the Database Tool requires these Server Roles in SQL Server:

• dbcreator – Always required (to create the database)

• securityadmin – Only required if you want the Database Tool to create the User and Login ID in SQL

Server for the RCS. The Database Tool creates this User and Login ID specifically for the Intel SCS database that you define. They do not have permissions in any other database in SQL Server. You have two options for giving these Server Roles to the Database Tool:

• Windows authentication – Run the Database Tool with a Windows user account that has the required

Server Roles.

• SQL Server authentication – During installation, supply the credentials of an SQL Server user that

3.6.3 RCS User Permissions in SQL Server

The RCS requires permissions on the Intel SCS database in SQL Server.

During installation, if you let the Database Tool create the User and Login for the RCS, this is what the Database Tool creates:

• A User in the Intel SCS database with these Role Member settings:

• db_datareader

• db_datawriter

• An explicit Login ID for the User that is mapped to the Default Schema of dbo You have two options for how the RCS will connect to the Intel SCS database:

• Windows authentication – The RCS will use the credentials of the Windows user account that is

running the RCS (

RCSServer.exe

).

• SQL Server authentication – The RCS will use the credentials of an SQL Server user. This method of

authentication is considered less secure. In addition, the Login ID and password of the SQL Server user are saved in the registry of the computer running the RCS (the password is encrypted).

During installation of the RCS, you must select the authentication method in the Database Settings window of the installer. When using the Database Tool to add the user to the database, use the

RCSUserWinAuth=

parameter of the

AddUser

command to specify the authentication method.

3.6.4 Creating the Database

In many organizations, the company databases are managed by a database administrator (DBA). Usually, the DBA will want to control how the Intel SCS database is installed. The DBA (or you) can use the Database Tool, located in the RCS folder, to create the database before you install the RCS. The Database Tool

(

DatabaseTool.exe

) is a simple CLI that you can use locally on the SQL Server or remotely.

Note:

When complete, the

CreateDB

command creates a storage encryption key file. The file is encrypted with a password that is printed to the screen in the CLI output of the command. Make sure that you save this file and password in a secure location. You will need them later.

This is the syntax and parameters for the

CreateDB

command:

DatabaseTool.exe CreateDB DBServer=<DB server> DBName=<DB name>

[Username=<SQL Login ID> Password=<SQL password>] [KeyFileName=<filename>]

DBServer=

The name (FQDN) or IP address of the SQL Server

Username=

By default, the credentials of the user account running the Database Tool are used to authenticate with SQL Server. If you want the Database Tool to use SQL Server authentication instead, use this parameter to supply the Login ID.

Password=

The password of the SQL Server account (only necessary if the user was supplied in the Username parameter)

KeyFileName=

By default, the Database Tool creates an encryption key file named

RCSStorage.key

in the folder where the Database Tool is located. You can use this parameter to supply an alternative path and filename.

Examples

Example #1: Creating a database on the local SQL Server:

DatabaseTool.exe CreateDB DBServer=(local) DBName=TestDB

Example #2: Creating a database on a remote SQL Server:

DatabaseTool.exe CreateDB DBServer=192.168.1.10 DBName=TestDB

Example #3: Creating a database using SQL Server authentication:

DatabaseTool.exe CreateDB DBServer=192.168.1.10 DBName=TestDB Username=MySQLUser

Password=P@ssw0rd

3.6.5 Adding the RCS User to the Database

After creating the database, you (or the DBA) must define how the RCS will access the database and which user account it will use. To do this, use the

AddUser

command of the Database Tool.

This is the syntax and parameters for the

AddUser

command:

DatabaseTool.exe AddUser DBServer=<DB server> DBName=<DB name>

[Username=<SQL Login ID> Password=<SQL password>]

RCSUserWinAuth=<0|1> RCSUsername=<username> [RCSPassword=<password>]

DBServer=

The name (FQDN) or IP address of the SQL Server

DBName=

The name of the database

Username=

By default, the credentials of the user account running the Database Tool are used to authenticate with SQL Server. If you want the Database Tool to use SQL Server authentication instead, use this parameter to supply the Login ID.

Password=

The password of the SQL Server account (only necessary if the user was supplied in the

Username

parameter)

RCSUserWinAuth=

Defines the type of authentication used by the RCS to authenticate with the database. Valid values:

• 0 – SQL Server authentication

• 1 – Windows authentication

RCSUsername=

The name of the user account to be used by the RCS to authenticate with the database.

• If

RCSUserWinAuth=0

– This will be the Login ID used by the RCS during SQL Server authentication. If the Login ID does not exist, it will be created by the Database Tool.

• If

RCSUserWinAuth=1

– This will be the Domain user account under which the RCS will run. You must make sure that you specify the same name when you install the RCS (in the Database Settings window).

Note: If

RCSUserWinAuth=1

and you are using the Network Service account, the format of the username depends on where the RCS and database are located. For more information, seeUsing the Network Service Accounton page 35.

RCSPassword=

The password of the user account to be used by the RCS to authenticate with the database. Only necessary if

RCSUserWinAuth=0

.

Examples

Example #1: Adding a user to a database on the local SQL Server:

DatabaseTool.exe AddUser DBServer=(local) DBName=TestDB RCSUserWinAuth=1

RCSUsername=MyRCSUser

Example #2: Adding a user to a database on a remote SQL Server:

DatabaseTool.exe AddUser DBServer=192.168.1.10 DBName=TestDB RCSUserWinAuth=1

RCSUsername=MyRCSUser

Example #3: Adding the Network Service user (RCS is local on SQL Server):

DatabaseTool.exe AddUser DBServer=192.168.1.10 DBName=TestDB RCSUserWinAuth=1

RCSUsername=“NT Authority\Network Service”

Example #4: Adding the Network Service user (RCS is connecting remotely):

DatabaseTool.exe AddUser DBServer=192.168.1.10 DBName=TestDB RCSUserWinAuth=1

RCSUsername=“domain\computer$”

Example #5: Adding a user (that will use SQL Server authentication):

DatabaseTool.exe AddUser DBServer=192.168.1.10 DBName=TestDB Username=MySQLUser

Password=P@ssw0rd RCSUserWinAuth=0 RCSUsername=MyRCSUser RCSPassword=P@ssw0rd

3.6.6 Installing the RCS and Console

This procedure describes how to install the RCS and (Console) in database mode. To install in database mode:

1. Double-click

IntelSCSInstaller.exe

. The Welcome window opens.

2. Select I accept the terms of the license agreement and click Next. The Select Components window

In document SEGURO DE TRANSPORTE DE CARGA Condiciones Generales (página 74-84)