How to create a link server: target is SQL server 2000 on a SQL server 2008
The target is a SQL server 2000 on remote host with firewall. Is it possible to create a link server on my local SQL server 2008 SSMS? If yes, what should I pay attention to? And what ports should be open too? Thanks.