Thwack » SolarWinds » Orion Network Performance Monitor » SQL User ID issue

in More Search Options

SQL User ID issue

Last post 08-15-2007 6:23 AM by jsohotha. 1 replies.
Page 1 of 1 (2 items)
Sort Posts:

  • 08-13-2007 12:24 PM

    SQL User ID issue

    Reply

    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
    Filed under: ,
    • Post Points: 3

  • 08-15-2007 6:23 AM In reply to

    • jsohotha
    • Not Ranked
      •
    • Joined on 11-30-2006
    • United Kingdom
    • Posts 6
    • Points 12

    Re: SQL User ID issue

    Reply

    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.
    • Post Points: 1
Page 1 of 1 (2 items)