I was trying to install Microsoft SQL Server Express onto a Windows 7 machine today and when I got to installing the Microsoft SQL Server Management Studio Express package I kept being prompted with the following error message:
After trying to download the package again and installing with the same result, I discovered that this error is actually due to Windows 7 (and Vista) having User Account Control, or UAC. What we need to do is to install it as administrator and the easiest way to do this is as follows:
1. Goto Start Menu >> Accessories >> All Programs
2. Right-Click the Command Prompt ans select ‘Run as Administrator.
3. Accept the UAC warning which comes up.
4. Go to your downloads folder (eg. cd \users\admin\downloads)
5. Run ‘SQLServer2005_SSMSEE_x64.msi’ and the installation will complete as normal
0 Responses to “Error 29506 From MSSQL Management Studio Express”
Leave a Reply