Microsoft KB Archive/269852

= Troubleshooting the Error Message &quot;The Following Account(s) Must Be Provided&quot; During BackOffice 4.5 Setup =

Article ID: 269852

Article Last Modified on 2/26/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2000 Standard Edition
 * Microsoft BackOffice Server 4.5

-



This article was previously published under Q269852



SUMMARY
When you run BackOffice 4.5 Setup to add or remove BackOffice components, you may receive the following error message:

The following account(s) must be provided:

-

Where  is &quot;Primary Site System Administrator Account&quot; or &quot;BackOffice Suite Components System Administrator Account.&quot;

Each of these accounts uses the internal SQL Server SA account for authentication. When you click the Assign Account(s) button, the resulting dialog makes the Account Name field unavailable.



MORE INFORMATION
This error message is typically caused by either an incorrect password entered in the wizard's dialog box, or by a failure of the MSSQLServer service to start. Several different BackOffice components rely on the correct installation and configuration of Microsoft SQL Server 7.0, including Microsoft SNA Server 4.0, Microsoft Systems Management Server 2.0, and the Microsoft BackOffice Suite Components 4.5. When you select any of these options in the BackOffice Server Programs and Their Components section of BackOffice 4.5 Setup, the wizard tries to verify that the SA account can log on to the SQL Server. If the wizard cannot access the SQL Server, the wizard will prevent Setup from continuing to avoid errors with the installation of the selected BackOffice components.

Verify That SQL Is Installed Correctly

 * 1) To open the SQL Service Manager click Start, click Programs, click Microsoft SQL Server 7.0, and then click Service Manager.
 * 2) Select your server from the Server list, and then click MSSQLServer from the Services list.
 * 3) If the MSSQLServer Service is not started, then click Start/Continue to start the service.

If the service does not start, open the Windows Event Viewer system and program logs to look for, and to correct any errors that you may find before proceeding with Setup. In some cases, especially in new installations, the fastest resolution may be to remove SQL, and then to rerun the BackOffice Setup. See the section titled &quot;Remove SQL Manually&quot; below for more details.

Verify That the MSSQLServer Service Is Not Disabled

 * 1) Click Start, point to Settings, click Control Panel, and then double-click Services.
 * 2) Locate MSSQLServer from the list of services; click once, and then click Startup.
 * 3) Verify that the service has a Startup Type of either Automatic or Manual. If the entry is set to Disabled, change Startup Type to Manual.
 * 4) Click OK, and then click Close.
 * 5) Rerun BackOffice Setup.

Change the SA Account Password in SQL Enterprise Manager
If the service starts correctly, but you still receive the &quot;following account(s) must be provided&quot; error message, follow these steps to change the service account password:
 * 1) To open the SQL Enterprise manager: click Start, click Programs, click Microsoft SQL Server 7.0, and then click Enterprise Manager.
 * 2) Open the Security object, (this is located below your server), and then click Logins.
 * 3) Double-click the SA entry to access its properties.
 * 4) Type the password you want to use for the SA account next to Password on the General tab. Click OK to save the settings, and to close the dialog.
 * 5) Rerun BackOffice Setup.

Remove SQL Manually
If all other troubleshooting methods fail, you may want to remove SQL Server. Before performing this procedure, back up any existing SQL data, including configuration settings. A full system backup is also a good idea.  Close all open programs, and insert the second CD-ROM of the BackOffice 4.5 set. Run the command

CDROM:\sql70\sql70rem.bat path

where CDROM is the drive letter of your CDROM and path is the complete path of the directory on which SQL Server 7.0 is installed. By default, this is C:\mssql7. Rerun BackOffice Setup to reinstall SQL 7.0.

NOTE: After you remove SQL Server 7.0, see the Microsoft Knowledge Base article that is described in the &quot;References&quot; section of this article, Q225393, to fix a potential issue with the Content Index service.

