MSSQL 2014/2012: Discovery and Monitoring Failed

Forum: Operations Manager4
Viewing 1 post (of 1 total)
  • #230605
    Profile photo of cookson.stuart
    cookson.stuart
    Participant

    Hello, I am receiving the below and similar errors on a couple of SQL servers.  I have successfully discovered a lot of other SQL servers but these two servers keep failing.

    I have added them to the same Run As accounts as all the other SQL servers.  I have gone through the SQL MP Document to configure a low-privilege environment on these servers.  As far as I can tell everything has been done on all SQL servers so I can’t figure out why these two behave differently.

    Can anyone think of any other reason why this may be happening?

    Many thanks in advance
    <p class=”description”>Event ID: 7104. Management Group: Management Group. Script:
    DiscoverSQL2014DB.vbs. Version: 7.0.0.0. Instance: MSSQLSERVER : Database
    discovery script ‘DiscoverSQL2014DB.vbs’ for instance ‘MSSQLSERVER’
    failed.
    The next errors occurred:
    Query execution failed: [Microsoft][SQL
    Server Native Client 11.0][SQL Server]VIEW SERVER STATE permission was denied on
    object ‘server’, database ‘master’.</p>
    Event ID: 7103. Management Group: Management Group. Script:
    DiscoverSQL2012FileGroups.js. Version: 7.0.0.0. Instance: SQLPROGENY : File
    Groups Discovery script ‘DiscoverSQL2012FileGroups.js’ for instance ‘SQLPROGENY’
    failed.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.