MSSQL 2017: Generic Template Seed Test Connectivity task

Microsoft.SQLServer.2017.Library.Task.TemplateSeed.TestConnection (Task)

MSSQL 2017 Template Seed Test Connectivity task

Element properties:

Target	Microsoft.SQLServer.2017.Library.TemplateSeed
Accessibility	Public
Category	System
Enabled	True
Remotable	False
Timeout	300

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	Microsoft.SQLServer.2017.Library.Task.TemplateSeed.TestConnection.WA	Microsoft.SQLServer.TaskAccount

Source Code:

<Task ID="Microsoft.SQLServer.2017.Library.Task.TemplateSeed.TestConnection" Accessibility="Public" Enabled="true" Target="Microsoft.SQLServer.2017.Library.TemplateSeed" Timeout="300" Remotable="true">

  <Category>System</Category>

  <WriteAction ID="WA" TypeID="Microsoft.SQLServer.2017.Library.Task.TemplateSeed.TestConnection.WA" RunAs="GPMP!Microsoft.SQLServer.TaskAccount">

    <MachineName/>

    <InstanceName/>

    <Login>$RunAs[Name="GPMP!Microsoft.SQLServer.SqlCredentialsProfile"]/UserName$</Login>

    <Password>$RunAs[Name="GPMP!Microsoft.SQLServer.SqlCredentialsProfile"]/Password$</Password>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <ConnectionString>$Target/Property[Type="Microsoft.SQLServer.2017.Library.TemplateSeed"]/ConnectionString$</ConnectionString>

    <Publisher>SQL2017Generic</Publisher>

    <ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>

  </WriteAction>

</Task>