Installation of SQL Server Express Edition on Windows Vista while Installing Microsoft Office Accounting 2008
There have been a number of instances where the installation of the sql express edition on Windows Vista which also gets installed along with Microsoft Office Accounting 2008 fails which ultimately causes the installation of the Office Accounting 2008 on Windows Vista to fail.
So in order to successfully install Sql Express Edition on Windows Vista we need to take the following precautions before starting the installation so as to ensure that successful install of Sql Express On Windows Vista
1. Disable User Access Control(UAC) Feature of the Windows Vista
User Account Control (UAC) is a new security feature in Windows Vista that requires all users to log on and run in standard user privileges mode instead of as administrator with full administrative rights, thus prevent unauthorized or accidental changes that could destabilize the computers or allows virus and malware to exploit the system-level privileges provided to the local administrator to attack the network security, compromise computer safety and privacy, and damage files and settings in the network. However, in a lot of cases, administrator rights are needed by end-users to perform certain tasks such as install or update programs and perform typical system-level task. Beside, many software applications also need administrator privileges to run properly without conflicts, as they are designed to write to system locations during normal operation, and computer in locked-down state in which users operate in standard user mode severely limits user productivity.
- In order to disable UAC we need to follow the following steps
- Click Start and then open Control Panel.
- In the Control Panel, click User Accounts and Family Safety.
- Click User Accounts.
- Click Turn User Account Control on or off.
- Clear the tick or check mark on the box beside the Use User Account Control (UAC) to help protect your computer option.
- Click OK.
- When prompted, restart the computer. Note that the changes will affect all users on the computer.
- To enable the UAC, simply tick or select the checkbox again.
2. Disable all the Non-Microsoft Services
There are certain services which can prevent or hinder in the installation of the SQL Server on Windows system. Some of these services which are observed to cause problems while installation of the SQL Server are Antivirus, Malware and even Citrix Virtual Memory Optimization service. So in order to prevent any third party service from the installation of the sql server we would preferably disable all the Non-Microsoft services which can re enabled after the installation
In order to disable the Non-Microsoft services.
- Go to Start->Run->type msconfig
- Click on the services tab in the Dialog box
- Click the check box Hide all Microsoft Services
- Click On Disable ALL
- Click On Ok
- We now need to restart the system for the changes to take effect
3. Check whether WMI repository is INCONSISTENT
If during the installation of the sql server on Windows vista fails with the following error
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
The above error indicates that the WMI repository might be inconsistent so to resolve the error we need to fire the following command
C:\Users\Owner>winmgmt /verifyrepository
WMI repository is INCONSISTENT
If the output shows that WMI repository is INCONSISTENT we need to fire the following command to salvage the repository
C:\Users\Owner>winmgmt /salvagerepository
WMI repository salvage failed
Error code: 0x8007041B
Facility: Win32
Description: A stop control has been sent to a service that other running services are dependent on.
It may throw the following error when you fire the above command for the first time so run the command again as shown
C:\Users\Owner>winmgmt /salvagerepository
WMI repository has been salvaged
Once the above precaution is being taken we can start with the installation of the sql server express and it should go fine.
If still the error occurs while installation we might have to troubleshoot further by looking at the setup bootstrap logs. But precaution can be helpful in the installation of the SQL Server Express Edition on Windows Vista.
Parikshit Savjani
SE, Microsoft SQL Server
Comments
- Anonymous
June 11, 2014
What are upgrade possibilities if the SQL Server 2005 Express which underpins Office Accounting 2008 reaches its database limit, 4GB? Otherwise, whar tables can be safely purged of all records to gain space?