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
- by pinaldave
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