How can we help you today? How can we help you today?

Monitoring SQL Server without sysadmin permission

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



briangee
0

Comments

4 comments

Sort by
  • 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
    Alex B
    0
  • 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
    0
  • 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
    0
  • briangee
    Thanks Alex. I will go through those permissions.
    briangee
    0

Add comment

Please sign in to leave a comment.