Configure a SQL Server database - Intergraph Smart API Manager - Installation & Upgrade - Intergraph

Smart API Manager Installation and Configuration

PPMProduct
Intergraph Smart API Manager
PPMCategory_custom
Installation & Upgrade
  1. In the Database Server section, provide location and name information for the database.

    Server Type

    The database type: SQL Server.

    Server Name

    The name of the database server.

    The default value is a period, which represents the computer where you are running the Configuration Utility. Do not use this default value unless this computer is also the database server.

    For a named instance, use the following syntax:

    MyServer\MyInstance

    Port

    The port on the database server used to connect to the database. If left blank, the default port is used (1433).

    For a named instance configured to use dynamic ports, leave the port value blank.

    Database Name

    The name of a new or existing database.

    You must connect to the database server with the System Administrator Account credentials to specify a database. See the following step for details.

  2. In the System Administrator Account section, provide credentials for the database user used to create or modify the database structure or schema.

    For an existing database, the user must be a member of the sysadmin server role or db_owner database role. For a new database, the login specified must be a member of the sysadmin or dbcreator server roles.

    Use Windows authentication

    The Configuration Utility connects to SQL Server via Windows authentication using your current Windows credentials.

    Use user name /
    password

    The Configuration Utility connects to SQL Server via SQL Server Authentication using the login/user credentials you enter.

  3. Click Connect to connect to the database server with the provided credentials.

  4. In the Runtime Account section, provide credentials for the database user used to connect to the database.

    The user must have read/write access to the database but does not require administrative privileges.

    Smart API Manager always connects to the database with these credentials, regardless of which user is logged into the Smart API Manager web client.

    Use Windows authentication (Application Pool Identity)

    Smart API Manager connects to the database via Windows authentication using Application Pool identity. Using Windows authentication is the preferred method for your runtime account.

    Use user name / password

    Smart API Manager connects to the database via SQL Server authentication using the user credentials you enter.

    If you are using an existing database, the credentials you enter must already exist in the database management system.

    If you must use SQL Server authentication, do not specify a user account having elevated permissions, like SA.

    If you enter a username and password for a new user, the credentials you enter for System Administrator Account must be a member of the sysadmin or securityadmin server roles.

  5. Click Test to ensure the connection is successful with the provided credentials.

  6. Click Next, and continue with Step 4: Runtime configuration.