Groups | Blog | Home
all groups > sql server new users > december 2006 >

sql server new users : dts connection


SAC
12/26/2006 12:00:00 AM
I'm using 2000 on a remote server. I'm having a problem when making a new
dts package and putting in the server connection.

If I use Remote Desktop and logon to the server I then use "Local" as the
name of the server in the connection and it works fine.

However if I run Ent. Mgr. from a remote computer that connects to the
server it doesn't have it as "local" so I've been putting in the ip address
and it works fine.

The problem is when I use Remote desktop and put in the ip address it times
out.

Any ideas?

Thanks.

AlterEgo
1/4/2007 5:37:02 PM
SAC,

Try using the computer name instead of local and the IP address. Your domain
server should be able to resolve it.

It sounds like there is some funky IP layering or NAT going on. Logon to the
server using Remote Desktop, open a command line window and type the
following:

ipconfig

See if that IP address is the same as the one your using. If not, try that
using that one.

-- Bill


[quoted text, click to view]

TW Server
1/8/2007 9:20:39 AM
Thanks!
[quoted text, click to view]

AddThis Social Bookmark Button