SQL SERVER – Fix: Error: File cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details

Yesterday I formatted my computer and did fresh install as it was due from long time. After the fresh install when I tried to install Semantic Search application using powershell, I was stopped by following error.

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

Fix/Solution/Workaround:

The solution is very simple. Open the Powershell window and type following two lines and everything will fine right after that.

Set-ExecutionPolicy Unrestricted
Set-ExecutionPolicy RemoteSigned

Again, this is I have done for my environment where I am very careful what I will run. You can change the policy back to original restricted policy if you want to restrict future execution of the powershell scripts.

Simple – isn’t it? Well all complex looking problems are very simple to solve.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

7 thoughts on “SQL SERVER – Fix: Error: File cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details

  1. I think, by executing the command “Set-ExecutionPolicy Unrestricted”, we can execute all the required powershell commands.

    Sir, is it mandate to run both the commands?

  2. Hey Dave, Your blog is awesome. :)
    For running scripts in powershell you only need one of the set-executionpolicy statements. Running the second one overwrites the first.
    Try:
    set-executionpolicy unrestricted
    get-executionpolicy
    set-exectuionpolicy remotesigned
    get-executionpolicy
    set-executionpolicy restricted
    get-executionpolicy
    you will see they overwrite.

    Both will work to run scripts.
    set-executionpolicy unrestricted will allow all to run
    set-exectuionpolicy remotesigned will allow all local scripts to run but require remote scripts to be signed.
    set-exectuionpoliciy restricted allows none.

  3. Hi ,
    I am running some code for this in ASP.net and facing same error as above . but same code is running and executing powershell from windows (winform) application .

    Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s