FIX: Error Code 29506, While installing SQL Management Studio Express on Windows Vista x64

Yesterday I have tried to install SQL Management Studio Express on Vista Business x64. But An error code 29506 encountered and installation failed and roll-back.

I have observed that most of apps based on MSI (.msi) encountered in Windows Vista, when UAC enabled. The main problem with MSI files is that you cannot right click it and “Run as Administrator” to bypass UAC validation. To solve this problem, Either you have to logged-in as Default Administrator account or disable UAC.

MSSQL_MSE_Error29506

But don’t worry, There is another way to install SQL Management Studio Express on Windows Vista x64 flawlessly.

How To:

  1. Run CMD as Administrator and Approve the UAC prompt and type the full absolute path of the MSI file, Such as:
  2. C:\>E:\Downloads\SSMS_x64.msi

  3. Follow your screen instruction and be happy with Windows Computing.

Applies To:

  • Windows Vista x64 editions
  • Windows 7 x64 editions
  • Derek Hansell

    It’s always distressing to me that I have to come to random tech sites to figure out how to make M$’s software work.

    Thanks, though! Worked like a charm!

  • lbytesxk

    Thanks for the help, funny thing is I already installed this on this same computer without any problems but I i had to uninstall it at one point.

  • Sudha

    Thank u so much it worked out:-) Wow…

  • Randy

    Worked for me on Windows8… but I don’t understand why I had to run cmd as adminstrator.. I’m alread using an administrator accoutn… thanks anyway.. couldn’t have done this without you.

  • http://www.facebook.com/brentamcdonald Brent McDonald

    to run command promt as administrator in Win 7, click on the window key, type CMD (dont press enter) press Ctrl+shift+enter and wala…..

  • EquilibriuM KalOnline Team

    Thanks :) !

  • http://www.facebook.com/hskn2006 Hassan Khan Raja

    Awesome
    man it works thnks

  • ashish

    thats great, its work, thanks,

  • Charley

    Worked for me on 2008R2 Server. Thank you!

  • neha

    it didn’t worked for me….still got the same error….:(

    • http://www.windowsvalley.com Ramesh Kumar

      Did you run Command Prompt as Administrator?

  • Jeer65

    Awesome I was trying to run like administrator and didn’t work, just when I followed your instruction with the CMD works perfectlly

  • Noah

    Worked for me though I had to type start  *******.msi at the command prompt in windows 2008r2

  • Charlie

    Thats great. In win 7 goto start->programs->accessories and right click on cmd and run as administrator

  • Priyanka

    hey! thnx! dat worked ..:)

  • Patti

    Didn’t work for me. I still got the error.

  • Wilson

    Heey,

    So this has not worked for me, any more ideas??

  • ghyfer

    Thanx.. that’s work for me too.. :)

  • http://www.activeitmedia.com Besim BarQasho

    Thanx man.
    Absolutly perfect.

    Be like water my friend…..

  • Elad

    Worked! Thanks, I felt doomed when I got the error…

  • James

    Always wondered how to run as admin when the option wasn’t available by right clicking on the exe file. Thanks, it worked perfectly!

  • jrfrago

    That worked. Thanks.

    • blake

      that worked thanks!

  • Rashid Aliyev

    Always run such servises by administrative account.

  • Asaf Meller

    remember to run cmd as admin->
    write cmd and press cntrl+shift++enter

  • Mohammed Gad

    wow it’s work for me ^^ thank you very much for help

  • Sivakumar

    Thanks, it worked for me too, i tried with Windows 7 Home Premium x64

  • Bytegrafix

    it doesn’t work for me i did the same way as mentioned still i got same error.
    i used windows 7 ultimate 64 bit

  • Melihri

    Thanks, That worked for me too.

  • Cookieborjaredublo

    the directory name is invalid.:( i can’t install my sql server management studio using cmd also

  • Ahmed

    so thnks.
    its work with me

  • radical

    it worked!!! Thanks! :)

  • louis

    works perfectly!
    **Note: im using windows server 2008 r2

  • pupu

    thank you very much !!!!

  • Pankaj

    wow.. thanx paul.. it worked for me as well…

  • Vadim

    TNX !

  • Khaternakid

    Great….Worked for me…. (Win 7 user)

  • Mike

    Amazing, hehe.

  • Steve Davis

    Worked great – Thanks

  • Brent

    Worked for me too. Thanks a ton!

  • Thomas

    +1

  • Dino

    Perfect!
    It really works!

    Thanx a lot!

  • Clay Vernon

    Thanks, it worked perfectly!

  • Rameshwar

    It works…. great work….
    thanks a ton

  • Ed

    Dude, you are my personal hero!

  • http://aliyev.us/ Millenium

    Working! Thanks!

  • Said

    Thanks, it works

  • Luis

    Thank you dude!, it worked

  • Ben

    Thanks works on Windows 7 Pro x64 (iMac 27″)

  • AVP

    Thank you
    Worked on Windows 2008 R2 server

  • Mike

    If you are trying to install the x64 version of Management Studio you also need to run an elevated x64 cmd.

    in the search bar type c:\windows\syswow64\cmd – right click, run as administrator.

    then type the full path to the msi file.

    • http://www.windowsvalley.com Author

      Hello Mike,
      The folder SysWOW64 contains 32bit binaries to run 32bit applications using SysWOW emulater which means cmd.exe (in SysWOW64 folder) is a 32bit executable.

  • http://www.mrbluesummers.com/ Alejo

    That fixed it. Much love.

  • tran

    thanks

  • sj

    thanks a lot paul…i was facing this issue for such a long time…it finally worked for me…thanks a lot…ur post is really helpful… :)

  • Paul

    Always a pleasure! Although, the person who left the article deserves the credit as I just took their instructions and expanded it as much as possible!!

    Thanks guys
    Paul

  • Ranga

    tks a lot………………..

  • Jim Bucko

    Paul, thanks so much for your easy solution. It is the only one of a dozen on the web that works !!!
    Great job

  • fbihack

    My goodness what a stupid win bug…

    however, works great on Windows 7 Ultimate x64.

    Thanks mate

  • Ivo Rafael

    Workssss! Thanks a LOT!

    Using Windows 7 x64, Works very fine!

  • Sunil

    I folllowed what Paul told and it worked like a charm. Thanks dude.

    • Dale

      Woo Hoo! Thanks a bunch! I don’t think I’d have got it without the expanded instructions. I’m using Windows 7 Home Premium.

  • tompatam

    Worked perfect for me also!
    Thanks Paul for the expanded directions for those of us that are not only dumb but, green too.

  • Paul

    Worked perfect!

    For those who were a bit dumb like me (… ok very dumb) and took 2 mins to figure it out, fool proof expanded instructions are below.

    1)Move the installer package to the root of your hard disk which windows is installed in (c: for most of us)
    2)Single left and click on the installer
    3)Press “F2″ and rename it to “sqlinstaller” or something easy to type (maintaining the file type)
    4)Click on “start” > “All Programs” > “Accessories” > then right hand click on “Command Prompt” and click on “Run as Administrator”
    A window will appear titled “User Account Control”, saying “Do you want to allow the following program to make changes to this computer”
    5)Click “Yes”
    6) Type: “cd\” without the quotes and press enter
    7) Type in the file name you renamed the file to and add .msi to the end and hit enter. (eg “sqlinstaller.msi” without the quotes)
    Then install as per usual.

    Remember to delete the installer off the root of your drive. Its not good to be messy.

  • http://www.cogotec.com Juraj

    Thanks, worked great

  • http://www.windowsvalley.com Admin

    Type the full absolute path. If it contains spaces then double quote the path.