HPE Community
Server Management - Systems Insight Manager
1833030 Members
2406 Online
110049 Solutions
New Discussion

HPSIM41 SQL Server rights

 
Daryl Linge
Occasional Contributor

‎08-17-2004 08:09 AM

‎08-17-2004 08:09 AM

HPSIM41 SQL Server rights

We have HPSIM41 core components installed on a W2K ADV SP4 Server. Database is on a W2K ADV SP4 Server with SQL 2000. For security reasons we have dropped the built in administrators group. The Service account that runs the HPSIM service is using a domain account.

What are the minimum rights needed in the database for the domain account? Currently it has Data Reader and Data Writer in the database. We have audit tracing enabled and we can see the service account id is having some issues in the database trying to run DBCC reindex and it is failing. I really don't want ot give the account sysadmin unless it is neccessary.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.