SQL Server 2005 Management Studio Express on Windows Server 2008 Fails

I was building an OCS R2 Standard Edition Server on Windows Server 2008 x64 and wanted to install the SQL Server 2005 Management Studio Express Tools so that I could run some sql backup scripts when I encountered an installation error.  At first I thought it was an incompatibility issue but quickly dismissed that since OCS R2 still uses SQL Express 2005 as the database engine. 

The installation would go fine until the very end and then I’d the the following error:

“The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506”

 

 

After clicking OK, the installation roles back :-( 

So a few head scratches later I realize that when running the setup I wasn’t prompted for elevated credentials to be able to install as the Protected Administrator (PA) account since I was running User Account Control (UAC) on my server. 

After launching a DOS prompt using the “Run as Administrator” option and then subsequently running the  SQLServer2005_SSMSEE_x64.msi the install worked fine! 

Microsoft is taking big strides in forcing developers to write applications that will install as a standard user account, however since this is an older application it clearly thought it had enough administrative permissions to install correctly as I was logged on as a local admin. 

Comments

[Audibert]

Hi,

I just had this issue and your solution run fine for me

Thanks a lot

[Scott]

I have no issues when installing Microsoft SQL Server Management Studio Express Service Pack 3 (http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=5D76230D-580D-4874-8C7D-93491A29DB15&displaylang=en), which is officially supported by Microsoft when installed on Windows Server 2008.

[Morten]

super, that helped me too :)

thanks

[buy viagra]

Installation error with Microsoft .NET in Windows Update and manual update.?
I uninstalled the Microsoft .Net programs on my computer (Windows Vista Home Premium SP2, 32-bit) because I saw multiple installations (3.5 and 2.0), and I thought it would be a good idea to get rid of both and just reinstall the latest version, 3.5.

[generic avandia]

I uninstalled the Microsoft .Net programs on my computer (Windows Vista Home Premium SP2, 32-bit) because I saw multiple installations (3.5 and 2.0), and I thought it would be a good idea to get rid of both and just reinstall the latest version, 3.5.