Base Monitor Setup
Monday
Posts: 77 Silver 3
Does the Base Monitor need to use the same credentials to update the RedGateMonitor DB and monitor the servers?
I initially set it up with my ID which has access to both. Now I changed the monitor service to run under another ID, do I have to give that ID access to the RedGateMonitor DB? I would rather use a SQL ID instead but not sure if it can be configured this way.
Thanks
I initially set it up with my ID which has access to both. Now I changed the monitor service to run under another ID, do I have to give that ID access to the RedGateMonitor DB? I would rather use a SQL ID instead but not sure if it can be configured this way.
Thanks
Comments
The base monitor service account needs to be a member of the db_owner database role on the RedGateMonitor database.
The credentials for the monitored servers can be specified as they are being added to the system, or edited later by selecting the relevant line on the Monitored Servers page and selecting Edit Credentials from the drop-down on the right hand side of the page.
More details of the various permissions required can be found on the online help page
http://www.red-gate.com/supportcenter/C ... 269935.htm
Hope this helps
Chris
Test Engineer
Red Gate