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

By on July 1, 2009 51

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

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

Applies To:

  • Windows Vista x64 editions
  • Windows 7 x64 editions

Associated terms:
error code 29506, the error code is 29506, 29506 error code, error code 29506 sql management studio express, error code is 29506, error code 29506 sql management studio, error code 29506 sql, 29506 sql management studio, sql error code 29506, sql server management studio express error code 29506, code 29506, error code 29506 windows 7, 29506 error, microsoft sql server management studio express error code 29506, 29506 windows 7, 29506, 29506 sql express, installer error code 29506, error code is 29506 sql management studio, sql management 29506

Newer Comments →
  • 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.

Newer Comments →