Security permissions needed to access MDB moved to new SQL Server

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