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

66 responses to “FIX: Error Code 29506, While installing SQL Management Studio Express on Windows Vista x64”

  1. sj Avatar
    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… :)

  2. Paul Avatar
    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

  3. Ranga Avatar
    Ranga

    tks a lot………………..

  4. Jim Bucko Avatar
    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

  5. fbihack Avatar
    fbihack

    My goodness what a stupid win bug…

    however, works great on Windows 7 Ultimate x64.

    Thanks mate

  6. Ivo Rafael Avatar
    Ivo Rafael

    Workssss! Thanks a LOT!

    Using Windows 7 x64, Works very fine!

  7. Sunil Avatar
    Sunil

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

    1. Dale Avatar
      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.

  8. tompatam Avatar
    tompatam

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

  9. Paul Avatar
    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.

  10. Juraj Avatar
    Juraj

    Thanks, worked great

Leave a Reply

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