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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-10 : 09:27:54
|
| dave writes "Is there a way using T-SQL to register a server for use in enterprise manager. We have 450 servers and trying to set them all up in Ent. Mgr. is a PAIN.thanks" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-10 : 09:52:20
|
| nope.the good news is anything you would do with those registered servers you can do in qa with t-sql. so you really don't need to register them. (have you seen how much memory em eats up on your client box? I can't imagine 450 registered servers....)<O> |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-10 : 09:58:23
|
| If you really HAD to do it (I agree with Page though, it's probably not worth it) you can try 2 options:1. Check Books Online under "Building SQL Server Applications", "SQL-DMO", there are objects and methods you can use in a program to register servers. I would imagine by the time you wrote the code to do it however, you'll be able to complete the whole thing by hand.2. Set up all 450 servers on one machine, then export the registry key under HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server, then import it into the registries of the other machines. Be advised that if there is even the SLIGHTEST difference in how Enterprise Manager is configured on the other computers, you can FUBAR the machine by doing this. |
|
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-10 : 10:11:02
|
| Just a minute guys .... all it takes is for one to choose a non c:\mssql path to screw the machine ... Default buffers settings may also depend on machine spec so Take Note!Daniel Small CEOwww.danielsmall.com |
|
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-10 : 10:11:14
|
| Just a minute guys .... all it takes is for one to choose a non c:\mssql path to screw the machine ... Default buffers settings may also depend on machine spec so Take Note!Daniel Small CEOwww.danielsmall.com |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-06-10 : 10:55:40
|
It shouldn't be too terrible if you're using NT Auth or the same account on each server. Use the registration wizard, highlight all of the servers in the list, click add, click next, choose your auth mode, click next, choose a group, click next, click finish. If you're using SQL accounts with different passwords then I think you're hosed.  Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
|
|
Register Servers