Loss Of SQL Registration in Enterprise Mgr

[Mickeyncube]

Hi Guys

On numerous occasions now I have booted my PC up after a weekend or a reboot during the day and have found that all my previously registered servers within Enterprise Manager have been lost. This is not a major deal as it only takes 15-20 minutes to put them all back again but at some point I’d like this investigating and more importantly resolving. Perhaps this is a known error with SQL/2000 Enterprise Manager on XP?

Could you please help

Thanks in advance

 

[prodigymad]

This is apparently a known issue with SQL running on WinXP. It only occurs when the windows password is changed, it seems to loose all known SQL registrations.

The fix is supposed to be a case of installing SP3 for SQL but I have tried this and it still happened to me this morning. This is really doing my head in as I have to dial into my customers SQL databases and I have all their details registered in Enterprise Manager.

If anyone knows any further info then please let us know!

 

[prodigymad]

Please see this part of an email that I have found from another SQL forum. I think this may sort the problem out:

I learned that when changing your domain user password on the WinXP client, you will lose registered SQL
Servers in SQL Enterprise Manager. In addition, you applied the method in KB 323280 but the problem
persists if you change the password.

===========================

Based on my experience, even after applying SP1 for Windows XP, we may still experience the same
problem. The methods in the following Knowledge Base (KB) articles should solve the problem you met
with:

323280 FIX: Registered remote servers disappear from SQL Enterprise Manager in

http://support.microsoft.com/?id=323280

316994 Denied Access to Encrypted Files After You Change Your Password

http://support.microsoft.com/?id=316994

===========================

Nevertheless, the fix in XP service pack 1 only works if the registry key "MasterKeyLegacyNt4Domain" is
set on the Windows XP machine:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-
8c7a-00c04fc297eb]
"MasterKeyLegacyNt4Domain"
Type: REG_DWORD
Value: 00000001


To add that key, you can follow the detailed steps below:

a) Open Registry Editor (Start-> Run -> Regedt32)
b) Go to the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-
8c7a-00c04fc297eb
c) Create the follow value (Edit->New->DWORD Value):

Value Name: MasterKeyLegacyNt4Domain
Value Type: REG_DWORD
Value: 00000001

d) Change your network account password and login again to see if the problem goes away.

===========================