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