What SQL rights or database permissions are needed for the application identity?
The following content applies to Notification Server 6 and Notification Server 7.x and 8.x.
Minimum SQL Security Requirements
The account that Notification Server uses to access the SQL database needs to be able to do the following:
The Notification Server user account will need “dbcreator” permissions in order for the Notification Server installation process to create the Notification Database. If the SQL administrator creates the Notification Database prior to Notification Server installation, then this permission is not necessary.
Just point the installation process to the already present Notification Database.
On the Notification Database itself, the user will need the following permissions:
To verify that the Application Identity is DBO on the database, run the following SQL command as the Application Identity: