Microsoft KB Archive/922549

= The SQL Server login name is not updated in the sys.syslogins catalog compatibility view after you change the computer name =

Article ID: 922549

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Express Edition with Advanced Services
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard X64 Edition

-



Bug #: 408221 (SQLBUDT)



SYMPTOMS
Consider the following scenario. You create a Microsoft SQL Server login in SQL Server 2005. The SQL Server login uses Windows Authentication mode from a Windows local user. The name of the newly created SQL Server login is stored in the sys.syslogins catalog compatibility view. You change the name of the computer where SQL Server 2005 is installed. In this scenario, the name of the SQL Server login is not updated in the sys.syslogins catalog compatibility view.



WORKAROUND
To work around this problem, run the following statement after you change the computer name. ALTER LOGIN [OldComputerName\Username] WITH NAME = [NewComputerName\Username] Note is a placeholder for the login name that contains the old computer name. is a placeholder for the login name that contains the new computer name.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

