Contained and login user passwords from the source aren't working in the target after restoring a .bacpac from one Azure SQL Server onto another Azure SQL Server.
The users do exist in the target SQL Server database, but they are unable to login with the same password from the source in the target SQL Server.
How can we keep intact and make the passwords work?
I too faced this issue a year ago and after consulting Microsoft support, they confirmed that this is by design that the passwords are changed in the background for security reasons. I would suggest you to run a script or procedure to alter user passwords back to original ones after restoring the database from bacpac file.
ALTER USER [USERNAME] WITH PASSWORD=[PASSWORD]
Apart from the solution to alter user passwords, you can see the resolution strategy given by Microsoft support -
