Bulletin 16
   compleat botanica    troubleshooting    Bulletins   




   Windows Installer
   Internet Explorer
   Installation hangs
   Dual-boot option
   Slammer virus
   Checklist corrections
   Server Service
   Desktop Engine versions
   Multi-res printers
   Long printer names
   Specimen reports


Technical Bulletins # 16 back ] Next ]

Installation of Microsoft SQL Server Desktop Edition
fails due to Registry security.


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




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.


Last reviewed January 28, 2006