Friday, March 23, 2012

How to register a server automatically in Enterprise Manager

Hi
I know how to register a sql server instance in Enterprise
Manager manually (by right clicking on an SQL Server group
and choosing "New SQL Server registration" and following
the wizard.
But how to do this automatically in a script or using
osql/isql?
I know of the system stored procedures: "sp_addserver"
and "sp_addlinkedserver", but - according to my
understanding - this is another type of registration
(that is a registration of a remote/linked server so sql
statements can be used to query databases on the
remote/linked server).
What I am looking is something different (at least I
think): the ability to automatically do what the wizard
does so I can register a server in the folder structure of
the left pane i the Microsoft Management Console.
Is it some kind of MMC statement that has to be used?
yours truly
Persson
You could create your own appication using Distributed Management Objects
(DMO).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Persson" <jpn_1966@.yahoo.dk> wrote in message
news:536a01c4c667$129a26c0$a301280a@.phx.gbl...
> Hi
> I know how to register a sql server instance in Enterprise
> Manager manually (by right clicking on an SQL Server group
> and choosing "New SQL Server registration" and following
> the wizard.
> But how to do this automatically in a script or using
> osql/isql?
> I know of the system stored procedures: "sp_addserver"
> and "sp_addlinkedserver", but - according to my
> understanding - this is another type of registration
> (that is a registration of a remote/linked server so sql
> statements can be used to query databases on the
> remote/linked server).
> What I am looking is something different (at least I
> think): the ability to automatically do what the wizard
> does so I can register a server in the folder structure of
> the left pane i the Microsoft Management Console.
> Is it some kind of MMC statement that has to be used?
> yours truly
> Persson

No comments:

Post a Comment