I faced the same issue. I did the backup on Friday and tried the restore on Tuesday (after 4 days). I used the link provided by michaelryancook to fix it. But my question is: Does the server change its password automatically? because it never asked me to change the password in the time period between the backup and restore.
Thank you all in advance.