Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Linked server-Error

Author  Topic 

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2002-06-01 : 09:14:34
I am trying to connect Server2 from server1 using Linked server.
I have set up login issues for the connections.
It gives the following error:
"Sql Server does not exist or acces denied"
Both are Sql Server 2000.
Thanx..........

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-01 : 21:14:05
When you are on the console of Server1 (not your PC but actually at the server console) can you connect to Server2 using Query Analyser ?
Can you ping and net view Server2 from Server1 by name ?

HTH
Jasper Smith

Go to Top of Page
   

- Advertisement -