Re: SQL Server 2000 linked server problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

The error is "SQL Server does not exist or access denied" which means it
cannot connect.
I know all of it works - it works from EM on the server itself and doesn't
from any remote client.
I have tried RPC settings and that does not work.

Apparently this happens "once in a while", and it takes a reboot to fix it.





"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:%23v9K5rLSIHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
frankm,

What error are you getting? That might reveal what the problem is. In
general: Check the security tab of the linked server properties if it is
security context error. You might also check the Server Options for how
RPC and RPC OUT are set.

Out of curiousily, have their been any changes to your network
infrastructure for the purpose of making the network more secure?

RLF

"frankm" <frankm@xxxxxxxxxxxxxxxx> wrote in message
news:%jRcj.1769$pr6.1313@xxxxxxxxxxxxxxxxxxxxxxx
This is SQL Server 2000 sp3a.

I have linked servers that have been working for a fairly long time.

If I am on the server (TermSvc), I cann connect and test through the
linked server successfully.

If I am initiating this from any workstation or application off the SQL
Server itself, the linked server connection fails.

Any ideas???

frankm





.

Relevant Pages

  • Re: T-SQL is not quite there yet
    ... StoredProc1 does the same thing to insert data from StoredProc2. ... I assume a lot of this has to do with that the linked server may not ... SQL Server instance, one could surely wish that SQL Server had special ...
    (microsoft.public.sqlserver.programming)
  • Re: Support team security
    ... to view Linked Server properties (this is a tool requirement not a SQL ... Jasper Smith (SQL Server MVP) ... SQL Server Agent Job Schedule and Job history ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2000 linked server problem
    ... of SQL Server 2000 to fix some known bugs on the SQL Server side. ... the both two SQL Server instances (local and linked server), ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)
  • Re: Setting up Linked server to MsAccess
    ... This will set the security so anyone using the linked server ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Re: MAS90
    ... To set up a linked server from SQL Server 2000 to MAS90 using Enterprise ...
    (comp.databases.ms-access)