Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • RulePoint 6.2
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Informatica RulePoint Installation
  3. Before You Install RulePoint
  4. RulePoint Installation
  5. After You Install RulePoint
  6. Start RulePoint
  7. Upgrade RulePoint
  8. Switch from SQL Database Server Authentication Mode to Windows Authentication Mode Overview

Installation and Upgrade Guide Installation and Upgrade Guide

Installation and Upgrade Guide Installation and Upgrade Guide

Back Next

Configuring Windows Authentication Mode for the Microsoft SQL Server

Configuring Windows Authentication Mode for the Microsoft SQL Server

You can use the Windows authentication mode to connect to an instance of the Microsoft SQL Server through the Windows user account.
Before you configure the settings, you must have specified the custom JDBC connection string for the Windows authentication mode when you installed RulePoint.
  1. Create a directory named
    endorsed
     in the following locations:
    • <RulePoint installation directory>/design
      Where,
      <RulePoint installation directory>
       refers to the installation folder that the RulePoint installer creates during the installation phase to install the RulePoint components.
    • <RulePoint installation directory>/system/java/lib
  2. Copy the
    dwsqlserver.jar
     file 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
  3. Delete the
    dwsqlserver.jar
     file 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
  4. Verify the location of the
    dwsqlserver.jar
     and the
    DDJDBCx64Auth05.dll
     files.
    The
    dwsqlserver.jar
     file should be available only under the following locations:
    • <RulePoint installation directory>/design/endorsed
    • <RulePoint installation directory>/system/java/lib/endorsed
  5. Copy the
    DDJDBCx64Auth05.dll
     file from the
    <installer files directory>\bin\common\dll
     directory to
    <DLL_PATH>
    .
    Where,
    <DLL_PATH>
     is the absolute path of the directory to which you had copied the
    DDJDBCx64Auth05.dll
     file when you specified the custom JDBC connection string during RulePoint installation.
    For example, in the following JDBC connection string,
    E:\\Installs
     refers to the absolute path of the directory where you had copied the
    DDJDBCx64Auth05.dll
     file: 
    jdbc:informatica:sqlserver://LOCALHOST:1433;databaseName=rulepoint61;AuthenticationMethod=ntlm;LoadLibraryPath=E:\\Installs
  6. If you configured Windows Services for the RulePoint components during RulePoint installation, perform the following steps to change the access permissions for the services:
    1. Click
      Start
      , type
      services.msc
       in the
      Search
       box, and then press
      Enter
      .
    2. In the
      Services
       window, right-click
      RulePoint Design Time
       and select
      Properties
      .
    3. In the
      Properties
       window, click the
      Log On
       tab.
    4. Select
      This account
      , specify the Windows authentication user, and set the password.
    5. Click
      OK
      .
    6. Repeat step b through step e to change the access permissions for the
      RulePoint HostAgent
       service.
0 COMMENTS
We’d like to hear from you!