add linked server problem

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

Hi, there,

I have two SQL Server 2000, which are SQLA -- with SAN connected; SQLB --
just a bald SQL Server.

I want to set up linked server from SQLA , so I can run query like "select *
from SQLB.dbname.dbo.tablename". The command I use is

sp_addlinkedserver @server = 'SQLB'

After I ran this code, I span the "Linked servers" node of Enterprise
Manager, I saw an image of a linked server named "SQLB". Then I run the
query "select * from SQLB.dbname.dbo.tablename" from Query Analyzer of
SQLA, I got the following errors

Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.

I'm the system administrator of the two servers, and the account I ran the
query is sys admin account. I don't know why the command failed. I drop the
linked server and readd the linked server again. I got the same result.

Who can help a bit?

Thanks so much in advance,

Jamie


.

Relevant Pages

  • Re: SQLDumpExceptionHandler
    ... Uri thanx for the reply, yes i've created a linked server but did'd ran the ... command the you gave, i runned that command and its still the same thing:S ... >> the strange thing is that if i work with the DB in local mode the error ...
    (microsoft.public.sqlserver.programming)
  • Re: IF EXISTS
    ... (select * from sysservers where srvname like ... 'YourLinkedServerName') ... >create linked server. ... Any command? ...
    (microsoft.public.sqlserver.clients)
  • IF EXISTS
    ... I wanna check the linked server is exist then do nothing and if not then ... Any command? ... EXEC sp_addlinkedserver 'FASAT\FASATBASE' ...
    (microsoft.public.sqlserver.clients)
  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • Re: Microsoft Excell Connection
    ... Use your linked server to Access then as the source by adding a SQL Server ... You should be able to add an Access Connection to a secured Access MDB ... properties enter the location of your system database. ...
    (microsoft.public.sqlserver.dts)