I was recently looking for an easy way to run queries and scripts against a hosted SQL Server database without having to come out of pocket and happened upon Microsoft SQL Server Management Studio Express. While I have been fully aware of the Express tools (C#, VB.NET, C++) I had no knowledge of a SQL Management Express.
Unfortunately part way through the installation I was faced with this message:
“The installed has encountered and unexpected error installing this package. This may indicate a problem with this package. The error code is 29506.”
Now the laptop I was using has 64bit version of Windows 7, and this is what I believe to be the cause of the issue. My brief research did not really find issues with Vista. In response I attempted to install the msi as an administrator and that seemed to do the trick. You can run any msi as an administrator from a command prompt as follows: