This error occurs because Dimensions and Service Manager share the same SQL user. To change a user's password, you'll need to update it in Dimensions first. Follow these steps:
Log in to Dimensions as SA.
Change the users' password in Dimensions.
Log in to Service Manager using your login details.
You should now be able to change the user's password in Service Manager.