Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

never converge after apply SQL 2016 v1.3 #451

Open
pursca opened this issue Aug 4, 2019 · 1 comment
Open

never converge after apply SQL 2016 v1.3 #451

pursca opened this issue Aug 4, 2019 · 1 comment
Assignees
Labels
bug Something isn't working In Progress

Comments

@pursca
Copy link

pursca commented Aug 4, 2019

Describe the bug
after apply SQL 2016 v1.3 STIG the state never return true after 24 hours

To Reproduce

  1. on a member server with sql 2016 installed, default instance
  2. apply the following configuration

configuration SqlS2016STIG
{
param
(
[parameter()]
[string]
$NodeName = 'localhost'
)
Import-DscResource -ModuleName PowerStig
Node $NodeName
{
SqlServer BaseLine
{
SqlVersion = '2016'
SqlRole = 'Instance'
StigVersion = '1.3'
ServerInstance = 'SQL2016STIG'
}
}
}
SqlS2016STIG -NodeName localhost -OutputPath C:\STIG\SQLConfig
Start-dscconfiguration -path c:\stig\Sqlconfig

  1. constantly check Test-DscConfiguration ... always show as false with pending state
  2. run get-DscConfiguration got following error:

Get-DscConfiguration : PowerShell DSC resource MSFT_SqlScriptQuery failed to execute Get-TargetResource functionality
with error message: The running command stopped because the preference variable "ErrorActionPreference" or common
parameter is set to Stop: Incorrect syntax near ')'.
At line:1 char:1

  • Get-DscConfiguration
  •   + CategoryInfo          : InvalidOperation: (MSFT_DSCLocalConfigurationManager:root/Microsoft/...gurationManager)
     [Get-DscConfiguration], CimException
      + FullyQualifiedErrorId : ProviderOperationExecutionFailure,Get-DscConfiguration
    
    
    

Expected behavior

@stevehose stevehose self-assigned this Nov 7, 2019
@stevehose stevehose added bug Something isn't working In Progress labels Nov 7, 2019
@Applesnacks
Copy link

The audit location is built into the set query as C:\Audits
I had to create this directory manually to get the configuration to apply and converge.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working In Progress
Projects
None yet
Development

No branches or pull requests

3 participants