Permissions needed to create new DB account.

Applies to: Orion Network Performance Manager 10, SQL Server 2008 R2 Standard Edition
 

Problem Description.
 

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.





Cause.

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" role.

Orion Configuration Wizard seems to require the securityadmin role on the SQL login used for installing NPM.



Solution.

We found that adding the SQL login created for NPM installation to the "dbcreator" and "securityadmin" roles was enough for installing NPM successfully.





 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.