Installation and Configuration Steps for a SQL Server Database

Install the SQL Server Software

About this task

If you will connect to a SQL Server database, the first step is to install the SQL Server software on the Database Server machine. This documentation assumes that your system meets Database Server system requirements. The installation of the SQL Server software exceeds the scope of this documentation. For information on performing the installation, refer to the SQL Server documentation that is specific to your database server platform.

When you prepare to install SQL Server on the Database Server, you should consider the following notes:

Procedure

  1. GE Digital APM requires mixed-mode authentication for SQL Server installations. The documentation and scripts supplied by GE Digital assume that the SQL Server instance allows mixed-mode authentication.
  2. The GE Digital APM database must be owned by the SQL Server login referenced in the GE Digital APM data source. Being a member of the SQL Server db_owner role is not sufficient. GE Digital provides a script to properly configure the SQL Server database for use with GE Digital APM.
  3. The database supplied by GE Digital (via a .bak file) was created with the SQL Server collation Latin1_General_CI_AS.

What to do next

Create the SQL Server Database

The following instructions provide details on locating the files that are needed for creating and configuring the SQL Server database. To create the database, you will restore a backup file that is included in your GE Digital APM distribution package. For example, the restore database option in SQL Server Management Studio could be used to create the database. Specific instructions on creating the SQL Server database are not included in this documentation.

Steps

  1. On the GE Digital APM Server machine, access the GE Digital APM distribution package, and then navigate to the Database folder.
  2. Open the file MI_DB_MASTER_<version>.zip, and then extract the contents of the file <version>.zip to a folder on the C: drive.
    Important: The name of the folder to which you extract the files must not contain any spaces.
  3. Open the file <version>.zip, then open the subfolder _Setup\NewInstall\SQLServer, and then locate the file MI_<version>.BAK.ZIP.
  4. Place the MI_<version>.BAK.ZIP file in a location where it can be referenced by the SQL Server service, and then restore the file.

    The GE Digital APM database is created.

What's Next?

Configure the SQL Server Database

About this task

The following instructions explain how to configure a SQL Server database for use by GE Digital APM. These instructions assume that the SQL Server database has already been created by restoring a backup file using SQL Server Management Studio or another third-party tool.

These instructions provide details on configuring the GE Digital APM SQL Server database using the script MI_SQL_DB_Configure.sql, which is included in your GE Digital APM distribution package. This script ensures that the database will be properly configured for use with GE Digital APM.

When you run the script MI_SQL_DB_Configure.sql, the following database settings will be configured automatically:

  • The database will be set to read/write mode.
  • The database will be configured to allow multiple users.
  • The database will be set to Full recovery mode.
  • A SQL Server login will be created, and this login will own the database.
  • The SQL Server database name, SQL Server login name, and password will all match.

Procedure

  1. Open a SQL Server Management Studio query window that is connected via a privileged login.
  2. Open the file MI_SQL_DB_Configure.sql, and then copy its contents into the SQL Server Management Studio query window.
  3. Set the @dbname variable to the name of the GE Digital APM SQL Server database that you created.
  4. Execute the edited script.
  5. As needed, use SQL Server Management Studio to modify the password. These are the same login credentials that will be used when you create the GE Digital APM data source that will connect to this database.
  6. Create the custom server-level error messages, which are required by the GE Digital APM system. These error messages must be created at the instance level. Creating them requires a privileged login assigned to either the System Administrator (sysadmin) or Server Administrator (serveradmin) fixed server roles. To create the GE Digital APM error messages:
    1. Make sure that you are connected to the Database Server with SQL Server Management Studio as a System Administrator or Server Administrator user
    2. Execute the stored procedure MI_ERRORS_CRT_ALL_MSGS. This procedure was supplied with the GE Digital APM database and can be executed by using the command exec <databasename>..MI_ERRORS_CRT_ALL_MSGS, where <databasename> is the name of the database you created in the preceding steps.

What to do next

Set the Local DTC Property Settings - GE Digital APM Database Server

About this task

Note: Note: The following settings apply to the Database Server machine if it is using SQL Server.

Procedure

  1. On the machine that will contain the GE Digital APM Database Server, in Server Manager, on the Tools menu, select Component Services.
    The Component Services window appears.
  2. In the left pane, in the tree, expand the Component Services node down to the My Computer node.
  3. Expand the Distributed Transaction Coordinator node.
  4. Select the Local DTC node, and then, on the menu above the tree, select (Properties).
    The Local DTC Properties window appears, displaying the Tracing section.
  5. Select the Security tab.
    The Security section appears.

  6. In this section, specify the settings as follows (and as shown in the preceding image):
    • In the Security Settings subsection, select the Network DTC Access check box.
    • In the Client and Administration subsection, clear the Allow Remote Clients and Allow Remote Administration check boxes.
    • In the Transaction Manager Communication subsection, select the Allow Inbound and Allow Outbound check boxes.
    • In the Transaction Manager Communication subsection, select the Incoming Caller Authentication Required option.
  7. Select OK.
    A message appears, indicating that the MSDTC service will be stopped and restarted.
  8. Select Yes.
    A message appears, indicating that the MSDTC service has been restarted.
  9. Select OK.
    The Local DTC Properties window closes, and your settings are saved. At this point, you can close the Component Services window.

What to do next

About Creating and Configuring the SQL Server Database

After you have installed the SQL Server software on the Database Server machine, you can create the GE Digital APM database by restoring a database backup file that is provided by GE Digital. For example, the restore database option in SQL Server Management Studio could be used to create the database. Specific instructions for creating the GE Digital APM database are not included in this documentation.

After you have created the database, you will need to configure it. To create and configure the GE Digital APM database, you must have access to:

  • Microsoft SQL Server Management Studio.
  • A privileged SQL Server account with sysadmin rights in the target instance.
  • Two files from the GE Digital APM distribution package that will be extracted on the GE Digital APM Server:
    • GE Digital APM, which is included in the file GE Digital APM in the GE Digital APM distribution package.

      -and-

    • MI_SQL_DB_Configure.sql, which was extracted from the GE Digital APM distribution package.

These instructions assume that you are familiar with SQL Server Management Studio or another third-party tool for running SQL scripts.

Note: If you do not have sufficient privileges to restore or configure the database, ask the person responsible for creating the database to create the database and complete the configuration steps. That person will need a copy of these instructions, the BAK file, and the MI_SQL_DB_Configure.sql script.