I have an program thats runs over linked servers. For the most part I haven't had trouble linking all the servers to our main server, however, I have two machines that refuse to link.
I get the error "SQl server does not exists or access denied"
Win xp, sql server 2000 SP3
TCP/IP and Named Pipes are enabled on both - option to dynamically create port is also set. It is not set to start up in single user mode and the option to allow other users to connect to the server is checked. I am using mixed mode autentication and trying to connect the link with a SQL login that has full permissions to all DB on the remote server. Any ideas?