We have a login on the dev server which mirrors the login on the production server, but I can't get it to mapped to another db in the same server group on the dev. When I edit the properties of the login in 'User Mapping", I check the map to 2nd db, and I get the following error:
Create failed for User 'myLogin_name'. (Microsoft.SqlServer.Smo)
User, group, or role 'mylogin_name' already exists in the current database. (Microsoft SQL Server, Error: 15023)
I know that user exists as it was listed under that db's security, users.