Installation

Installation

Set Up the JMP Server Database

Before you can run the JMP installer, you must create a database and two database logins.

Prerequisites for Setting Up the JMP Server Database

To perform this exercise, you need the following:

  • User account – AD credentials for the user account that will be used for installing the JMP server. To run the installer, you must use a domain user account with local administrative privileges on the host system of the JMP server VM.
  • SQL Server instance – This is the database server on which you will create the database for the JMP server. For the example in this exercise, we used Microsoft SQL Server 2016. For a list of all supported databases, see Database Requirements for JMP Server.
  • Microsoft SQL Server Management Studio – For the example in this exercise, we used Microsoft SQL Server Management Studio v17.7. The instructions might differ slightly for different versions of SQL Server Management Studio.
  • SA credentials – To create the necessary logins for the JMP server database, you will log in to the SQL Server instance as the sysadmin (SA) or as a user account with SA privileges.

1. Open Microsoft SQL Server Management Studio

  1. On the VM where SQL Server and SQL Server Management Studio are installed, click the Start button.
  2. Navigate to and select Microsoft SQL Server Management Studio.

2. Log In to a SQL Management Studio Session as SA

  1. Select SQL Server instance. By default your Windows login credentials are used, but you are not required to use Windows authentication.
  2. Log in as the sysadmin (SA) or using a user account with SA privileges.
  3. Click Connect.

3. Create a Database for the JMP Server

  1. In the Object Explorer, right-click Databases.
  2. Select New Database.

4. Name the Database

  1. For the database name, enter JMPDB. You must use only ASCII characters. Use the default settings.
  2. Click OK.

5. Create a Database Login for the JMP Server Machine

The JMP server installer needs to access the database when it runs. You must create a login for this purpose.

5.1. Create a Login

  1. Expand the Security folder, and right-click Logins.
  2. Select New Login.

5.2. Complete the General Settings

  1. Enter a login name to use for the JMP server machine, using ASCII characters only; for example, JMPSERVER.
  2. Select SQL Server authentication, and create a password.
  3. De-select Enforce password policy. For the purposes of this exercise, you do not need to use password policies.
  4. Select a default language.

You can leave the default database set to master, or you can select the JMPSERVER database.

5.3. Assign the sysadmin Server Role

  1. Select the Server Roles page.
  2. Select the sysadmin check box.

5.4. Map the Login to the JMP Server Database

  1. Select the User Mapping page.
  2. Select the JMPDB database.
  3. Click OK.

The new login is added under the Security > Logins folder in the Object Explorer pane, and the user is added under the Databases > JMPDB > Security > Users folder.

6. Create a Login for the User Account That Will Install the JMP Server

  1. Expand the Security folder, and right-click Logins.
  2. Select New Login.

6.1. Select the AD Credentials

  1. Click Search.
  2. Enter a valid Active Directory user account that you plan to use to install JMP Server.
  3. Click Check Names to validate the account name.
  4. Click OK.

6.2. Assign the sysadmin Server Role

  1. Select the Server Roles page.
  2. Select the sysadmin check box.

6.3. Grant the User the db_owner Role for the JMPDB Database

  1. Select the User Mapping page.
  2. Select the JMPDB database.
  3. Select the db_owner role.
  4. Click OK.

The new login is added under the Logins folder in the Object Explorer pane, and the user is added under the Databases > JMPDB > Security > Users folder.

Install the JMP Server

Installing the JMP server is a simple process of running the installation wizard and pointing to the JMP server database you created.

Prerequisites for Installing the JMP Server

To perform this exercise, you need the following:

Note: If the VM has McAfee Antivirus installed, add the following files to the McAfee Antivirus exclusion list before you install the JMP server.

C:\Program Files (x86)\VMware\JMP\nssm-2.24\nssm-2.24\win32\nssm.exe
C:\Program Files (x86)\VMware\JMP\com\xmp\node_modules\winser\bin\nssm.exe

1. Copy or Download the Installer to the JMP Server VM

For this example, we downloaded the installer to a VM hosted on a VMware ESXi server. To connect to this VM, called CA-JMP, you would select the VM in the inventory list and select Launch Web Console.

For the example in this exercise, we copied the file to the JMP server system, but you can alternatively copy it to a location accessible to the system.

2. Start the Installer

  1. Log in to the JMP server host system as a domain user with administrative privileges on the host system, and double-click the installer file.
  2. Follow the prompts until you get to the Allow HTTP Traffic on Port 80? page.

3. Click Next

The JMP server uses port 443 and, optionally, ports 80, 3000–3004, 888, and 8889. The choice of whether to allow port 80 is up to you. For the purposes of this exercise, and for some POC (proof-of-concept) installations, enabling HTTP traffic on port 80 helps avoid having to troubleshoot issues with encryption.

4. Click Browse to Select the Database Server

Although you can type in the name of the server, using the Browse button ensures that the server is accessible and avoids typing mistakes.

Note: By default, the connection uses Windows authentication. This is correct, assuming you logged in to the system as the same domain user that you used for creating the database login, as described in Set Up the JMP Server Database.

5. Select the Database Server

Select the database server you used when completing the exercise Set Up the JMP Server Database, and click OK.

6. Enter Credentials for SQL Server Authentication

  1. Select Server authentication using Login ID and password below. This was the type of authentication used in the exercise Set Up the JMP Server Database.
  2. Enter the login ID name (JMPSERVER) and password you used when you created this ID.

7. De-select Enable SSL Connection and Click Browse

  1. Click to remove the check mark from the Enable SSL Connection? check box.

    Important: When this check box is selected, the TLS/SSL certificate used in SQL Server must be imported into the Windows local certificate store on the JMP Server host before you run the installer. Otherwise, the JMP server installation process fails with the error "Failed to execute uem_migrate.bat file," and when you click OK in the error dialog box, installation is rolled back. In a production environment, for security purposes, you would leave this check box selected, but for this exercise, de-select the check box.
  2. Click Browse to select the database from a list.

8. Select the JMPDB Database

  1. Select the database you created when completing the exercise Set Up the JMP Server Database.
  2. Click OK to close the dialog box, and click Next on the wizard page.

9. Click Install

After installation is complete, the wizard notifies you that installation was successful.

10. Verify Installation

  1. Navigate to the Programs and Features control panel.
  2. Verify that the VMware JMP Server program appears in the list.