Bulletin 11

	Bulletin 11
	compleat botanica troubleshooting Bulletins

Technical Bulletins # 11 [ back ] [ Next ]

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

Symptoms

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".

Resolution

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.

From the Start menu select Settings > Control Panel.

From the Control Panel double-click the Administrative Tools icon.

From the Administrative Tools folder double-click the Services icon.

Scroll down the alphabetical list of services and double-click the Server item.

From the Server Properties window click the Start button.

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.

From the Start menu select Settings > Network and Dialup connections.

From the Network and Dialup Connections folder right click on "Local Area Connection".

From the popup menu select the "Properties" item.

From the Local Area Connection Properties dialog box click the Install button.

From the Select Network Component Type dialog box choose the "Service" item in the listbox and click the Add button.

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.

Restart your computer.

Last reviewed January 28, 2006