SQL Server Error 15023: a user or role already exists in the current database

Solution to SQL Server 15023 Error

First introduceSQLServerLogin"And"User"Difference

"Login"Used for user authentication, while the Database"User"Account is used for database access and permission verification. Logon is associated with the user through the security identifier (SID. When the database is restored to another server, the database contains a group of users and permissions, but the corresponding logon or logon users may not be the same. This situation is called "isolated user ". In this case, you cannot create a new login or grant the "user" permission of the corresponding database to the login with the same name, because sqlserver will report "error 15023: A user or role already exists in the current database. To solve this problem, you need to call the system stored procedure sp_change_users_login. The usage is as follows:

-- Log in with the SA account first

Use netzs -- use the database gosp_change_users_login 'Update _ one', 'username', 'login name', for example, sp_change_users_login 'Update _ one', 'xjiang ', 'yjsy312'

Netzs is a database with isolated users. update_one is a stored procedure parameter, indicating that only one user is processed. The previous xjiang is a "user", and the last xjiang is a "login ", the preceding SQL statement re-connects "xjiang", the server logon user, and "xjiang", the netzs database user. In this way, the database can be used normally.

From: http://cndongtian.blog.163.com/blog/static/17552338720101511540698/