SQL Server Migration Data

Source: Internet
Author: User
Tags microsoft sql server
sqlserver2000 backup data is migrated to sqlserver2005 using the database corresponding to the user video315 cannot access the specified database
Error:
User, group, or role ' video315 ' already exists in the current database. (Microsoft SQL Server, error: 15023)
Reference: https://www.cnblogs.com/douxuyao/p/3530052.html

View SQL Server Security-----The video315 attribute in the login name to discover that the user's corresponding database is not authorized and the manual authorization does not take effect

Executing in a new query
Use v315db
Go
Sp_change_users_login ' Update_One ', ' video315 ', ' video315 ' after re-testing can use user video315 to access the corresponding database v315db

Check that the user authorization is updated after the operation is completed

SQL Server Migration Data

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.