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: 184.108.40.206. Instance: MSSQLSERVER : Database
discovery script ‘DiscoverSQL2014DB.vbs’ for instance ‘MSSQLSERVER’
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: 220.127.116.11. Instance: SQLPROGENY : File
Groups Discovery script ‘DiscoverSQL2012FileGroups.js’ for instance ‘SQLPROGENY’