Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help setting up a linked server

0 views
Skip to first unread message

pgorman16

unread,
Aug 24, 2001, 11:57:37 PM8/24/01
to
OK everyone,

I need some help. I thought that this would be fairly easy to do, But I
seem to be having problems. I am trying to set up a linked server so that I
can do a DTS job from my SQL Server(7.0) to another SQL Server(7.0).
I have the network name (the server is not on my local network),
I have the port number to connect to on the server,
I have the database name,
I have a login name and password,
but I can't seem to add the server correctly in the Enterprise
Manager.

I can connect to ther server programmatically using a connection string so I
know all of my data is correct

Can sombody PLEASE PLEASE PLEASE walk me through the correct way to make
this server available in the Enterprise manager

Thanks in advance

--pjg


0 new messages