Error 15023: User already exists in current database.<\/p>\n
1) This is the best Solution.<\/p>\n
First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan.<\/p>\n
[sql]
\nUSE YourDB
\nGO
\nEXEC sp_change_users_login ‘Report’
\nGO
\n[\/sql]<\/p>\n
Run following T-SQL Query in Query Analyzer to associate login with the username. \u2018Auto_Fix\u2019 attribute will create the user in SQL Server instance if it does not exist. In following example \u2018ColdFusion\u2019 is UserName, \u2018cf\u2019 is Password. Auto-Fix links a user entry in the sysusers table in the current database to a login of the same name in sysxlogins.<\/p>\n
[sql]
\nUSE YourDB
\nGO
\nEXEC sp_change_users_login ‘Auto_Fix’, ‘ColdFusion’, NULL, ‘cf’
\nGO
\n[\/sql]<\/p>\n
Run following T-SQL Query in Query Analyzer to associate login with the username. \u2018Update_One\u2019 links the specified user in the current database to login. login must already exist. user and login must be specified. password must be NULL or not specified<\/p>\n
[sql]
\nUSE YourDB
\nGO
\nEXEC sp_change_users_login ‘update_one’, ‘ColdFusion’, ‘ColdFusion’
\nGO
\n[\/sql]<\/p>\n