DB migratiion

User Already Exists in the Current Database

May 19, 2017 Jordansphere MS SQL

Scenario: I was transferring a database (mick) from one SQL2005 server to an SQL2012 server. During the mapping of a user login (mick) I got the following the error: Create failed for User 'mick' User, group, or role 'mick' already exists in the current database   Answer:   In Studio Management you can use the follwing command :   […]

More

DB migratiion, MS SQL 200, MS SQL 2012, User Already Exists in the Current Database,

Powered by WordPress. Designed by elogi.