To change the database user and connection URL for the grid

  1. Stop the grid.
  2. Stop the bootstrap service.
  3. Edit the jdbc.properties file in grid_root_installation_path\grids\gridName\config

    To indicate the new user, replace the line

    user=oldUserName

    with

    user=newUserName

    Note: The code-page (CP) of the file must not be changed. (One editor which will not influence the CP is Notepad++.) Further, take care not to insert any blank lines, spaces, or other characters anywhere in the file (it is recommended that you back up the files prior to changing them to ensure you can recover the original data).
  4. Remember to repeat this process for all hosts in the grid.
  5. Start the bootstrap service for each host.
  6. Start the grid.