SqlServiceAccount: Expected Get-TargetResource to return 'DatabaseEngine' and 'SqlServerAgent'

[johlju]

Details of the scenario you tried and the problem that is occurring:
When using SqlServiceAccount with the following configuration, I'm expected Get-TargetResource to also return 'DatabaseEngine' and 'SqlServerAgent' as the service type, but it returns 'SqlServer' and 'SqlAgent' respectively.

[-] Should have set the resource and all the parameters should match 670ms
  Expected string length 14 but was 9. Strings differ at index 0.
  Expected: {DatabaseEngine}
  But was:  {SqlServer}
  -----------^
  103:                 $resourceCurrentState.ServiceType    | Should -Be $mockServiceTypeDatabaseEngine

      [-] Should have set the resource and all the parameters should match 1.66s
        Expected string length 14 but was 8. Strings differ at index 3.
        Expected: {SQLServerAgent}
        But was:  {SqlAgent}
        --------------^
        153:                 $resourceCurrentState.ServiceType | Should -Be $mockServiceTypeSqlServerAgent

I suggest we change this so that Get-TargetResource returns 'DatabaseEngine' and 'SqlServerAgent' to be consistent.

The DSC configuration that is using the resource (as detailed as possible):

SqlServiceAccount Integration_Test
{
    ServerName     = $Node.ServerName
    InstanceName   = 'MSSQLSERVER'
    ServiceType    = 'DatabaseEngine'
    ServiceAccount = $SqlServiceSecondaryCredential
    RestartService = $true
}

Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
n/a

What module (SqlServer or SQLPS) and which version of the module the DSC Target Node is running:
n/a

Version of the DSC module you're using, or 'dev' if you're using current dev branch:
Dev