In SQL Server Enterprise Manager > Database > (Database Name) > users
I have a user that has a blank LOGIN NAME. I need to associate this with one of our domain accounts.
At one point in time this Database user was associated with a domain account. The domain account was deleted at one point. Since then I recreated the account and would like to reassociate the db user with this nt account.
I tried deleting the user on the database level and readding by going to Enterprise Manger > Security. It adds the user ok but the LoginName still turns out blank.