SQL Server Articles, Tips, FAQs, Reviews, Whitepaper, News etc - MyTechMantra.com

How to Fix PowerShell Execution Policy Error in Windows Server

There are instance when you execute your PowerShell scripts on server from your command prompt you will end up seeing below mentioned error message.

Error Message

File cannot be loaded because the execution of scripts is disabled on this system. Please see "get-help about_signing" for more details

This article mentions the steps which you need to follow to fix “File cannot be loaded because the execution of scripts is disabled on this system.” error message.

The primary reason why you end up seeing this error message is because of the PowerShell Execution Policy Security Settings which are built into the Windows PowerShell. It basically decides how PowerShell will execute the scripts.

The Windows PowerShell execution policy is by default set to be RESTRICTED and hence the scripts will not run until the settings are changed.

How to Verify the Existing PowerShell Execution Policy Setting

Step 1: Open Command Prompt and Enter PowerShell

Step 2: Type Get-ExecutionPolicy and hit enter as shown in the snippet below.

Get-ExecutionPolicy
How to Verify the Existing PowerShell Execution Policy Setting

There are basically Four Different Windows PowerShell Execution Policy behaviours namely:

  • Restricted: – It is primarily an interactive mode, wherein no PowerShell scripts can be executed
  • Unrestricted: – As the name suggests there is no restriction set and henceforth all the PowerShell scripts can be executed.
  • RemoteSigned: – As the name suggests all the downloaded scripts needs to be signed from a trusted published to execute them on the server.
  • AllSigned: – It means that the scripts which are signed from a trusted publisher can only be executed

Since in our case we have seen that Windows PowerShell Execution Policy is set to be Restricted on the server. We need to change the behaviour and for that we need to use the PowerShell cmdlet Set-ExecutionPolicy.

Privileges Needed to Execute Set-ExecutionPolicy PowerShell cmdlet

One must be having Windows Administrator Privileges to execute Set-ExecutionPolicy PowerShell cmdlet on your windows operating system. If you are an administrator then you can open Command Prompt with Administrator Privileges (Run as Administrator) to execute Set-ExecutionPolicy PowerShell cmdlet. Either of the below options will work fine for you.

How to Change PowerShell Execution Policy Setting to Unrestricted

Step 1: Open Command Prompt and Enter PowerShell

Step 2: Type Set-ExecutionPolicy Unrestricted and hit enter as shown in the snippet below.

Set-ExecutionPolicy Unrestricted 
How to Change PowerShell Execution Policy Setting to Unrestricted

How to Change PowerShell Execution Policy Setting to RemoteSigned

Step 1: Open Command Prompt and Enter PowerShell

Step 2: Type Set-ExecutionPolicy RemoteSigned and hit enter as shown in the snippet below.

Set-ExecutionPolicy RemoteSigned
How to Change PowerShell Execution Policy Setting to RemoteSigned

How to Get PowerShell cmdlet Syntax Help to understand information about PowerShell Syntax and Acceptable Parameters?

If you want to understand the syntax and the parameter acceptable for a PowerShell cmdlet then execute Get-Help followed by PowerShell cmdlet Set-ExecutionPolicy as shown in the snippet below to displays information about PowerShell concepts and commands, including cmdlets, functions, Common Information Model (CIM) commands, workflows, providers, aliases, and scripts.

Get-Help Set-ExecutionPolicy 
How to Get PowerShell cmdlet Syntax Help to understand information about PowerShell Syntax and Acceptable Parameters

Conclusion

In this article we have seen the steps which you need to follow to fix “File cannot be loaded because the execution of scripts is disabled on this system.” error message to run PowerShell scripts in your environment.

Reference

Chetna Bhalla

Chetna Bhalla

LESS ME MORE WE

Chetna Bhalla, the founder of MyTechMantra.com, believes that by sharing knowledge and building communities, we can make this world a better place to live in. Chetna is a Graduate in Social Sciences and a Masters in Human Resources and International Business. She is an alumnus of Vignana Jyothi Institute of Management, Hyderabad, India. After graduation, Chetna founded this website, which has since then become quite a favorite in the tech world. Her vision is to make this website the favorite place for seeking information on Databases and other Information Technology areas. She believes that companies which can organize and deploy their data to frame strategies are going to have a competitive edge over others. Her interest areas include Microsoft SQL Server and overall Database Management. Apart from her work, Chetna enjoys spending time with her friends, painting, gardening, playing the violin, and spending time with her son.

Newsletter Signup! Join 15,000+ Professionals




Be Social! Like & Follow Us...

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Recent SQL Server Tips