Kevin - awesome thanks this should really help as I have over 90 SQL servers across 15 customer domains/workgroups.
Peter Hakesley | Monitoring & Automation Technical Lead Engineer, Data Centre Services t: +44(0)845 155 6556 ext: 4006 e: [email protected] | w: www.scc.com<http://www.scc.com/> a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Holman Sent: 03/February/2017 15:08 To: [email protected] Subject: [msmom] RE: RunAs Profiles and Accounts That should work. (I haven't tested SQL in a workgroup) However, I wouldn't do that. I would convert to service SID monitoring across the board. https://blogs.technet.microsoft.com/kevinholman/2016/08/25/sql-mp-run-as-accounts-no-longer-required-2/ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Pete Hakesley Sent: Friday, February 3, 2017 8:48 AM To: [email protected]<mailto:[email protected]> Subject: [msmom] RunAs Profiles and Accounts All, I have a requirement to monitor a SQL 2012 server on a DMZ so it is in a WORKGROUP. The DBA has created a local account for use to monitor SQL I have created the RUNAS account using the machine name for the domain entry is this correct way or can it only use domain account? Peter Hakesley | Monitoring & Automation Technical Lead Engineer, Data Centre Services t: +44(0)845 155 6556 ext: 4006 e: [email protected]<mailto:[email protected]> | w: www.scc.com<http://www.scc.com/> a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ
