SQL Monitor Running with Non Admin Privileges over WinRM
KIRKHUGHES
Posts: 1 New member
Morning All,
Apologies if this has been posted before but I just wanted to share with all that I've managed to get SQL monitor working without giving Local Admin privileges on the monitored server and also non sysadmin on the SQL instance. This was also all achieved over WinRM rather than DCOM and whereas it's been a pain staking process, it's defiantly worth the pain to ensure we work on the principles of least privileges.
This is on a standalone server but will be now pushing this out across my whole monitored estate including Always on Clusters
I must say that the Redgate support team have been instrumental in this and in particular a big shout out to Russell Dunn who has assisted throughout.
If anyone has any questions, drop me a note.
Now to document it all for Business Continuity
Kirk
Apologies if this has been posted before but I just wanted to share with all that I've managed to get SQL monitor working without giving Local Admin privileges on the monitored server and also non sysadmin on the SQL instance. This was also all achieved over WinRM rather than DCOM and whereas it's been a pain staking process, it's defiantly worth the pain to ensure we work on the principles of least privileges.
This is on a standalone server but will be now pushing this out across my whole monitored estate including Always on Clusters
I must say that the Redgate support team have been instrumental in this and in particular a big shout out to Russell Dunn who has assisted throughout.
If anyone has any questions, drop me a note.
Now to document it all for Business Continuity
Kirk
