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

Create a Read-only User in Microsoft SQL Server

Log in to Microsoft SQL Server Management Studio using as the database administrator and run the following commands to create a user and assign permissions:
USE master CREATE LOGIN <pcrs_readonly> WITH PASSWORD=<'pcrs_readonly'>, DEFAULT_DATABASE=<repository database name>, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF USE <<repository database name>> CREATE USER <pcrs_readonly> FOR LOGIN 'pcrs_readonly' ALTER USER pcrs_readonly WITH DEFAULT_SCHEMA=db_datareader EXEC sp_addrolemember N'db_datareader', N'pcrs_readonly' EXEC sp_addrolemember N'db_ddladmin', N'pcrs_readonly' GRANT CREATE TABLE TO pcrs_readonly GRANT DELETE,INSERT TO pcrs_readonly GRANT SELECT ON sys.database_files TO pcrs_readonly
Do not associate any server roles to the login other than the default public server role.