dsccommunity / dsccommunity/SqlServerDsc
SqlSetup: If UpdateSource is set to a value and UpdateEnabled is set to 'False' the setup fails
Nobody has claimed this yet.
- 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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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