Hi Meg,

You can register in EM using an ip address, does not have to be a name.

And the answer to your question is, yes, it can be done. You may not require linked servers (depends on your overnight SPs).

P

-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] Monday, December 15, 2003 10:20 AM
To: LazyDBA.com Discussion
Subject: off sight server...


Hi there,

i have had a request from a developer...here it is:

'I am working on a project that will involve the transfer of data to and fro a Remote Server (Windows 2000), that runs SQLSERVER. For me to login to this server I am able to do it via the 'Remote Desktop Connection' on my XP Machine.

What I would really like to do is setup within 'Enterprise manager' of this remote server a new Registration/Server Group' with 'OFSSQL ITS as the database' as so I can create an overnight run to run various 'SP's' to do the various data transfers.

The big question is CAN WE DO THIS. Is there some way of setting this up given we know the variious IP address etc etc. '

has anyone got any ideas of how this can be done?? i can only seem to register a server if I have the actual server name (we have the IP address). i've never used linked servers before and not sure if that would be able to do it either...

any help is well appreciated!

Meg



**********************************************************************
We cannot accept any liability for any loss or damage
sustained as a result of software viruses. It is your
responsibility to carry out such virus checking as is necessary before opening any attachment to
this message.

The information in this email and any files transmitted with
it may be of a confidential nature and is intended solely for
the addressees. If you are not the intended addressee, any
disclosure, copying or distribution by you is prohibited and
may be unlawful.

www.ofsted.gov.uk
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page