If you modify the SQL Server database password that was used when JMP Server was installed, you must also update the database password that is used by the VMware JMP File Share Service to connect to the SQL Server database.

Prerequisites

Verify that you have the correct administrative privileges to change the database information in the JMP Server host.

Procedure

  1. In the JMP Server host, stop the VMware JMP File Share Service process using the Windows Services Manager tool.
    1. Right-click the Windows Start icon and select Run.
    2. In the Run dialog box, type services.msc in the Open text box, and click OK.
    3. Locate VMware JMP File Share Service in the Services (Local) pane of the Services window and click Stop.
  2. Update the password used by the VMware JMP File Share Service. Use the following information to determine the steps to use depending on the type of SQL Server connection that used during the JMP Server installation.
    • For the SQL Authentication connection mode:

      1. Navigate to the C:/Program Files (x86)/VMware/JMP/com/uem folder and open the db.json file in a text editor.

      2. Add a new password parameter and set it to the new SQL Server database password that you created after JMP Server was installed. Following is an example.

        "jmp.production": {
            "server": "MyOrg-DB_server\\SQL2014",
            "database": "MyOrg-database",
            "userName": "sa",
            "password": "new_SQL_password",
            "stamp": "nnXXpIIGeImfPJWbuOYAQA==.EDlk3lCqSubg6Y2uIwSSgw=="
          }
      3. Save the file and exit the text editor.

    • For the Windows Authentication connection mode:

      1. Navigate to the C:/Program Files (x86)/VMware/JMP/com/uem folder and open the db.json file in a text editor.

      2. Replace the existing file contents with the following content, where <IP address> is the IP address for the SQL Server host and the <Database name> is the valid database name.

        {
          "jmp.production": {
            "connectionString": "Server=<IP address>;Database=<Database name>;Trusted_Connection=Yes;"
          }
        }
        
      3. Save the file and exit the text editor.

  3. Restart the VMware JMP File Share Service.
    1. Right-click the Windows Start icon and select Run.
    2. In the Run dialog box, type services.msc in the Open text box, and click OK.
    3. Locate VMware JMP File Share Service in the Services (Local) pane of the Services window and click Start.

What to do next

If you have not already done so, you must also update the database login account information used by the VMware JMP Platform Services. See Update the Database Password for VMware JMP Platform Services.