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 Platform Services to connect to your 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 Platform Services 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 Platform Services in the Services (Local) pane of the Services window and click Stop.
  2. Open the ODBC Data Source Administrator window by double-clicking one of the following executable files that is appropriate for your JMP Server host.
    • C:\Windows\SysWow64\odbcad64.exe

    • C:\Windows\system32\odbcad32.exe

  3. In the ODBC Data Source Administrator window, click System DSN and select the svmanager in the User Data Sources pane.
  4. Click Configure.

    The Microsoft SQL Server DSN Configuration wizard appears.

  5. Click Next.
    Caution:

    Do not change the existing information in the data source Name or Server text boxes.

  6. Ensure that the With SQL Server authentication using a login ID and password entered by the user is selected.
  7. Enter a new password in the Password text box and click Next.
  8. Click Next again, without changing to the existing information in the default database info page.
  9. Click Finish.

    The ODBC Microsoft SQL Server Setup summary window appears with the configuration details.

  10. Review the information summary and click OK to proceed with the password modification for the VMware JMP Platform Services service.
  11. Add the new password information to the VMware JMP Platform Services database configuration file before restarting the VMware JMP Platform Services service.
    1. Using a text editor as an administrator, open the database configuration file at C:\Program Files (x86)\VMware\JMP\com\XMS\config\database.yml.
    2. Locate the line for the username property and insert a new line after that line for the password property.
    3. Enter the information for the password you created so that it appears as shown in the following example.
      password: new_password
      Important:

      This password information is automatically removed from the database.yml file after the VMware JMP Platform Services service is restarted.

  12. Restart the VMware JMP Platform Services 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 Platform Services 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 File Share Service. See Update Database Password for VMware JMP File Share Service.