Create a SQL Server database - HxGN SDx - Update 20 - Installation & Upgrade

Distributed Server Setup for HxGN SDx

PPMProduct
HxGN SDx
PPMCategory_custom
Installation & Upgrade
SPFVersion_custom
10
  1. If you are using an existing SQL Server database, skip to step 5. Otherwise, type, or browse to, the Location of the scripts to create tables to specify the scripts used to create the database.

    This script is the default script installed with Server Manager.

    • An example of the default script to create tables for a SQL server site can be found at: [product installation location]\SPFServerManager\DatabaseScripts\Template_SPLMDbaseTablesSQL.sql

    • if you specify a different path than the default path in Location of the scripts to create tables, after you set up the license site, Server Manager will remember that path next time you open the wizard. If the path you specified does not exist next time you open the wizard, the path is reset to the default.

    • If you are using an existing SQL Server database, this option and the boxes for the physical database file and log file location are disabled.

  2. If you want to save the current path for future operations, select the Save as default option.

  3. Accept the default Physical database file location.

  4. Accept the default Log file location.

  5. In the Database username box, type the name of the database user who owns the objects in the data database schema.

  6. Type and then confirm the Database password for the SQL Server database user.

  7. Click Next. The Ready to Create License Server page appears. Review the new server parameters, and click Back to make any changes.

  8. Click Next. The Server Creation Status appears as the site is created, and then the After License Server Creation page appears.

  9. Read the information about the additional steps required to fully configure the new site, and then click Finish to create the site. The new site displays in the tree view.

    For more information about fully configuring the server, see Configure the license server for performance.

At the end of the process the wizard adds a new entry to each selected site's SPFAppServer.config file, which allows the user to direct each site to a license server. For example:

<add key="LicenseServerURL" value=http://localhost/SPFLicenseServer />