Revisions to Insufficient SQL database permissions for user 'Name: NT AUTHORITY\SYSTEM SID: S-1-5-18 ImpersonationLevel: None' in database SP_ConfigDB

edited body

Source Link

edited Jan 23, 2020 at 4:13

1k
8
28

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Then iI run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Then i run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Then I run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

edited body

Source Link

edited Dec 23, 2019 at 10:06

Raf

1k
8
28

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

ThanThen i run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Than i run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Then i run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

added 64 characters in body

Source Link

edited Nov 8, 2019 at 5:51

Raf

1k
8
28

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action - -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager: -Method PerformRequiredConfigurationChecks-NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Than i run PS command -Arguments @{Flags = [SystemGet-DscConfiguration and find out that "Snow Inventory Agent" is involved.UInt32]1}"

What is this?

Workaround: This planning task fires every 15 minutes and when I execute it manuallyConfigure "Desired State Configuration - errors registering in event logs> Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action - -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

What is this? This planning task fires every 15 minutes and when I execute it manually - errors registering in event logs.

I figured out that it is triggered by Microsoft planning task - "Desired State Configuration - > Consistency".

Action: -NonInt -Window Hidden -Command "Invoke-CimMethod -Namespace root/Microsoft/Windows/DesiredStateConfiguration -Cl MSFT_DSCLocalConfigurationManager -Method PerformRequiredConfigurationChecks -Arguments @{Flags = [System.UInt32]1}"

Than i run PS command Get-DscConfiguration and find out that "Snow Inventory Agent" is involved.

Workaround: Configure "Desired State Configuration - > Consistency" job to run under SP Farm account(local admin + dbOwner).

If you know more elegant way, please suggest.

Source Link

created Nov 6, 2019 at 11:06

Raf

1k
8
28

Loading

Stack Exchange Network

Return to Answer