Error 15023: User already exists in current database

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

15023Yeni Bir Query sayfası açın. İlgili Datbase ismini seçip, aşağıda ki komutu çalıştırın.

EXEC sp_change_users_login ‘Auto_Fix’, ‘username

The number of orphaned users fixed by updating users was 1.
The number of orphaned users fixed by adding new logins and then updating users was 0.

Leave a Reply

Your email address will not be published. Required fields are marked *