DSC getting stuck when installing SQL Server Management Studio (SSMS)

This topic contains 1 reply, has 2 voices, and was last updated by  Don Jones 3 weeks ago.

  • Author
  • #101613



    I am pretty new to DSC and I am getting an Error when I try to install "SQL Server Management Studio (SSMS)" via DSC.
    If I run the same Arguments "/install /passive /norestart" directly in powershell it works without a problem;

    Here is my configuration file

    Configuration TempFolder {
    Import-DscResource -ModuleName 'PSDesiredStateConfiguration'
        Node TempFolder {
            File TempFolder {
                DestinationPath = 'D:\temp'
                Type = 'Directory'
                Ensure = 'Present'
            Package SSMS
                Ensure = "Present"
                Name = "SSMS-Setup-ENU"
                Path = "\\FRDV02519\Install\SSMS-Setup-ENU.exe"
                Arguments = "/install /passive /norestart"
                ProductId ="67F7D1B2-D1EB-404A-B71D-A3DC609C9A9D" 
    TempFolder -OutputPath "$env:PROGRAMFILES\WindowsPowerShell\DscService\Configuration\"
    new-dscchecksum -path  "$env:PROGRAMFILES\WindowsPowerShell\DscService\Configuration\TempFolder.mof"

    This is the error I am getting

    PowerShell DSC resource MSFT_PackageResource  failed to execute Set-TargetResource functionality with error message: The return code 1626 was not expected. Configuration is likely not 
        + CategoryInfo          : InvalidOperation: (:) [], CimException
        + FullyQualifiedErrorId : ProviderOperationExecutionFailure
        + PSComputerName        : FRDV02518
    The SendConfigurationApply function did not succeed.
        + CategoryInfo          : NotSpecified: (root/Microsoft/...gurationManager:String) [], CimException
        + FullyQualifiedErrorId : MI RESULT 1
        + PSComputerName        : FRDV02518
  • #101616

    Don Jones

    It's very probably trying to install Start menu shortcuts and failing because there's no user profile under DSC.

You must be logged in to reply to this topic.