The Database Setup Wizard

Previous Topic: The Database Management Tools

The Database Setup Wizard configures the ServiceCEO database on your server computer The computer hosting the ServiceCEO database. As opposed to a "client" computer, which is a user computer connecting to the ServiceCEO database on the server computer.. If you are a new ServiceCEO user, or upgrading from using the MSDE Microsoft® Desktop Engine. The MSDE was the default database server for all versions of ServiceCEO previous to 6.1. (any ServiceCEO version 6.0 or earlier), it will install SQL Server 2005 Express, ServiceCEO's database server. It will also configure your database so that ServiceCEO clients can connect to the ServiceCEO database.

The Database Setup Wizard and Other Versions of SQL Server

Other database servers you may have been using to run ServiceCEO include:

Microsoft SQL Server Desktop Engine (MSDE Microsoft® Desktop Engine)
SQL Server 2005 Express RTM (SQL Server Express without any of the service packs)

If you are currently using one of these database servers, running the Database Setup Wizard will force you to upgrade to the newer SQL Server 2005 Express SP2.

If you are already using a full version of SQL Server (Workgroup or up), running the Database Setup Wizard is optional, depending on two factors:

If you have run ServiceCEO before. If you have already run ServiceCEO before, your database is already configured on your server computer. If you have never used ServiceCEO, you need to run the Database Setup Wizard.
If you want to use ServiceCEO's Database Backup and Restore Utility. If you want to use ServiceCEO's Database Backup and Restore Utility rather then SQL Server Management Studio (SSMS) SSMS is short for SQL Server Management Studio. For more on SSMS, please point your browser to http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en, run the Database Setup Wizard. If you use SSMS to backup and restore your databases, you do not need to run the Database Setup Wizard.

Caution:
With SQL Server 2005, Microsoft has released a new data access driver known as SQL Native Client. ServiceCEO works with the existing SQL Server ODBC Driver; it does NOT work with the SQL Native Client.

Running the Database Setup Wizard

The Database Setup Wizard can be run in two ways:

Immediately after installing the Database Management Tools.
Manually by selecting Start > All Programs > ServiceCEO > ServiceCEO Database Setup Wizard.

Regardless of how you run it, the Welcome page appears:

Click Next. The Wizard will scan your system to see if you have a previous version of SQL Server installed. Depending on what it finds, the Database Setup Wizard will perform different steps:
- MSDE via ServiceCEO. If you installed MSDE Microsoft® Desktop Engine during an earlier installation of ServiceCEO (6.0 or earlier) or have the original version of SQL Server 2005 Express (the RTM version, before any of the service packs were released), you will be upgraded to Microsoft SQL Server Express 2005 SP2. Click Next to continue.
- No SQL Server. If no version of SQL Server is installed, the Database Setup Wizard will ask you where you would like to install Microsoft SQL Server Express 2005.
  
  By default, Microsoft SQL Server Express 2005 will be installed at C:\Program Files\Microsoft SQL Server\90.
- Any other SQL Server. If you have another version of SQL Server installed - including a MSDE that was not installed by ServiceCEO, or SQL Server 2005 Express SP1 - you will be presented with the option to continue using this SQL Server or to install a new instance of Microsoft SQL Server Express 2005. (For more on named instances of SQL Server, click here.) The option that you select will be the version that ServiceCEO will use.
- Other Versions of SQL Server 2005. If you have a full version of SQL Server installed (Workgroup or up), only the ServiceCEO Database Backup and Restore Utility will be installed.

Caution:
Before you install Microsoft SQL Server Express 2005, you should be aware that it has specific operating system requirements, and also needs at least 600 MB of free space. For a complete listing of the system requirements for Microsoft SQL Server Express 2005, see Microsoft's Installation Requirements for SQL Server Express SP2 webpage.

If you choose to upgrade the ServiceCEO MSDE to Microsoft SQL Server Express 2005, the Database Setup Wizard will prompt you before you install it:

Note:
If the Database Setup Wizard installs Microsoft SQL Server Express 2005, it will be installed as a named instance.

If you have already installed at least one instance of SQL Server 2005, you will be prompted to select the SQL instance you want to use. Select the instance and click Next. The Install Database page appears; skip to step 5.

Click Next. A warning dialog box appears, informing you that you will be installing SQL Server 2005 Express.
Click Yes. Microsoft SQL Server Express 2005 will start to install. The installation will take a few minutes; please be patient. You may see a series of prompts. When completed, the Install Database page appears.

Select the name of the database you want to install. Your options are:
- Blank Database. A new, blank database.
- Demo Database. A database loaded with sample data. Note that this version can only be installed from here if you have the ServiceCEO CD.
- Use Existing ServiceCEO Database. If you already have a ServiceCEO database that you've been using, select this option.

Tip:
A wide range of demo, starter, and industry-specific databases can be downloaded from the Insight Direct member center. Click on the Training Databases link from the Member Center's home page to see what's available.

If you want to use one of the databases from the Member Center, select the Blank Database option in the Database Setup Wizard and finish running through the Wizard. Once the setup is complete, you can restore one of Member Center's databases in the usual manner.

Click Next. If you selected the Blank or Demo Database option, a warning appears, informing you that the existing database will be overwritten. Click Yes to override the existing database (if any).
If you selected Use Existing, skip to step 8.
Click OK. A complete message appears when the blank or demo database is restored.
Click OK. The Database Connection Information screen appears.

This screen displays your server configuration information. This information is useful for configuring your network and troubleshooting any network problems. To print these settings, click Print Settings.

Click Finish. Your database is configured!

Next Topic: Network Configuration Overview