3.3 Creating the Schema

When you use a browser to connect to Novell Service Desk for the first time after it is installed, you are prompted to choose the desired database type and are also provided with a script to create the database schema.

  1. Use a Web browser to open the following page on the device:

    http://<DNS_name_or_IP_address_of_device>:<port>

    Replace DNS_name_or_IP_address_of_device with the DNS name or the IP address of the server on which the Novell Service Desk has been installed and replace port with the port number used during the installation.

  2. On the Application Setup page, fill in the following fields:

    Database Type: Select a supported database platform from the list. For a list of the supported database platforms, see Section 2.1.2, Database Requirements.

    Server Host: Specify the DNS name or the IP address of the database server. We recommend that you specify the DNS name to avoid any reconfiguration when the database server connection details change.

    Server Port: Depending on the selected database type, the default port is automatically displayed. However, if you changed the default port during the installation of the database server, specify the changed port.

    Database Name: Specify the name of a blank database on the database server for exclusive use by Novell Service Desk.

    Username: Specify the user to be created for use by Novell Service Desk.

    Password: Specify the password for the Novell Service Desk user.

  3. Click Test to test if the Novell Service Desk can access the database server and the blank database. If a successful message is displayed, continue with Step 4. If not, ensure that the details are correctly specified on the Application Setup page in Step 2.

  4. Click Advanced, then click Create. The Application Setup page displays a database script that must be executed to populate the database with tables.

  5. Select the text on the Application Setup page by pressing CTRL+A. Copy the selected content, paste it into a file, and save the file.

  6. Click Done.

  7. Load the saved file into the database query tool of the database server that you are using.

    The following figure displays the MS SQL Server Query Tool.

  8. After the successful execution of the script, the browser displays the following Application Setup page:

  9. Click Save to store the connection details and initialize the connection with Novell Service Desk.

  10. The Novell Service Desk login page is displayed.

  11. Use one of the following credentials to log into Novell Service Desk:

    • Administrator Credentials: Username: admin; Password: admin

    • Supervisor Credentials: Username: super; Password: super

For details on using and configuring Novell Service Desk in your environment, see Administrator Guide and User Guide.