Installation and Upgrade Guide

6.1.2
- 6.2
- 6.1

Back Next

Switching to Windows Authentication Mode

You need to change the RulePoint installation settings to switch from the Microsoft SQL database server authentication mode to the Windows authentication mode.

Copy the

DDJDBCx64Auth05.dll

file from the

<installer files directory>\bin\common\dll

directory to any location, such as

E:\\Installs

The absolute path to this location, such as

E:\\Installs

, must be available whenever RulePoint is running.

Create a directory named

endorsed

in the following locations:

<RulePoint installation directory>/design

<RulePoint installation directory>/system/java/lib

Copy

dwsqlserver.jar

from

<RulePoint installation directory>/design/webapps/rulepoint/web-inf/lib

and save the file in the following locations:

<RulePoint installation directory>/design/endorsed

<RulePoint installation directory>/system/java/lib/endorsed

Delete

dwsqlserver.jar

from the following locations:

<RulePoint installation directory>/design/webapps/rulepoint/web-inf/lib

<RulePoint installation directory>/design/webapps/RTAM/web-inf/lib

<RulePoint installation directory>/lib

Update the database URL for Windows authentication mode in the following files:

cs.properties

and

rpagent.properties

located at

<RulePoint installation directory>\conf

cs.properties

jdbc.dashboard.properties

, and

jdbc.properties

located at

<RulePoint installation directory>\design\webapps\RTAM\WEB-INF\classes

cs.properties

and

rtam-config.properties

located at

<RulePoint installation directory>\design\webapps\RTAM\WEB-INF\classes

Use the following format to update the database URL for Windows authentication mode:

jdbc:informatica:sqlserver://<HOST>:<PORT>;DatabaseName=<DATABASE_NAME>;AuthenticationMethod=ntlm;LoadLibraryPath=<DLL_PATH>;

Where,

<DLL_PATH>

is the absolute path where the

DDJDBCx64Auth05.dll

file was copied.

For example,

jdbc:informatica:sqlserver://invr28cep64:1433;databaseName=rp_dbase;AuthenticationMethod=ntlm;LoadLibraryPath=E:\\Installs

Update the RulePoint topology to include the appropriate database URL:

Navigate to

Administration

Topology

Select

Topology

from the tree in the left pane, and then select

Edit Topology

The

Edit Topology

window appears.

In the

Properties

section, update the database URL in the

jdbcString

property.

To update the database URL in the

jdbcString

property, you need to use the database URL that you defined in the

.properties

files in step 5.

Click

Save

to save the updated database URL.

If you have configured Windows Services for the RulePoint components, perform the following steps to change the access permissions for the services:

Click

Start

, type

services.msc

in the

box, and then press

Enter

In the

Services

window, right-click

RulePoint Design Time

and select

Properties

In the

Properties

window, click the

Log On

tab.

Select

This account

, specify the Windows authentication user, and set the password.

Click

Repeat step b through step e to change the access permissions for the

RulePoint HostAgent

service.

Switch from SQL Database Server Authentication Mode to Windows Authentication Mode Overview

Rename Saved Search

Table of Contents

Installation and Upgrade Guide

Installation and Upgrade Guide

Switching to Windows Authentication Mode

Switching to Windows Authentication Mode