Bookshelf v7.5: Installing Siebel Database Server Components on MS SQL Server

Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Database Server for Microsoft SQL Server > Configuring the Database Server on MS SQL Server >

Installing Siebel Database Server Components on MS SQL Server

When you choose Install a new Siebel Database from the Siebel Database Server Options menu, the Siebel Software Configuration Wizard:

Creates Siebel tables and indexes.

Inserts Siebel seed data.

Installs Siebel seed data specific to your database.

NOTE: Every time you install a new primary (base) language, you will need to launch the Siebel Software Configuration Wizard and navigate to Siebel Database Server Options > Install> Add a language to existing database. For a complete list of languages supported by Siebel eBusiness Applications in this release, and their corresponding Siebel language codes, see System Requirements and Supported Platforms on the Siebel Bookshelf.

To install Siebel database server components

Launch the Database Server Configuration Wizard, using any method described in Launching the Siebel Software Configuration Wizard.

The Gateway Server Address screen appears.

Type the following values as you recorded them in your copy of Deployment Planning Worksheets and then click Next.

Gateway Server Address. The domain name and alias of the host on which you installed the Siebel Gateway.

Enterprise Server Name. The name you gave to your Siebel Enterprise Server, for example, siebel.

The Siebel Server Directory screen appears.

On the Siebel Server Directory screen, perform either of the following tasks and click Next:

Accept the default value displayed in the Siebel Server Directory field. (This is the SIEBSRVR_ROOT directory, for example, D:\siebsrvr.)

Use the browse button to select an alternate directory path.

The Siebel Database Server Directory screen appears.

On the Siebel Database Server Directory screen, perform either of the following tasks and click Next:

Accept the default path displayed in the Siebel Database Server Directory field. (This is the DBSRVR_ROOT directory, for example, D:\dbsrvr.)

Use the Browse button to select an alternate directory.

The RDBMS Platform screen appears.

Select Microsoft SQL Server.

Click Next.

The Siebel Database Operation screen appears.

Select Install Database and click Next.

The Siebel User/Role Creation screen appears, prompting you to execute the grantusr.sql script to create tableowner and administration accounts, if you have not already done so.

Indicate whether or not you have already run the grantusr.sql script to set up tableowner and administration accounts:

If you already ran grantusr.sql, click the uppermost radio button, and then click Next. Proceed to Step 9.

The Select Installation Operation screen appears.

If you did not already run grantusr.sql, click the lower radio button, and then click Next. The Configuration Wizard quits. Proceed to Step 8.

Run the grantusr.sql script, then return to Step 1, relaunch the Configuration Wizard, and start this procedure over.

If you already ran grantusr.sql, the Select Installation Operation screen appears.

On the Select Installation Operation screen, click Install Siebel Database, and then click Next.

On the Database Encoding screen, identify the appropriate database encoding method:

If your database uses a Unicode code page, click UNICODE Database.

If your database uses a non-Unicode code page, click Non-UNICODE Database.

CAUTION: Carefully choose the correct option for your database to prevent installation of the wrong data types. The database will not be able to create Unicode data types on a non-Unicode page setting, so check this setting carefully before choosing the option.

The Language Selection screen appears.

On the Language Selection screen, choose the language in which you want to run your database, and then click Next.

NOTE: If you only installed a primary (base) language and no additional languages, this screen does not appear.

The ODBC Data Source Name screen appears.

Indicate the name for the ODBC data source and then click Next.

NOTE: The data source is created automatically by the Siebel Server installation, using the format SiebSrvr_enterprise_server_name.

The Database User Name screen appears.

On the Database User Name screen, indicate the following about your database:

Database User Name. Type the user name of the Siebel administrator, for example, SADMIN.

Database Password. Type the password for the Siebel administrator, for example, MSSQL.

Database Password (confirm). Retype the password to confirm it.

Click Next.

The Database Table Owner screen appears.

On the Database Table Owner screen, indicate the following about your database:

Database Tableowner. Type the DBO login ID for the Siebel Database.

Database Password. Type the password for this account, for example, MSSQL.

Database Password (confirm). Retype the password to confirm it.

The Database Server OS screen appears.

On the Database Server OS screen, select the platform on which your database server runs, and then click Next.

The Configuration Parameter Review screen appears.

On the Configuration Parameter Review screen, review the configuration values you entered on the previous Configuration Wizard screens:

If you need to change any values, use the Previous and Next buttons to access the screens on which to change entries, then to return to this screen.

When you are satisfied, click Finish.

A message box appears with the prompt:

To apply the configuration now, press "OK".

To apply the configuration later, press "Cancel".

The command line to apply the configuration later is

C:\SIEBEL_ROOT\siebsrvr\bin\siebupg.exe /m master_install.ucf

NOTE: If a program or system error occurs and you need to rerun the Siebel Upgrade Wizard, you can do so, starting at the point at which the wizard failed, by navigating to \SIEBEL_ROOT\siebsrvr\bin and entering:
siebupg.exe /m master_install.ucf

The Siebel Upgrade Wizard screen appears, displaying the items to be executed or imported.

To begin, click OK.

If you need to change the values you previously entered, relaunch the Configuration Wizard. The relaunch will allow you to reconfigure with different values.

The Siebel Upgrade Wizard Complete screen appears when installation is complete.

You have now finished installing Siebel database server components.

Siebel Server Installation Guide for Microsoft Windows
Published: 25 June 2003