We have migrated few databases from old server to server server, later the application is failing to login at one particular database. I verified the database security and confirmed that user is missing then i started adding the user into that database and i encountered the below error
The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)
There is a login called app_user, I tried to add that user like below
Databases -- Security -- New User -- Name - app_user and Login name = app_user but it is giving the above error. It is because the dbo is mapped with app_user for that reason it is not allowing us to map the new user with same login.
To resolve this
Run the below command on the problematic database
Use database_name
sp_changedbowner 'sa'
After executing the above coammdn then it will allow you to add a new user then we can map the user with specified to login. We can't directly do this from wizard, we need to run the T-sql command to modify it. And also it doesn't allow to drop the dbo user from the database.
The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)
There is a login called app_user, I tried to add that user like below
Databases -- Security -- New User -- Name - app_user and Login name = app_user but it is giving the above error. It is because the dbo is mapped with app_user for that reason it is not allowing us to map the new user with same login.
To resolve this
Run the below command on the problematic database
Use database_name
sp_changedbowner 'sa'
After executing the above coammdn then it will allow you to add a new user then we can map the user with specified to login. We can't directly do this from wizard, we need to run the T-sql command to modify it. And also it doesn't allow to drop the dbo user from the database.
Thank you. That worked great!
ReplyDeleteExcelente, funcionou!! Muito Obrigado!
ReplyDelete