Monitoring SQL Server without sysadmin permission

briangee

Hi

I'm unable to get sysadmin permissions on one of SQL Servers so attempting to alter the config file: RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config

I've added this to the config file:

      <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[IntegrityCheck]" clusterName="wtk-manser" sqlServerName="WTK-MANSER"> 

        <disabledSchedule /> 

      </schedule>

However I'm still getting monitoring error. It could be because I've not specified the values for ClusterName or SqlServerName correctly.

Can someone spot what I'm missing? Thanks

Alex B

Hi @briangee,

Have you gone through the permissions on https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/permissions-required-for-monitoring-servers under Monitoring SQL Server instances below the blue note box that indicates not being able to grant sysadmin privileges?  

It has the EXECUTE privilege and also requires db_owner for tempdb, or an alternative where you add a keyvaluepair entry so you do not need to have db_owner.

Kind regards,
Alex

Alex B

Hi @briangee, 

It will be this with the sqlServerName blank "" as that is how it is stored in the repository for the default instance:

<schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[IntegrityCheck]" clusterName="wtk-manser" sqlServerName="">
  <disabledSchedule /> 
</schedule>

Kind regards,
Alex

briangee

Thanks Alex. I now get two different errors. Any ideas?
I'm guessing the first error I need to allow INSERT permissions on the host server.

But the second error?

:

briangee

Thanks Alex. I will go through those permissions.