You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SqlServerDsc\SqlScriptQuery : A duplicate resource identifier '[SqlScriptQuery][V-41402][medium][SRG-APP-000089-DB-000064].\DatabaseInstance::[SqlServer]DatabaseSettings' was found while processing the
specification for node 'localhost'. Change the name of this resource so that it is unique within the node specification.
Test-ConflictingResources : A conflict was detected between resources '[SqlScriptQuery][V-41402][medium][SRG-APP-000089-DB-000064].\DatabaseInstance::[SqlServer]DatabaseASettings (C:\Program
Files\WindowsPowerShell\Modules\PowerSTIG\4.3.0\DSCResources\Resources\SqlServer.ScriptQuery.ps1::14::17::SqlScriptQuery)' and
'[SqlScriptQuery][V-41402][medium][SRG-APP-000089-DB-000064].\DatabaseInstance::[SqlServer]DatabaseBSettings (C:\Program
Files\WindowsPowerShell\Modules\PowerSTIG\4.3.0\DSCResources\Resources\SqlServer.ScriptQuery.ps1::14::17::SqlScriptQuery)' in node 'localhost'. Resources have identical key properties but there are
differences in the following non-key properties: 'Variable'. Values 'Database=DatabaseA' don't match values 'Database=DatabaseB'. Please update these property values so that they are identical in both cases.
Expected behavior
The resource identifier for the rule should contain the database name to differentiate it from other rules.
Additional context
This system I am attempting to configure contains one SqlServer named instance containing two databases.
The text was updated successfully, but these errors were encountered:
@General-Fault,
Thanks for the issue. I have a fix in that will allow for multiple databases to be specified with the sqlscriptquery rule 41402. You will see this fix in milestone 4.4.0 which will release next month.
Describe the bug
When a system has multiple SqlServer databases on a single server instance, the generated rules will contain conflicts.
To Reproduce
Compile the configuration
TestConfig -Verbose
The compilation will fail with this error:
also fails:
Expected behavior
The resource identifier for the rule should contain the database name to differentiate it from other rules.
Additional context
This system I am attempting to configure contains one SqlServer named instance containing two databases.
The text was updated successfully, but these errors were encountered: