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:

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

  1. Launch the Database Server Configuration Wizard, using any method described in Launching the Siebel Software Configuration Wizard.
  2. The Gateway Server Address screen appears.

  3. Type the following values as you recorded them in your copy of Deployment Planning Worksheets and then click Next.
  4. 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.

  5. On the Siebel Server Directory screen, perform either of the following tasks and click Next:
  6. On the Siebel Database Server Directory screen, perform either of the following tasks and click Next:
  7. Select Microsoft SQL Server.
  8. Click Next.

    The Siebel Database Operation screen appears.

  9. Select Install Database and click Next.
  10. 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.

  11. Indicate whether or not you have already run the grantusr.sql script to set up tableowner and administration accounts:
  12. Run the grantusr.sql script, then return to Step 1, relaunch the Configuration Wizard, and start this procedure over.
  13. If you already ran grantusr.sql, the Select Installation Operation screen appears.

  14. On the Select Installation Operation screen, click Install Siebel Database, and then click Next.
  15. On the Database Encoding screen, identify the appropriate database encoding method:
  16. On the Language Selection screen, choose the language in which you want to run your database, and then click Next.
  17. 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.

  18. Indicate the name for the ODBC data source and then click Next.
  19. 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.

  20. On the Database User Name screen, indicate the following about your database:
  21. 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.

  22. On the Database Table Owner screen, indicate the following about your database:
  23. 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.

  24. On the Database Server OS screen, select the platform on which your database server runs, and then click Next.
  25. The Configuration Parameter Review screen appears.

  26. On the Configuration Parameter Review screen, review the configuration values you entered on the previous Configuration Wizard screens:
  27. 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.

  28. To begin, click OK.
  29. 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