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
Posted
by pinaldave
on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Wed, 30 Nov 2011 01:30:17 +0000
Indexed on
2011/11/30
10:11 UTC
Read the original article
Hit count: 877
Pinal Dave
|PostADay
|sql
|SQL Authority
|SQL Error Messages
|SQL Query
|SQL Scripts
|SQL Server
|SQL Tips and Tricks
|T SQL
|Technology
|powershell
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)
Filed under: Pinal Dave, PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology Tagged: Powershell
© SQL Authority or respective owner
