<div>
Is there any way to associate a orphan account with a new windows account??
</div>


Is there any way to associate a orphan account with a new windows account??

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


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.

SQL SERVER Enterprise Manager Login Name Blank

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.