Sqlps utility fails to run when the "Turn on Script Execution" policy is set to "Allow all scripts" in SQL Server
Copyright (c) 2012 Microsoft. All rights reserved.
set-executionpolicy : Windows PowerShell updated your execution policy successfully, but the setting is overridden by a policy defined at a more specific scope. Due to the override, your shell will retain its current effective execution policy of "Unrestricted". Type "Get-ExecutionPolicy -List" to view your execution policy settings. For more information, please see "Get-Help Set-ExecutionPolicy."
At line:1 char:20
+ set-executionpolicy <<<< RemoteSigned -scope process -Force
+ CategoryInfo : PermissionDenied: (:) [Set-ExecutionPolicy], SecurityException
+ FullyQualifiedErrorId : ExecutionPolicyOverride,Microsoft.PowerShell.Commands.SetExecutionPolicyCommand
Additionally, the syspolicy_purge_history job fails.
Note The Turn on Script Execution Group Policy setting can be configured in the following location in the Group Policy Management Console:
Update informationThis issue is fixed in the following cumulative updates of SQL Server:
Cumulative Update 4 for SQL Server 2012 Service Pack 3
Cumulative update 9 for SQL Server 2014 SP1
Cumulative update 3 for SQL Server 2014 SP2
Recommendation: Install the latest cumulative update for SQL Server
Article ID: 3122088 - Last Review: 12/28/2016 18:09:00 - Revision: 7.0
- kbqfe kbfix kbexpertiseinter kbsurveynew KB3122088