(Show Contents)

Installing Microsoft SQL Server Express

Microsoft SQL Server Express is included on the ARCHIBUS Web Central and Smart Client DVD. To install it:

Place the DVD in the drive. The Setup Path will start automatically.

• When the Setup Path appears, navigate to the "ARCHIBUS Setup" page and click on the Install MS SQL Server Express" link.
• Alternately, use the Windows Explorer to navigate to the microsoft-sql-server-express folder and click the wpilauncher.exe program.

When the Microsoft setup program starts, make these selections.

1. Click on the Products tab.
2. On the right side of this window (Product tab), click All. On the left side, enter SQL Server Express in the search field and press Enter.

• The list of available MS SQL Express programs will be shown. From the list, select SQL Server Express with Tools or SQL Server 2008 Express with Advanced Services.

3. Click the Add button.
4. Click the Install button.
5. On the next window, click “I Accept” the license agreement.
6. Select Mixed-mode authentication. For the SQL Server Administrator (sa) account, specify the password Archibus'1. Click Continue.
7. Installation starts.

When the installation finishes:

• Reboot after installation so that the Microsoft SQL Server Express Service (named "SQLEXPRESS") starts.
• Start the Services Manager by invoking Start/Run command and executing services.msc.
• Verify that the SQL Server Browser service is started.
• If the SQL Server Browser service is disabled, right click on the service, select Properties, set the Startup Type to Automatic, and press the Start button to start this service.

Note: Archibus'1 is the default password that the Smart Client program's Start Servers command uses when attaching local Microsoft SQL Server Express databases. If you enter a different password during installation, or establish a different password with the management interface, the Start Servers command will prompt for that password when it finds it can't attach with the default. The Start Servers command will then remember your new password during subsequent logins.