[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Permissions needed to create new DB account

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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 sqlcoffee.stretch737@simplelogin.com with questions or comments about this web site.