Problem Linking SQL 2000 Servers

Hello -

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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
>SQl server does not exists or access denied

check if the server name, that you use to link is correct
also verify ability to access with the Username\pwd that you used...

What OS - windows 2003?
Make sure there are no firewalls or routers blocking in between the servers.

what do you get if you try and "telnet" into the remote server like this:


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.