Monday, August 31, 2015

User, group or role already exists in the current database

I was recently working on creating security users in a new installation of SQL Server when I attempted to assign a user to a restored database and encountered the following error message:


Fortunately, I came across this article which offered a very handy fix:  http://blog.sqlauthority.com/2007/02/15/sql-server-fix-error-15023-user-already-exists-in-current-database/

It just told me to run this command to map the database user name back to the database:

EXEC sp_change_users_login 'update_one', 'ColdFusion', 'ColdFusion'

Once I did that, my database login was working once again!!

No comments:

Post a Comment