If you set the Turn on Script Execution Group Policy setting to Allow all Scripts, the sqlps utility fails to run, and you receive the following error message:
Microsoft (R) SQL Server (R) PowerShell
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:
Administrative Templates\Classic Administrative Templates\Windows Components\Windows PowerShell
This issue is fixed in the following cumulative updates of SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology that Microsoft uses to describe software updates.