I had restored a SQL Azure database between instances, and the contained user used for connections didn’t work. The password needed to be updated.

Using SQL Management Studio:

alter user masteruser with password = '<password>'

(Note: this SQL doesn’t work in Online Query Editor. You need to use Management Studio)