dsccommunity / dsccommunity/SqlServerDsc

SqlSetup: SQMReporting not disabled

Open
#1,785 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug good first issue help wanted
Dominant language
PowerShell
Stars
385
Forks
224
No merged PRs in 30d

Description

Problem description

Want to disable SQMReporting as part of install.

SQL Server is installed, but SQM never gets disabled.

I have tried both

SQMReporting = $false and SQMReporting = 'False'

Verbose logs
No errors clean install.

/SQMREPORTING="False"

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver16

The docs say the value should be 0 or 1. Does the SQLServerDSC module translate $false or 'False' to 0?

VERBOSE: Perform operation 'Invoke CimMethod' with following parameters, ''methodName' =
SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' =
root/Microsoft/Windows/DesiredStateConfiguration'.
VERBOSE: An LCM method call arrived from computer SERVERNAME with user sid

VERBOSE: [SERVERNAME]: LCM:  [ Start  Set      ]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[WindowsFeature]NetFramework]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[WindowsFeature]NetFramework]
VERBOSE: [SERVERNAME]:                            [[WindowsFeature]NetFramework] The operation 'Get-WindowsFea
started: NET-Framework-45-Core
VERBOSE: [SERVERNAME]:                            [[WindowsFeature]NetFramework] The operation 'Get-WindowsFea
succeeded: NET-Framework-45-Core
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[WindowsFeature]NetFramework]  in 0.6520 seconds.
VERBOSE: [SERVERNAME]: LCM:  [ Skip   Set      ]  [[WindowsFeature]NetFramework]
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[WindowsFeature]NetFramework]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[Group]SQLPerformVolumeMaintenanceTasks]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[Group]SQLPerformVolumeMaintenanceTasks]
VERBOSE: [SERVERNAME]:                            [[Group]SQLPerformVolumeMaintenanceTasks] A group with the n
SQLPerformVolumeMaintTasks exists.
VERBOSE: [SERVERNAME]:                            [[Group]SQLPerformVolumeMaintenanceTasks] Resolving MYDOMAIN
SQLPVM domain.
VERBOSE: [SERVERNAME]:                            [[Group]SQLPerformVolumeMaintenanceTasks] Resolving MYDOMAIN\
with domain trust.
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[Group]SQLPerformVolumeMaintenanceTasks]  in 1.3220 seconds
VERBOSE: [SERVERNAME]: LCM:  [ Skip   Set      ]  [[Group]SQLPerformVolumeMaintenanceTasks]
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[Group]SQLPerformVolumeMaintenanceTasks]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[Group]SQLAdjustMemoryQuotasForAProcess]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[Group]SQLAdjustMemoryQuotasForAProcess]
VERBOSE: [SERVERNAME]:                            [[Group]SQLAdjustMemoryQuotasForAProcess] A group with the n
SQLAdjustMemoryQuotasForAProcess exists.
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[Group]SQLAdjustMemoryQuotasForAProcess]  in 0.2020 seconds
VERBOSE: [SERVERNAME]: LCM:  [ Skip   Set      ]  [[Group]SQLAdjustMemoryQuotasForAProcess]
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[Group]SQLAdjustMemoryQuotasForAProcess]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[Group]SQLGenerateSecurityAudits]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[Group]SQLGenerateSecurityAudits]
VERBOSE: [SERVERNAME]:                            [[Group]SQLGenerateSecurityAudits] A group with the name
SQLGenerateSecurityAudits exists.
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[Group]SQLGenerateSecurityAudits]  in 0.1340 seconds.
VERBOSE: [SERVERNAME]: LCM:  [ Skip   Set      ]  [[Group]SQLGenerateSecurityAudits]
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[Group]SQLGenerateSecurityAudits]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[Group]SQLLockPagesInMemoryGroup]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[Group]SQLLockPagesInMemoryGroup]
VERBOSE: [SERVERNAME]:                            [[Group]SQLLockPagesInMemoryGroup] A group with the name
SQLLockPagesInMemoryGroup exists.
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[Group]SQLLockPagesInMemoryGroup]  in 0.1590 seconds.
VERBOSE: [SERVERNAME]: LCM:  [ Skip   Set      ]  [[Group]SQLLockPagesInMemoryGroup]
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[Group]SQLLockPagesInMemoryGroup]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[Group]SQLReplaceAProcessLevelToken]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[Group]SQLReplaceAProcessLevelToken]
VERBOSE: [SERVERNAME]:                            [[Group]SQLReplaceAProcessLevelToken] A group with the name
SQLReplaceAProcessLevelToken exists.
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[Group]SQLReplaceAProcessLevelToken]  in 0.1970 seconds.
VERBOSE: [SERVERNAME]: LCM:  [ Skip   Set      ]  [[Group]SQLReplaceAProcessLevelToken]
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[Group]SQLReplaceAProcessLevelToken]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Resource ]  [[SqlSetup]DB]
VERBOSE: [SERVERNAME]: LCM:  [ Start  Test     ]  [[SqlSetup]DB]
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Using path
'\\SHARENAME\PATH\SQL2019\Standard\setup.exe'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Database Engine feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Database Engine feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Full-text feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Full-text feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Reporting Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Reporting Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Analysis Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Analysis Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Integration Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Integration Services feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Perform operation 'Query CimInstances' with
following parameters, ''queryExpression' = SELECT * FROM Win32_Service WHERE Name = 'MsDtsServer150','queryDialec
WQL,'namespaceName' = root\cimv2'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Operation 'Query CimInstances' complete.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Documentation Components feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Documentation Components feature not detected
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Connectivity Tools feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Connectivity Tools feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Connectivity Backwards
Compatibility Tools feature (HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Connectivity Backwards Compatibility T
feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Tools SDK feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Tools SDK feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Master Data Services (MDS) feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] 'Master Data Services (MDS) feature not detec
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Features found: IS,CONN,BC
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Unable to find feature 'SQLENGINE' among the
installed features: 'IS,CONN,BC'.
VERBOSE: [SERVERNAME]: LCM:  [ End    Test     ]  [[SqlSetup]DB]  in 1.8230 seconds.
VERBOSE: [SERVERNAME]: LCM:  [ Start  Set      ]  [[SqlSetup]DB]
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Using path
'\\SHARENAME\PATH\SQL2019\Standard\setup.exe'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Database Engine feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Database Engine feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Full-text feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Full-text feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Reporting Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Reporting Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Analysis Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Analysis Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Integration Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Integration Services feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Perform operation 'Query CimInstances' with
following parameters, ''queryExpression' = SELECT * FROM Win32_Service WHERE Name = 'MsDtsServer150','queryDialec
WQL,'namespaceName' = root\cimv2'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Operation 'Query CimInstances' complete.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Documentation Components feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Documentation Components feature not detected
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Connectivity Tools feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Connectivity Tools feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Connectivity Backwards
Compatibility Tools feature (HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Connectivity Backwards Compatibility T
feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Tools SDK feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Tools SDK feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Master Data Services (MDS) feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] 'Master Data Services (MDS) feature not detec
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Robocopy is copying media from source
'\\SHARENAME\PATH\SQL2019\Standard'.' to destination
'C:\Users\username\AppData\Local\Temp\Standard'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Robocopy is using unbuffered I/O.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Robocopy is started with the following argume
'\\SHARENAME\PATH\SQL2019\Standard' "C:\Users\username\AppData\Local\Temp\Standard" /e /purg
/njh /njs /ndl /nc /ns /nfl
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Robocopy reported that all files already pres
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Using path
'C:\Users\username\AppData\Local\Temp\Standard\setup.exe'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Adding user 'MYDOMAIN\username' from the para
'PsDscRunAsCredential' as the first system administrator account for SQL Server.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Starting setup using arguments: /ACTION="Inst
/INSTANCEDIR="E:\Program Files\Microsoft SQL Server" /SQLUSERDBDIR="I:\MSSQL\MSSQL15.SB2\MSSQL\Data"
/AGTSVCSTARTUPTYPE="Automatic" /QUIET="True" /SECURITYMODE="SQL" /INSTALLSHAREDWOWDIR="E:\Program Files (x86)\Mic
SQL Server" /IACCEPTSQLSERVERLICENSETERMS="True" /SQLTEMPDBLOGDIR="H:\MSSQL\MSSQL15.SB2\MSSQL\Data"
/INSTANCENAME="SB2" /SQLBACKUPDIR="F:\MSSQL\MSSQL15.SB2\MSSQL\Backup"
/UPDATESOURCE=\\SHARENAME\PATH\SQL2019\Updates\APPROVED /SQMREPORTING="False"
/SQLUSERDBLOGDIR="J:\MSSQL\MSSQL15.SB2\MSSQL\Data" /SQLSYSADMINACCOUNTS="MYDOMAIN\ADMIN1" "MYDOMAIN\ADMIN2
"MYDOMAIN\ADMIN3" "MYDOMAIN\ADMIN4" /SQLTEMPDBDIR="G:\MSSQL\MSSQL15.SB2\MSSQL\Data"
/SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" /FEATURES=SQLENGINE /INSTALLSQLDATADIR="F:\MSSQL"
/INSTALLSHAREDDIR="E:\Program Files\Microsoft SQL Server" /UPDATEENABLED="True" /BROWSERSVCSTARTUPTYPE="Automatic
/SAPWD="********"
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Started the process with id 4884 using the pa
'C:\Users\username\AppData\Local\Temp\Standard\setup.exe', and with a timeout value of 7200 seconds.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Setup exited with code '0'. Setup finished
successfully.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Rebooting target node.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Using path
'\\SHARENAME\shares\PATH\SQL2019\Standard\setup.exe'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Database Engine feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Database Engine feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Perform operation 'Query CimInstances' with
following parameters, ''queryExpression' = SELECT * FROM Win32_Service WHERE Name = 'MSSQL$SB2','queryDialect' =
WQL,'namespaceName' = root\cimv2'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Operation 'Query CimInstances' complete.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Perform operation 'Query CimInstances' with
following parameters, ''queryExpression' = SELECT * FROM Win32_Service WHERE Name = 'SQLAgent$SB2','queryDialect'
WQL,'namespaceName' = root\cimv2'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Operation 'Query CimInstances' complete.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting replication feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.SB2\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Replication feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Data Quality Client feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Data Quality Client feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Data Services Client feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\DQ\*).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Data Quality Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Preferred module SqlServer found.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Importing PowerShell module 'SqlServer' with
version '21.1.18221' from path 'C:\Program Files\WindowsPowerShell\Modules\SqlServer\21.1.18221\SqlServer.psd1'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Connected to SQL instance 'SERVERNAME\SB2'
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Clustered instance not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Full-text feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Full-text feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Reporting Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Reporting Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Analysis Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Analysis Services feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Integration Services feature.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Integration Services feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Perform operation 'Query CimInstances' with
following parameters, ''queryExpression' = SELECT * FROM Win32_Service WHERE Name = 'MsDtsServer150','queryDialec
WQL,'namespaceName' = root\cimv2'.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Operation 'Query CimInstances' complete.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Documentation Components feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Documentation Components feature not detected
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Connectivity Tools feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Connectivity Tools feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Connectivity Backwards
Compatibility Tools feature (HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Connectivity Backwards Compatibility T
feature detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Client Tools SDK feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\Tools\Setup\Client_Components_Full).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Client Tools SDK feature not detected.
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Detecting Master Data Services (MDS) feature
(HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\150\ConfigurationState).
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] 'Master Data Services (MDS) feature not detec
VERBOSE: [SERVERNAME]:                            [[SqlSetup]DB] Features found: SQLENGINE,IS,CONN,BC
VERBOSE: [SERVERNAME]: LCM:  [ End    Set      ]  [[SqlSetup]DB]  in 126.3240 seconds.
VERBOSE: [SERVERNAME]: LCM:  [ End    Resource ]  [[SqlSetup]DB]
VERBOSE: [SERVERNAME]:                            [] A reboot is required to progress further. Please reboot t
system.
WARNING: [SERVERNAME]:                            [] A reboot is required to progress further. Please reboot t
system.
VERBOSE: [SERVERNAME]: LCM:  [ End    Set      ]
VERBOSE: [SERVERNAME]: LCM:  [ End    Set      ]    in  131.6660 seconds.
VERBOSE: Operation 'Invoke CimMethod' complete.
VERBOSE: Time taken for configuration job to complete is 131.734 seconds
DSC configuration
snippet of configuration is shown below


 elseif($Features.ToUpper().Contains("SQLENGINE")){

                SqlSetup DB {
                    InstanceName = $sqlConfig.Instance
                    SourcePath = $sqlConfig.SourcePath
                    SourceCredential = $Credential
                    Features = $sqlConfig.Features
                    InstallSharedDir = $sqlConfig.InstallSharedDir 
                    InstallSharedWOWDir= $sqlConfig.InstallSharedWOWDir
                    InstanceDir= $sqlConfig.InstanceDir
                    SQLCollation=$sqlConfig.SQLCollation
                    SQLSysAdminAccounts=$sqlConfig.AdminAccounts.admin1,$sqlConfig.AdminAccounts.admin2,$sqlConfig.AdminAccounts.admin3
                    InstallSQLDataDir=$sqlConfig.InstallSQLDataDir
                    SQLUserDBDir=$sqlConfig.SQLUserDBDir
                    SQLUserDBLogDir=$sqlConfig.SQLUserDBLogDir
                    SQLTempDBDir = $sqlConfig.SQLTempDBDir
                    SQLTempDBLogDir = $sqlConfig.SQLTempDBLogDir
                    SQLBackupDir=$sqlConfig.SQLBackupDir
	                SecurityMode = 'SQL'
                    SAPwd = New-Object System.Management.Automation.PSCredential("sa", (ConvertTo-SecureString ([System.Web.Security.Membership]::GeneratePassword(16,2)) -AsPlainText -Force))
                    UpdateEnabled = $true
                    UpdateSource=$sqlConfig.UpdateSource
                    BrowserSvcStartupType = 'Automatic'
                    SQMReporting='False'
                    #SQLSvcAccount = $Node.SQLSvcAccount
                    #AgtSvcAccount = $Node.AgtSvcAccount
                    DependsOn='[WindowsFeature]NetFramework';
                    PsDscRunAsCredential = $Credential
                }
Suggested solution

N/A

SQL Server edition and version
SQL Server 2019
SQL Server PowerShell modules
Name      Version    Path
----      -------    ----
SqlServer 21.1.18221 C:\Program Files\WindowsPowerShell\Modules\SqlServer\21.1.18221\SqlServer.psd1
SQLPS     15.0       E:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\SQLPS\SQLPS.psd1
Operating system
OsName               : Microsoft Windows Server 2022 Standard
OsOperatingSystemSKU : StandardServerEdition
OsArchitecture       : 64-bit
WindowsVersion       : 2009
WindowsBuildLabEx    : 20348.1.amd64fre.fe_release.210507-1500
OsLanguage           : en-US
OsMuiLanguages       : {en-US}
PowerShell version
Name                           Value
----                           -----
PSVersion                      5.1.20348.859
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.20348.859
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
SqlServerDsc version
Name         Version  Path
----         -------  ----
SqlServerDsc 12.0.0.0 C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\12.0.0.0\SqlServerDsc.psd1

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 by tracing the SqlSetup resource's handling of the SQMReporting parameter and the generated SQL Server setup command shown in the verbose log. Verify how Boolean and string values are translated, then confirm that the resulting /SQMREPORTING value disables SQM reporting during installation.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.