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.

One Response to “Error 15023: User already exists in current database”

  1. This is a very interesting It is a great article. You will surely like this also because it is a great stuff, yeah it’s give us lots of interest and pleasure. Their opportunities are so fantastic and working style so speedy.

Leave a Reply

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