Table of Contents

Search

  1. Pre-Installation
  2. Installation
  3. Post-Installation
  4. Apply the HotFix
  5. Starting and Stopping Proactive Monitoring Components
  6. Logging In to Client Tools
  7. Configure Reporting
  8. Installation and Configuration Checklist

Installation Guide

Installation Guide

Grant Permissions on Microsoft SQL Server

In the Proactive Monitoring repository database, grant execute permissions to the PowerCenter read-only user on user defined functions TO_DATE_MMDDYYYYHHMI and TO_DATE_MMDDYYYYHHMISS.
Log in to Microsoft SQL Server Management Studio as the database administrator and run the following commands:
GRANT EXECUTE ON db_datareader.TO_DATE_MMDDYYYYHHMI TO <PowerCenter read only user name> GRANT EXECUTE ON db_datareader.TO_DATE_MMDDYYYYHHMISS TO <PowerCenter read only user name>