Linked Server Error

[JayKusch]

Afternoon Folk ...

Have 2 SQL Server 2000 machines. One named APP_SERVER the other is AUSSQL. i am able to create a linked server from APP_Server to AUSSQL, which then enables me to see the tables and views of AUSSQL BUT when i create a linked server from AUSSQL back to APP_SERVER i have an error.

it looks like the linked server is created but when we try to expand the tables or views of the linked server we get the following error:

Error 17: SQL Server does not exist or access denied

could it be a difference in the MDAC versions?

Thanks

 

[timscronin]

What client utilities are enabled on the server that is the problem, should have TPCIP and multiprotocol. Also do you use DNS, if not add the entry of the server you can not connect to to a host file on this server. Simple test is to open up QA and try to do a trusted connection ot the other server