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!!
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