After copying a database and security information to a new server, I'm trying to map a user ('UserX') to a database in SQL. However, when attempting to save, I get an error message: User, group, or role 'UserX' already exists in the current database. UserX does exist in the database. I tried to delete the user in the database, but the user is tied to a database schema. Attempting to delete the schema...already a likely bad idea...fails tied to an object named 'admins'. How can I get 'UserX' mapped to the database? What needs to be undone and reconstructed?
Thanks in advance.