Installation of Microsoft SQL Server Desktop Edition fails due to Registry security.
Symptoms
Attempts to install Microsoft SQL Server 2000 Desktop Edition fail due to insufficient
security access permissions in the Registry. This happens even if the user is logged in as Administrator during
the installation.
The installation progress indicator moves forward to the point of failure, then
begins to move backward as the installation is rolled back. An inspection of
the installation log file reveals that setup is failing during its process at:
Starting custom action DisableNetAccess().
During the installation a log file is written to
"C:\Program Files\Compleat Botanica\DesktopEngine\Setup\CBDestopEngine.log".
An inspection of the log reveals lines similar to this:
Starting custom action DisableNetAccess()
Error : unable to disable network access to MSDE.
Ending custom action DisableNetAccess()
Action ended 0:15:35: InstallFinalize. Return value 3.
Action 0:15:35: Rollback. Rolling back action:
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Writing system registry values
This problem is briefly described in Microsoft article 901163
Resolution
You can solve this problem by modifying the Registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
and giving "Full Control" privileges to the "Administrators" and the "SYSTEM" identities.
Step-by-step instructions for modifying the Registry are provided below.
Versions affected
Operating system
Problem first identified
Problem fixed
Windows NT
NA
NA
Windows 2000
Build 89
NA
Windows XP
NA
NA
Instructions for modifying the security settings in the Registry for
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
1
Open the Registry. From the Start menu select Run... then type in "regedt32".
2
Select the window with the heading HKEY_LOCAL_MACHINE. Then open the key "SOFTWARE", and the subkey "Microsoft", and finally the subkey "Microsoft SQL Server".
3
From the menu choose "Security" then "Permissions".
4
Select the "Administrators" identity from the list. Set the permissions for Administrators to "Full Control".
5
Do the same for the "SYSTEM" identity. Set the permissions for SYSTEM to "Full Control".
Now begin the installation of SQL Server Desktop Engine again.
