SQL Management Studio Express error code 29506
So I was at work today (like any other day except the weekends 
) and the first thing what I did was installing some software that I need to use for software development. One of these applications is SQL Management Studio Express. When I tried to install SQL management studio 2k5 however, I got an error code 29506 near the end of the installation process and there was no other choice than to canel the install because the SQL Management Studio Express didn’t gave me any other option than to rollback the installation so I rolled it back.
I had never encountered this issue before so i had no idea how to get around it. I even tried reinstalling a few times and even checked my user permissions a few times although I logged in as an admin. Lucky for me there’s a site called google.com so i searched for “SQL Management Studio Express error code 29506″, “SQLServer2005_SSMSEE error code 29506″ and more variations like that and found the solution here.
To make a long story short, it turned out i had to click the “unblock” button to be able to install SQL server 2005 because Windows 7 thought the file might be harmful. *rant* Typically Microsoft, i don’t want you guys to decide what software I want to install, when I want to install an application I really DO want to INSTALL it Period. */rant*
Anyway, here’s the fix: “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:”
