Bulletin 11
   compleat botanica    troubleshooting    Bulletins   




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


Technical Bulletins # 11 back ] Next ]

Cannot install Microsoft SQL Server Desktop Edition if Server Service is not running.


Attempts to install Microsoft SQL Server 2000 Desktop Edition fail. An inspection of the installation log file reveals that the point of failure is during the attempt to start InstallSQLAgentSecurity.

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:
   Loading extended custom action library sqlcax.dll
   Starting custom action InstallSQLAgentSecurity
   InstallSQLAgentSecurity failed (YourComputerName,LocalSystem,87).
   Action ended 22:41:16: InstallFinalize. Return value 3.

Details of this problem are available from Microsoft at: Microsoft Knowledge Base Article - 829386 "You Cannot Install MSDE 2000 if the Server Service Is Not Running".



You can solve this problem by installing File and Printer Sharing for Microsoft Networks and starting the Server Service.

Step-by-step instructions for starting the Server Service are provided below. If you can't find the Server Service in Step 4 (below), you'll need to install File and Printer Sharing for Microsoft Networks using the step-by-step procedures at the end of this document.

After finishing this, restart the installation of the Compleat Botanica beginning with STEP1 of the CD's Setup program.


Versions affected
Operating system Problem first identified Problem fixed
Windows NT NA NA
Windows 2000 Build 85 NA
Windows XP Build 86 NA


Instructions for Starting the Server Service

If the Server Service is installed but not running, follow these instructions for starting it.

1 From the Start menu select Settings > Control Panel.
2 From the Control Panel double-click the Administrative Tools icon.
3 From the Administrative Tools folder double-click the Services icon.
4 Scroll down the alphabetical list of services and double-click the Server item.
5 From the Server Properties window click the Start button.
6 After the server service has started you can proceed with installing Microsoft SQL Server Desktop Engine.


Instructions for Installing File and Printer Sharing

If the Server Service is not in the list of services (see Step 4 above), you'll need to install it by installing File and Printer Sharing. Follow these instructions for installation.

1 From the Start menu select Settings > Network and Dialup connections.
2 From the Network and Dialup Connections folder right click on "Local Area Connection".
3 From the popup menu select the "Properties" item.
4 From the Local Area Connection Properties dialog box click the Install button.
5 From the Select Network Component Type dialog box choose the "Service" item in the listbox and click the Add button.
6 From the Select Network Service dialog box select the "File and Printer Sharing for Microsoft Networks" item in the listbox and click the OK button.
7 Restart your computer.

Last reviewed January 28, 2006