0
(0)

We were facing below error while trying to grant access to the database for specific login.

Problem Description:

Create failed for User (Microsoft.SqlServer.Smo)
SQL Server Error User, group, or role already exists in the current database. (Microsoft SQL Server, Error: 15023)

Solution:

use database name
go
exec sp_change_users_login "Auto_Fix", "user_name"
go

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.