After changing the CMS Content Sync user password, the sites configuration has to be exported to the Sync Core. To do so, the easiest way is to use Drush: drush cse
If you are experiencing access denied errors after changing the CMS Content Sync users password, you might have to truncate Drupals flood table.