FIX: Registered remote servers disappear from SQL Enterprise Manager in Windows XP when user password is changed

On a Microsoft Windows XP-based computer, if a user changes the password for their Windows XP logon account, any remote registered servers in SQL Enterprise Manager (SEM) may be removed after the user logs off of Windows XP or restarts the server and then logs back in. After the user logs back in, when they open SQL Enterprise Manager, the list of remote servers is empty.

This problem occurs because of a bug in Windows XP.

To resolve the problem, perform these tasks:

1. On the Windows XP-based computer, install the latest Windows XP service pack.
   
   For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
   322389  (http://support.microsoft.com/kb/322389/ ) How to Obtain the Latest Windows XP Service Pack
2. If the Windows XP-based computer is a member of a Microsoft Windows NT 4.0 domain, and the Windows XP logon account is a member of the domain, you must perform the following step:
   • Add a MasterKeyLegacyNt4Domain key of type "REG_DWORD" and value "00000001" under the following registry key:
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb.
     To do so, follow these steps:
     
     WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
     1. Click Start, and then click Run.
     2. In the Open box, type regedit.
     3. In Registry Editor, locate the following registry key folder in the left pane:
        
        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb
     4. Click the df9d8cd0-1501-11d1-8c7a-00c04fc297eb registry key folder.
     5. On the Edit menu, point to New, and then click DWORD Value.
     6. Name the newly created key MasterKeyLegacyNt4Domain.
     7. Double-click the MasterKeyLegacyNt4Domain key.
     8. In the Edit DWORD Value dialog box, type 00000001 in the Value data box, and then click OK.
3. On the Windows XP-based computer, install the latest SQL Server 2000 service pack.
   
   For additional information about how to obtain the latest service pack of SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:
   290211  (http://support.microsoft.com/kb/290211/ ) INF: How To Obtain the Latest SQL Server 2000 Service Pack

Microsoft has confirmed that this is a problem in Microsoft Windows XP.

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base: