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:

Run CMD as Administrator and Approve the UAC prompt and type the full absolute path of the MSI file, Such as:

C:\>E:\Downloads\SSMS_x64.msi

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”

sj

2010-04-07

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… :)

Reply
Paul

2010-04-06

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

Reply
Ranga

2010-03-21

tks a lot………………..

Reply
Jim Bucko

2010-02-11

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

Reply
fbihack

2010-02-09

My goodness what a stupid win bug…

however, works great on Windows 7 Ultimate x64.

Thanks mate

Reply
Ivo Rafael

2010-01-31

Workssss! Thanks a LOT!

Using Windows 7 x64, Works very fine!

Reply
Sunil

2009-10-22

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

Reply
1. Dale
  
  2009-11-09
  
  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

2009-09-07

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

Reply
Paul

2009-08-26

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.

Reply
Juraj

2009-08-20

Thanks, worked great

Reply