Permissions needed to create new DB account.
Applies to: Orion Network Performance Manager 10, SQL Server 2008 R2 Standard
We were trying to install Orion Network Performance Manager (NPM) using SQL Server 2008 R2
instance, when we received the following error
message by the Orion Configuration Wizard on the Database Account page:
The user "solarwind" does not have permission to create a new
database account. You must select an existing SQL account.
We created a SQL login for installing NPM with the "dbcreator" role assigned
only, but on a previous error on the Database Settings page of Orion
Configuration Wizard it was suggested to assigned that SQL login to the "sysadmin"
Orion Configuration Wizard seems to require the securityadmin role on the SQL
login used for installing NPM.
We found that adding the SQL login created for NPM installation to the "dbcreator"
and "securityadmin" roles was enough for installing NPM successfully.