Install Windows PowerShell for SQL 2008 R2

by Jason Green on January 3, 2011 · 21 comments

I was recently installing SQL Server Management Studio Express 2008 R2 and the installation failed temporarily because Windows PowerShell wasn’t installed. There wasn’t a link, so I thought a quick search would get me the file on Microsoft’s website. I was wrong. I found plenty of documentation and getting started guides for Windows PowerShell, but no installation downloads.

It was frustrating, but I finally found the PowerShell installation file. I thought I’d share the link here to help everyone find this file a little faster. (And so I can find it easily in the future.)

If the links below don’t work, you should have enough detail here to refine and shorten your search.

Windows PowerShell 1.0 English Language Installation Packages for Windows Server 2003 and for Windows XP

Microsoft KB Article / Location of PowerShell Downloads: http://support.microsoft.com/?kbid=926139

After some additional searching, I found the homepage for Windows PowerShell. You should be able to find everything you need there.
http://technet.microsoft.com/en-us/scriptcenter/dd742419.aspx

You can also get Windows PowerShell 2.0 included with Windows Management Framework here:
http://support.microsoft.com/kb/968929

{ 20 comments… read them below or add one }

Aaron January 5, 2011 at 9:54 pm

Been looking for this forever! Thanks!

Reply

this is me November 29, 2012 at 12:13 am

then during 2008 sql server R2 installation
after the powershell
I got stuck because it need 2005 sql server express tools – fuck it

Reply

Strunzo May 22, 2011 at 1:53 am

Powershell is an installable feature from 2008 OS … duh!!!

Reply

Jason Green May 23, 2011 at 11:14 am

Thanks, but this post is mostly for people installing on an OS that doesn’t ship with powershell installed.

Reply

SteveB November 14, 2011 at 12:02 pm

Did this guy even read the post?

Reply

sayed June 30, 2011 at 2:07 am

Thanks for ur Quick links………….. :)

Reply

Janice August 10, 2011 at 9:20 am

Found this. Thought should share with all.

http://support.microsoft.com/kb/928439

Scroll downwards and you will be able to find window powershell 1.0. It was recommended in my text to download the WindowsXP-KB926139-v2-x86-ENU.exe.

Reply

Janice August 10, 2011 at 9:23 am
kashtro August 14, 2011 at 10:43 am

thanks.helpful information .

Reply

Rman September 11, 2011 at 9:44 am

thanks man.was in trouble finding it.you are a god!!!

Reply

Kaushal January 29, 2012 at 4:31 am

huff, Finally i found PowerShell from different source… still Thanks a lot. You guys show me the real path to get it.

Reply

Raman February 12, 2012 at 10:01 am

thanks

Reply

Kunle Ade February 17, 2012 at 9:42 pm

Thanks very much for providing the link for the exact Windows Powershell download for SQL 2008 R2 that worked on my Windows XP. If I had found your link first, would have saved me hours of futile surfing!

Cheers again :-)

Reply

Jason Green July 6, 2012 at 10:04 am

Thank you! To help other people find this page more easily, you could share this link on your website, or on facebook/twitter/google+ etc… More links = more visibility.

If you found this post helpful, providing a link is a great way to thank me and will help more people find it in the future.

Reply

Richard July 3, 2012 at 1:54 am

Thanks for sharing this – I was about to set off on the search for PowerShell installations on the Microsoft site, but I guess you’ve saved me some time!

Reply

Anand July 25, 2012 at 3:18 am

Thank you very much.

Reply

bassam July 26, 2012 at 8:25 am

please i cant found this , when i goto page it said sorry cant found or ask me for validating code plz help me

Reply

ahmdsyd September 17, 2012 at 7:22 am

Thank you very much.

Reply

sravan September 20, 2012 at 11:08 am

thanks for the info.it helped me a lot

Reply

daksh February 26, 2013 at 4:09 am

you save my hours . . .thank you

Reply

Leave a Comment

{ 1 trackback }

Previous post:

Next post: