Create HealthService Login as SA Role SQL 2016

Microsoft.SQLServer.RunAs.2016.Addendum.HealthServiceAsSA.Task (Task)

Element properties:

Target	Microsoft.SQLServer.2016.DBEngine
Accessibility	Internal
Category	Maintenance
Enabled	True
Remotable	False
Timeout	300

Member Modules:

ID	Module Type	TypeId	RunAs
PA	ProbeAction	System.CommandExecuterProbe	Default

Source Code:

<Task ID="Microsoft.SQLServer.RunAs.2016.Addendum.HealthServiceAsSA.Task" Accessibility="Internal" Enabled="true" Target="SQL2016Disc!Microsoft.SQLServer.2016.DBEngine" Timeout="300" Remotable="true">

  <Category>Maintenance</Category>

  <ProbeAction ID="PA" TypeID="System!System.CommandExecuterProbe">

    <ApplicationName/>

    <WorkingDirectory>$Target/Property[Type="SQL2016Disc!Microsoft.SQLServer.2016.DBEngine"]/ToolsPath$\Binn</WorkingDirectory>

    <CommandLine>sqlcmd.exe -E -S $Target/Property[Type="SQL2016Disc!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ -Q "sp_addsrvrolemember 'NT SERVICE\HealthService', 'sysadmin'"</CommandLine>

    <TimeoutSeconds>120</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </ProbeAction>

</Task>