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:

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