dsccommunity / dsccommunity/SqlServerDsc
SqlEndpoint: Enforces default values
Open
Nobody has claimed this yet.
bug
help wanted
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Details of the scenario you tried and the problem that is occurring
If the IPAddress parameter is not set, it will default to 0.0.0.0 and enforce the property is set to 0.0.0.0. This resource should ensure only user set properties are enforced.
The DSC configuration that is using the resource (as detailed as possible)
xSQLServerEndpoint HADREndpoint
{
EndpointName = $hadrEndpointName
Ensure = 'Present'
Port = 5022
SQLServer = $sqlServer
SQLInstanceName = $instanceName
PsDscRunAsCredential = $Node.RunAsCredential
}
Version of the operating system and PowerShell the target node is running
Caption OSArchitecture Version MUILanguages $PSVersionTable.PSVersion
------- -------------- ------- ------------ -------------------------
Microsoft Windows Server 2012 R2 Standard 64-bit 6.3.9600 {en-US} 5.0.10586.117
SQL Server edition and version the target node is running
Edition : Enterprise Edition: Core-based Licensing
Version : 13.1.4001.0
Language : 1033
What SQL Server PowerShell modules, and which version, are present on the target node.
Name Version Path
---- ------- ----
SQLPS 1.0 C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\SQLPS\SQLPS.psd1
Version of the DSC module you're using, or write 'dev' if you're using current dev branch
xSqlServer 8.2.0.0
Appears to be an issue in the current dev branch as well.
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 at the SqlEndpoint DSC resource entry point and reproduce the shown configuration with IPAddress omitted. Trace how default values are enforced, then verify that only properties explicitly set by the user are enforced while the example still configures the endpoint correctly.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100