How can I update the password used in my MWS DataSource?

Product/components used and version/fix level:

Our installation runs on Windows Server 2019 and MWS is version 10.15

Detailed explanation of the problem:

The database team has been told to reset the passwords for all DB accounts at least one time per year. I went into the administrative console for MWS to potentially update the password and found that the connection cannot be modified. (See screenshot below):

Error messages / full error message screenshot / log file:

No error, just that the settings cannot be modified. Is this intended to not be able to update the password used to connect to the database?

Question related to a free trial, or to a production (customer) instance?

This is a Production instance. Paid, not free trial.

You should be able to edit it with the button below the tools column. It should open a context menu. Click modify in the context menu.

If you can’t it’s probably because its in use. If that’s the case you need to create another, make it default and delete the previous one but that shouldn’t be the case.

Hi,

you can try the following:

  1. Shutdown MWS
  2. Find the mws.db.xml in your installation directory (under MWS/server/default)
  3. Put the new password there in plain text (will be automatically encrypted during next start)
  4. Restart the IS

Regards,
Holger