Microsoft KB Archive/323280

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

Article ID: 323280

Article Last Modified on 3/17/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition, when used with:
 * Microsoft Windows XP Professional

-



This article was previously published under Q323280



Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
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.



CAUSE
This problem occurs because of a bug in Windows XP.



RESOLUTION
To resolve the problem, perform these tasks:  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 How to Obtain the Latest Windows XP Service Pack

 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 &quot;REG_DWORD&quot; and value &quot;00000001&quot; under the following registry key:

.

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.  Click Start, and then click Run. In the Open box, type regedit . In Registry Editor, locate the following registry key folder in the left pane:

</li> Click the df9d8cd0-1501-11d1-8c7a-00c04fc297eb registry key folder.</li> On the Edit menu, point to New, and then click DWORD Value.</li> Name the newly created key MasterKeyLegacyNt4Domain .</li> Double-click the MasterKeyLegacyNt4Domain key.</li> In the Edit DWORD Value dialog box, type 00000001 in the Value data box, and then click OK.</li></ol> </li></ul> </li> 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 INF: How To Obtain the Latest SQL Server 2000 Service Pack

</li></ol>

<div class="status_section">

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

<div class="references_section">