Hi,

Thanks for the info.

I'm a little bit unsure on some of these questions such as the ports and firewall. As far as I know there are no restrictions in the firewall as I can connect to all the other servers in domain B although that is out of my area/control! As for the port I've RDP'd onto the server and in sql configuration manager I've had a look in the IP address tab in the TCP/IP section and for one instance (in the IP1 section) the port is 1433 but for the other it is blank, however for that instance in the IPAll section the TCP dynamics port is 3249?

How do I use the port number when setting up the linked server? I tried servername,1433 but it said no such host is known.

Andrew