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. Rameshwar Avatar
    Rameshwar

    It works…. great work….
    thanks a ton

  2. Ed Avatar
    Ed

    Dude, you are my personal hero!

  3. Millenium Avatar
    Millenium

    Working! Thanks!

  4. Said Avatar
    Said

    Thanks, it works

  5. Luis Avatar
    Luis

    Thank you dude!, it worked

  6. Ben Avatar
    Ben

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

  7. AVP Avatar
    AVP

    Thank you
    Worked on Windows 2008 R2 server

  8. Mike Avatar
    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.

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

  9. Alejo Avatar
    Alejo

    That fixed it. Much love.

  10. tran Avatar
    tran

    thanks

Leave a Reply

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