Install Windows PowerShell for SQL 2008 R2

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:

After some additional searching, I found the homepage for Windows PowerShell. You should be able to find everything you need there.

You can also get Windows PowerShell 2.0 included with Windows Management Framework here:





21 responses to “Install Windows PowerShell for SQL 2008 R2”

  1. Aaron Avatar

    Been looking for this forever! Thanks!

    1. this is me Avatar
      this is me

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

  2. Strunzo Avatar

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

    1. Jason Green Avatar

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

    2. SteveB Avatar

      Did this guy even read the post?

  3. sayed Avatar

    Thanks for ur Quick links………….. 🙂

  4. Janice Avatar

    Found this. Thought should share with all.

    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.

  5. kashtro Avatar

    thanks.helpful information .

  6. Rman Avatar

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

  7. Kaushal Avatar

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

  8. Raman Avatar


  9. Kunle Ade Avatar
    Kunle Ade

    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 🙂

    1. Jason Green Avatar

      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.

  10. Richard Avatar

    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!

  11. Anand Avatar

    Thank you very much.

  12. bassam Avatar

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

  13. ahmdsyd Avatar

    Thank you very much.

  14. sravan Avatar

    thanks for the helped me a lot

  15. daksh Avatar

    you save my hours . . .thank you

  16. […] you are looking for detailed instructions to help you install windows powershell for SQL 2008 R2, check out the page below for all of the downloads and details. […]

Leave a Reply to sravan Cancel reply

Your email address will not be published. Required fields are marked *