Microsoft KB Archive/234181

= INF: Logins Aliased to Databases Users Cannot Be Viewed from SQL Enterprise Manager =

Article ID: 234181

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q234181



SUMMARY
In SQL 6.5, aliases from a login to a database user could be viewed in Enterprise Manager by double-clicking on that database user. However, SQL 7.0 (or later) Enterprise Manager provides no means to view the logins aliased to a particular database user. This behavior is correct due to the fact that SQL 7.0 and later replace aliases with roles, maintaining aliases only for backward compatibility. All aliases should be dropped, security accounts for the aliased logins should be added to the database, and the security accounts should be assigned to database roles. For example: sp_dropalias ' ;' go sp_grantdbaccess ' ', ' ' go sp_addrolemember ' ', ' ' go



MORE INFORMATION
This problem is most often seen after a server that uses aliases is upgraded to SQL 7.0 or later.

Executing "sp_helpuser" shows the aliased logins in SQL 7.0 or later.

NOTE: Aliased logins are stored in sysusers with a '\' at the beginning of the name and a status of 16.

Keywords: kbinfo KB234181

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.