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
    Posts
  • #101613

    Pascal
    Participant

    Hello,

    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 
    correct 
        + 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
    Keymaster

    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.