Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cgunner
Yak Posting Veteran
95 Posts |
 Posted - 2005-03-09 : 14:27:35
|
| I registrations keep losing my SQL server registrations from my PC. Has anyone experianced this? |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-09 : 14:47:49
|
| cgunner,Please post your OS version and service pack level. |
 |
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2005-03-09 : 15:01:07
|
| Windows XP SP2 |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-09 : 15:09:54
|
| When do you lose the registration, when you close the EM or when you logoff your computer? |
|
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2005-03-09 : 15:29:56
|
| It is not all the time. I will open EM and they will be gone. I have a number of them and it takes time to get them back. Is there a way to back the registration up? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-09 : 15:37:35
|
| The registration is stored in the registry, so you could export those keys to a reg file, and then when it happens again, just double click on the reg file to get them back. But it sounds like you have some problems on your PC as this should never happen unless someone is messing with you when you leave your desk.Tara |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-09 : 15:38:31
|
| I think the registration info is kept in the current user registry hive (HKCU\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X).It's possible your profile settings on the computer are not being saved when you logout. The information above would normally be saved on logout. |
|
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2005-03-09 : 15:46:57
|
| I see them in the Registered Servers X key. I will export this key and keep it until it happens again. Thanks Jason and Tara. |
|
|
|
|
|
|
Disappearing SQL EM registrations