After I have gotten my SQL Server installed, I decided the next step in building out the environment was to add some local users with different permissions for services and testing.
Instead of going through and manually clicking to add each of these new users, I decided why not learn a little more PowerShell. So the first thing I did was go to the ‘start globe’ (I know it is not the start menu, but the official/proper name escapes me plus I like the sound of ‘start globe’) and entered ‘PowerShell ISE’ in the search bar…..a few second later nothing, no results.
Since I was more concerned with developing, I went out and downloaded PowerGUI (http://powergui.org). Well, I have returned to the issue really wanting to use the built in ISE that is provided, so with some better googling I found an article on TechNet (http://technet.microsoft.com/en-us/library/dd759217.aspx) which provides an overview of the ISE for Window Server 2008 R2.
The article reviews what the PowerShell ISE is and why it is beneficial for both beginners and advance users. One of the last sentences contains the missing information I was looking for…" Windows PowerShell ISE is an optional feature." Now, I know why I couldn’t find it!!
So to get the ISE for use, the steps are simple and straight forward.
1. Open Server Manager
2. In the left-hand navigation tree select Features
3. Next click Add Features. This will launch the "Add Features Wizard"
4. Scroll down until you find Windows PowerShell Integrated Scripting Environment (ISE).
5. Click the check box and then click Next
6. Click Install
7. Now get up and do a few jumping-jacks to keep from getting leg clots, while the progress bar fills…..1…2…3…4…you can do 10, I have confidence in you.
8. Click Close once installation has finished.
9. A search for ISE now gives you two options
10. Now we can use the PowerShell ISE for development.
Now we can create scripts in a pretty environment, but what about running them. If you have just written a simple or for that matter complex script to perform some task, let’s say to write the all popular "Hello World!" to the screen. Your script might look like the following:
Now click the little green arrow or click F5. If your system is fresh the following error message most likely came up:
[For the search engine sake the message reads: File cannot be loaded because the execution of scripts is disabled on this system. Please see "get-help about_signing" for more details.]
Well, now this is a problem all we wanted to do was to greet the world from our machine….My understanding is that by default and for good reason PowerShell no matter what level user you are will not run a script that has not been digitally signed. You can run your PowerShell prompt as administrator and you will still get this message. It is a security feature to make sure you understand and know what you are about to run. This is great if you grandmother is about to run a script called ‘CatInTheCeiling.ps1’ because her friend told her it was the cutest thing in the world.
But for you and I, who actually want to accomplish some work on our development machine, this is a big slow down. We don’t want to spend the time trying to digitally sign a small PowerShell script.
The solution is quite simple, only a few steps:
1. Open a PowerShell command prompt or use the bottom window in the ISE.
2. Run this command: Set-ExecutionPolicy Unrestricted
3. Approve the warning
[For the search engine: The execution policy helps protect you from scripts that you do not trust.]
4. And you are done.
To reverse this setting use the Default option instead of Unrestricted.
For further details on the Set-ExecutionPolicy cmdlt check out its entry on MSDN at http://technet.microsoft.com/en-us/library/dd347628.aspx.