Create a SQL Server database - SmartPlant Foundation - IM Update 46 - Administration & Configuration

SmartPlant Foundation Server Manager Help
Language
English
Product
SmartPlant Foundation
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
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.

    SHARED Tip 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 />