SQL database Isolation problem processing

Attach the database file to another database service by copying it from one database service.

After using SQL query to find the error, Baidu discovered that this is called the orphan account. Orphaned accounts: It is the account of a database that has only a user name and no login, so that the user exists in the sysusers system table in the user library and there is no corresponding record in the syslogins of the master database.

Workaround:

The first step: first select the new database, do: Create a new query operation, exec sp_change_users_login ' report ', query whether the database is orphaned users.

If there are: Username,userid will be listed separately, orphaned user name and orphaned user ID.

Step Two: Execute this line of code operation: exec sp_change_users_login ' update_one ', ' query out orphaned user name ', ' Database login username ' for database file assignment. (Note If you have manually bound the login user name, click the login user name and cancel the user mapping of the data file in the Execute Code action.) ）

SQL database Isolation problem processing