Security permissions needed to access MDB moved to new SQL Server
search cancel

Security permissions needed to access MDB moved to new SQL Server

book

Article ID: 243801

calendar_today

Updated On:

Products

Automation Point

Issue/Introduction

Moved the MDB to new SQL Server, what permissions does ID need to access?  Master or Just MDB? 

 

 

 

Environment

Release : 11.6

Component : Automation Point

Resolution

First, on the NM Setup, the admin username is set to apnmdba.

Next, the SQL Server instance that is used to maintain the Notification Manager Database requires the following settings:

  • The mixed-mode authentication
  • The dictionary sort order of case-insensitive or case-sensitive
  • 1252 Character Set

More information can be found at this link:  https://techdocs.broadcom.com/us/en/ca-mainframe-software/automation/automation-point/11-7/installing/prepare-for-installation/operating-system-support/address-workstation-housing-for-notification-manager-requirements.html