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

The information in this article 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
Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
Microsoft SQL Server 2005 Enterprise X64 Edition
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]

NoteOldComputerName\Username is a placeholder for the login name that contains the old computer name. NewComputerName\Username 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 "Applies to" section.

REFERENCES

For more information about the ALTER LOGIN statement, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms189828(d=ide).aspx

Modification Type:	Major	Last Reviewed:	7/31/2006
Keywords:	kbExpertiseAdvanced kbtshoot kbsql2005engine kbprb KB922549 kbAudDeveloper kbAudITPRO