dsccommunity / dsccommunity/SqlServerDsc

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

Open
#473 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement help wanted
Dominant language
PowerShell
Stars
385
Forks
224
PR merge metrics
No merged PRs in 30d

Description

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

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the xSQLServerSetup resource and reproduce the supplied DSC configuration using UpdateSource set to .\Updates and UpdateEnabled set to 'False'. Trace why setup exits without an error, then verify that setup completes successfully and the Test method detects the installed features.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell
Domain
databases, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.