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 |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2005-08-24 : 19:35:02
|
| Hi all, Just wondering is there any ways to export the reg setting of the SQL registrations? as in all the servers u set up in EM, or what will be the best way to move all my reg server to another server (including groups)? Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-24 : 19:46:15
|
| well, there used to be. But that turned out to be a security problem because passwords were located in there and they were in plaintext.Nowadays the data is encrypted. You can export the entire key, but when you import it to another server you will only have the groups you've defined. None of the servers will be listed because of the encryption thing.There is a SQL DMO scripted solution to this though. I'll dig around and post it when I find it.-ec |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-24 : 19:49:14
|
| thanks, i'm only using NT auth, so shouldn't have the passwd issue :) I read sql 2005 can do that, so hopefully 2000 can :)I'll be waiting for your DMO solutionThanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-24 : 20:32:05
|
| Thanks, it works fine for 1 level group, but I have 2nd level groups, guess I need to mod the code to get it to work for me :)thanks anyway. |
|
|
|
|
|
|
SQL registrations setting