Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SqlSetup: If UpdateSource is set to a value and UpdateEnabled is set to 'False' the setup fails #473

Open
johlju opened this issue Apr 5, 2017 · 0 comments
Labels
enhancement The issue is an enhancement request. help wanted The issue is up for grabs for anyone in the community.

Comments

@johlju
Copy link
Member

johlju commented Apr 5, 2017

Details of the scenario you try and problem that is occurring:
If parameter UpdateSource is set to a value and UpdateEnabled is set to 'False' then the setup fails without an error. The setup ends quickly without an error, and after htat the resource reports from the Test-method that no features was found and the resource errors out.

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

xSQLServerSetup $resourceConfigName
{
    InstanceName = $Node."$($currentSqlInstance)InstanceName"
    Features = $Node."$($currentSqlInstance)InstallFeatures"
    BrowserSvcStartupType = 'Automatic'
    SQLCollation = 'Finnish_Swedish_CI_AS'
    SQLSvcAccount = $SqlServiceCredential
    AgtSvcAccount = $SqlAgentServiceCredential
    #ASSvcAccount = $SqlServiceCredential
    SQLSysAdminAccounts = 'COMPANY\SQLAdmins', $SqlAdministratorCredential.UserName
    SetupCredential = $SqlInstallCredential

    SourcePath = $Node."SourcePath$($currentSqlInstance)"
    SourceCredential = $SqlInstallCredential

    UpdateEnabled = 'False'
    UpdateSource = '.\Updates'

    SuppressReboot = $false
    ForceReboot = $false

    DependsOn = '[WindowsFeature]NetFramework45'
}

Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
Windows Server 2012, SQL Server 2016, WMF 5.0

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

@johlju johlju added enhancement The issue is an enhancement request. help wanted The issue is up for grabs for anyone in the community. labels Apr 5, 2017
@johlju johlju changed the title xSQLServerSetup: If UpdateSource is set to a value and UpdateEnabled is set to 'False' the setup fails SqlSetup: If UpdateSource is set to a value and UpdateEnabled is set to 'False' the setup fails Dec 22, 2017
@SteveL-MSFT SteveL-MSFT added this to Help Wanted in powershell/dscresources May 14, 2019
@SteveL-MSFT SteveL-MSFT removed this from Help Wanted in powershell/dscresources Nov 27, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement The issue is an enhancement request. help wanted The issue is up for grabs for anyone in the community.
Projects
None yet
Development

No branches or pull requests

1 participant