Updated SQL RunAs addendum MP’s


 

Just a quick notice to let everyone know I updated my SQL RunAs Addendum MP’s.

If you haven't read about this, it is a new way to configure security for the SQL management packs which eases administrative burden with traditional RunAs accounts.  Read more about the solution here:    https://blogs.technet.microsoft.com/kevinholman/2016/04/26/sql-mp-run-as-accounts-no-longer-required/

 

In this update:

  • Version 6.7.2.0 – Update
    • Added support for SQL 2016
    • Added additional monitors to check for ability to connect to SQL and sysadmin role check
    • Removed any alerting by default to reduce noise.
    • Added new task to configure Healthservice login for LOW PRIV to SQL
    • Added folders, and state views to ease configuration and running tasks.

 

You can download the updated MP’s on TechNet Gallery:

https://gallery.technet.microsoft.com/SQL-Server-RunAs-Addendum-0c183c32


Comments (1)

  1. Michal says:

    Hi Kevin,
    When I run the task (Create HealthService Login as ...) I have a problem with no default SQL instance np. eg. SQLInstalneName not MSSQLSERVER.
    If you be so kind and add posilitity to change SQL instance name (override on task) or change the discovery?
    BDW great job!
    Michal

  2. Kevin Holman says:

    The script works whether you have a named or default instance of SQL - as we use the connect string targeting the SQL DB engine. Not sure what your issue is?

Skip to main content