SQL User ID issue

Question

Can anyone tell me that complete requirements for the NetPerfMon User ID for the SQL Database?

I am sharing a SQL database server and am having issues with the server team saying that the userid rights need to be changed. They want to remove the admin rights of the user id. Every thime they had done this I have has issues using the Database Manager.

Thanks

Jim Lewis

jsohotha · Answer

There are 2 user ID's used with Orion and the NetPerfMon database.

The first was probably created by yourself and needs SA rights (this is going to be the one your DBA's are moaning about) during installation so it can create a new table and also create another account (SolarWindsNPM) with permissions to that table only.

The SolarWindsNPM account shouldnt really be touched and its permissions shouldnt be an issue it is used for nightly and DB compact maintenance.

The SA account is used during installation AND upgrading + the database manager. Unfortunatly it seems to need SA rights and if your DBA's are unhappy with that then they will have to keep checks on its size and be willing to notify / work with you when there are issues.

PS keep an eye on the VarBindTraps table it tends to fill up and I tend to have to truncate it every so often.