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.
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.
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.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349
The above error indicates that the WMI repository might be inconsistent so to resolve the error we need to fire the following command
WMI repository is INCONSISTENT
If the output shows that WMI repository is INCONSISTENT we need to fire the following command to salvage the repository
WMI repository salvage failed
Error code: 0x8007041B
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
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.
SE, Microsoft SQL Server
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?