Rights required for the specified SQL account or the Application Identity when Installing Notification Server database

book

Article ID: 180027

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
What rights are required for the SQL account or the Application Identity when Installing the Notification Server Database?  Specifically what rights are needed for the account chosen during the third step of the Setup Wizard, or the database setup screen?

Answer

The following items are required:
  1. Database creation rights to the specified SQL Server.
  2. DBO rights to the newly created Altiris database.
  3. Public rights to the Master database generally granted through the databases guest account.
  4. Public rights to the Temp database generally granted through the databases guest account.

How to set these rights to the account being used:

Using Enterprise Manager, following these steps:

  1. Browse down the tree on the left into Microsoft SQL Servers, SQL Server Group, and then the local or remote SQL Server being used.
  2. Browse into the Security section.
  3. Select Logins.
  4. If the user is already present in the right pane, double-click on the user. If the user isn’t present, right-click and select New Login, then add the account to be used.
  5. Under the Database Access tab, check the Altiris database and in the below window check the DBO option. Do the same for the Altiris Incidents database.
  6. Check the Master database for a guest account (open the master database in enterprise manager and open the user folder) if a guest account does not already exist; then go back to the security properties of the Altiris user under security logins back to the Database Access tab, select master, and, in the window below, check the public option.
  7. Check the Tempdb database for a guest account (open the tempdb database in enterprise manager and open the user folder), if a guest account does not already exist, then go back to the security properties of the Altiris user under security logins back to the Database Access tab, select master and in the windows below check the public option.