Monitoring SQL Server without sysadmin permission

briangee · January 5, 2023 3:32PM

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>

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

Image: https://us.v-cdn.net/6029854/uploads/editor/sl/vjfxt5faghsj.png

Alex B · January 5, 2023 4:07PM

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 · January 5, 2023 3:41PM

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 · January 5, 2023 3:49PM

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?

Image: https://us.v-cdn.net/6029854/uploads/editor/56/hdq8mzqvxkr6.png

Image: https://us.v-cdn.net/6029854/uploads/editor/xl/3qdep6n0dq32.png

:

briangee · January 5, 2023 4:09PM

Thanks Alex. I will go through those permissions.

Monitoring SQL Server without sysadmin permission

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk