Connecting to a remote SQL Server

#1

On a remote server we have to instances of MSSQL Server 2000, one of them
being the default (local) the other has the name SN/EL4E, where SN is the
name of the server.
In Enterprise Manager on my desktop I have a Server Registration for (local)
having as name the IP address of the remote server.
I want now the create a Server Registration for the second SQL server. What
name should I use?
Thank you very much,
Dan

#2

Where does DTS fit in here?

In any event

Have you tried registering as SN/EL4E ?
Have you tried as <IP address>\<Instance Name> ?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"dan" <dea (AT) deamon (DOT) com> wrote

Quote:

On a remote server we have to instances of MSSQL Server 2000, one of them
being the default (local) the other has the name SN/EL4E, where SN is the
name of the server.
In Enterprise Manager on my desktop I have a Server Registration for
(local)
having as name the IP address of the remote server.
I want now the create a Server Registration for the second SQL server.
What
name should I use?
Thank you very much,
Dan

#3

Quote:

Where does DTS fit in here?
What do you mean?

Quote:

Have you tried registering as SN/EL4E ?
Yes, with both SN = the computer name (just a try!) and the"full server

name" (DNS) i.e.: "SD.abc.de.net"

Quote:

Have you tried as <IP address>\<Instance Name> ?
Yes, if <instance name> is "SN/EL4E" which is used by SQL Server Service

Manager under "Server".
Is there another <instance name>?
Thanks again,
Dan

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

Where does DTS fit in here?

In any event

Have you tried registering as SN/EL4E ?
Have you tried as <IP address>\<Instance Name> ?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"dan" <dea (AT) deamon (DOT) com> wrote in message
news:%23LAQCMKmEHA.3760 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
On a remote server we have to instances of MSSQL Server 2000, one of
them
being the default (local) the other has the name SN/EL4E, where SN is
the
name of the server.
In Enterprise Manager on my desktop I have a Server Registration for
(local)
having as name the IP address of the remote server.
I want now the create a Server Registration for the second SQL server.
What
name should I use?
Thank you very much,
Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Connecting to a remote SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Connecting to a remote SQL Server - 09-12-2004 , 03:32 AM

Re: Connecting to a remote SQL Server - 09-12-2004 , 03:37 AM

Re: Connecting to a remote SQL Server - 09-12-2004 , 07:53 AM