SqlDatabase and siblings: Support for login type 'SqlLogin'

[tlxreh]

This is a feature / improvement request.

From the examples a new database can be created like so:

        SqlDatabase 'Create_Database'
        {
            Ensure               = 'Present'
            ServerName           = 'sqltest.company.local'
            InstanceName         = 'DSC'
            Name                 = 'Contoso'

            PsDscRunAsCredential = $SqlAdministratorCredential
        }

But underneath the connection to the server is done with Connect-SQL like so:

$sqlServerObject = Connect-SQL -ServerName $ServerName -InstanceName $InstanceName -ErrorAction 'Stop'

This means if you don't have Windows Authentication between the machine running the configuration and the machine running SQL Server, and would want to use SqlLogin for the login type, you're blocked at the moment.

[johlju]

This seems to be an issue for all of the MOF-based DSC resources. Happy to see a PR that adds this logic to one DSC resource to start, with unit tests.