Note: The password for the application role {0} cannot be retrieved from the source database due to security considerations. ...

Note: The password for the application role [{0}] cannot be retrieved from the source database due to security considerations.  A random password has been generated for this role.  This password can be changed in the target database by first dropping the role using sp_droprole and then recreating the role using sp_addrole.