I was trying to install SQL Server 2005 Management Studio Express on my home Vista 64 system at the weekend, and came across the following Error.
This is due to the new Vista feature called User Account Control or UAC. there are 2 different ways of fixing 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 do that if I was you.