slimCODE

commUNITY
Welcome to slimCODE Sign in | Join | Help
in Search

slimCODE, aka Martin Plante

Fixing error code 29506 when trying to install SQL Management Studio Express

Like many others, I was getting an error code 29506 when trying to install SQL Server Management Studio Express 2005 on my Vista x64 machine. Searching for a fix kept sending me to posts talking about running the MSI as administrator from the beginning, but this didn't solve it for me, neither did it solve it for many other commenters out there.

The good news is, I did find a solution! And I bet that if you end up reading this post because of a similar error, we have something in common: we downloaded the MSI using Internet Explorer 7 (or 8)! The file gets stamped as "coming from the net", thus has restricted privileges, even when running it as administrator.

Simply right-click the file and select "Properties". At the bottom of the "General" tab, you should see a security message with an "Unblock" button:

image

Pressing that "Unblock" button will remove metadata associated with that file. Running the MSI again should now work fine, even without running it from an administrator prompt, but I did ran it from an admin prompt just to make sure.

Update: As many commenters mentioned, you still need to execute the MSI from an admin command prompt.

Hope this helps!

Published Friday, January 30, 2009 6:15 PM by slimcode
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Pepper said:

Great!!! Thank you very very much!!!!

February 13, 2009 3:05 AM
 

Jury said:

You must use administrative priveleges even if you've already unblocked the installer. Otherwise you will receive the same error message.

So you was right when ran it from and admin prompt.

April 12, 2009 11:25 AM
 

Galal said:

Great man, it works but u still have to run it from admin prompt

May 16, 2009 6:40 AM
 

Vinney said:

Thanks a bunch. Although, as Jury said, I also had to run the installation from the admin prompt.

June 2, 2009 1:00 PM
 

Ravndal said:

Great info. I miss a error directory with solutions for microsofts error codes.

June 16, 2009 4:04 AM
 

George said:

It only works from the admin prompt

June 23, 2009 10:22 AM
 

Aaron Holesgrove said:

Thanks heaps dude! Good to see someone can explain a fix simply and straight forwardly.

June 25, 2009 8:59 PM
 

Oscar said:

Elemental, Dr. Watson! But I unknown it! Thanks.

July 6, 2009 8:13 PM
 

Jim said:

Thanks mate! You saved me a lot of time trying to hunt this one down.

July 16, 2009 10:57 PM
 

Robert said:

Worked perfectly! Thank you very much!

July 26, 2009 11:46 AM
 

Adan said:

Thanks! work very well! ;)

July 27, 2009 1:06 PM
 

Patrick said:

If you are running vista64, open up the command prompt as an administrator and launch the MSI from the there.

September 10, 2009 12:55 PM
 

Michael T said:

You guys rock!  Run As Administrator together with the unblock did the trick.  Insane

September 23, 2009 12:36 AM
 

vijay bony said:

thank you dear

October 2, 2009 1:05 AM
 

Shrenik said:

Thanks, Also you can press Shift key and Right Click and Select Run as Administrator... That is also working for me on Windows 7

October 28, 2009 12:51 PM
 

govdev said:

Thanks for saving me even more time than I'd already spent with this!

January 29, 2010 6:12 PM
 

Clueless said:

Thank you! Thank you!  I also had to turn off user account control.  Maybe thats a da, but it took me a minute to figure that out.  Thanks again!

March 3, 2010 8:26 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit