while installing sql server 2005 management studio express in vista operating system, we may face an error. Here is the solution given,
This is due to the new Vista feature called User Account Control or UAC. The fix is pretty simple and there are 2 different ways of implementing it.
1. Under ‘Accessories’ from ‘All Programs’, right-click the Command Prompt shortcut and select ‘Run as Administrator’. Accept the UAC warning when prompted.
2. From the command prompt change to the directory that holds the SSMSEE installation .MSI file.
3. Enter the command .\SQLServer2005_SSMSEE_x64.msi if you’re running Vista x64 (64-bit) or .\SQLServer2005_SSMSEE.msi if you’re running Vista x86 (32-bit)
4. Press enter and complete the installation as normal.
The second method is to disable UAC completely but I wouldn’t recommend it.
Thanks to this post:
http://digitalformula.net/databases/error-29506-when-installing-sql-server-2005-management-studio-express-on-vista/