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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sharing EM's registration?

Author  Topic 

LeoC
Starting Member

37 Posts

Posted - 2004-12-27 : 11:44:50
If EM is an application [as I read prev.], where would the contents of one's registration go to?
Can they be shared?
if a DBA team has a PC to use for looking at the servers BUT we don't login under a common 'dba' account/login (domains, permissions,sec.,etc...)
All of our registrations, which should be the same, are some where in that PC, right?
could we just grabbed it and copy it from profile to profile?
Is there an easy solution to this issue?

Cheers!

lec.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-12-27 : 14:23:57
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43879&SearchTerms=enterprise,manager,registration



MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

LeoC
Starting Member

37 Posts

Posted - 2004-12-28 : 13:13:29
Thanks for the reply! So really there isn't a clear "clean" way to do this...I mean dealing with the registry right off makes this 'not microsoft recommended'.
Plus I've already got two PCs with different reg.-key and/or info. in then, but what's the use of a reg.-key?
The good point would've been to make the "sharing" easier. It seems that [as it happen to two of our DBAs] if you loose the EM registration, pretty much you'll be better off 're-entering' the info. from the keybd. no any kind of shortcut?

sorry, didn't mean to sound too pessimistic!
Thanks,


lec.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-28 : 15:55:35
Modifying the registry via a reg file is the only way to do this without manually doing it via EM.

Tara
Go to Top of Page

LeoC
Starting Member

37 Posts

Posted - 2004-12-28 : 16:02:10
Tara, what/how do you mean 'via a reg' file?

lec.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-28 : 16:09:24
Regedit allows you to export keys from the registry. Go to the specific key, highlight it, select file then export. Save it as a reg file. Then test this on a machine with no EM registrations: move the reg file to this machine, double click on it. Check EM registrations. If it works ok, then do the same to the other machines.

I've done this several times, like when our machines get refreshed.

Tara
Go to Top of Page

LeoC
Starting Member

37 Posts

Posted - 2004-12-28 : 16:12:26
thanks!
have you ever done cross OS versions? or should not even attempt to get into that one?

lec.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-28 : 16:15:12
Yes I have and it did not work from Win2k to NT4. We had to manually make some changes to the reg file. It's been over 3 years since this was done though, so I don't remember what changes we did.

Tara
Go to Top of Page

LeoC
Starting Member

37 Posts

Posted - 2004-12-28 : 16:22:10
hey, I'll be surprised if much have change in that area! but I guess if I have the time I'll test W2K to XP pretty soon!
Thanks again for your inputs!

lec.
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-12-28 : 17:46:37
You could also store the EM registrations in a common location. You could then add EM entries in each computer with a batch file. You can also use SQL Server using the reg read and write procs, although I don't know that I would recommend that. :)

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

LeoC
Starting Member

37 Posts

Posted - 2004-12-28 : 17:49:51
that sounds a bit more for what I have actually time to... definitely, challenging 'though!

lec.
Go to Top of Page
   

- Advertisement -