SQL Query Invalid Object name via linked server

Question

When I try the following query from Server3

Select * 
from [server1].[database1].[dbo].[tableX]

I recieve an an error of

Invalid Object Name

But when I execute the same query from Server2 the query works. Both are MSSQL 2000

UPDATE: When i tried to query a different table on server1 from server3

Select * 
from [server1].[database1].[dbo].[tableY]

from Server3 it works. Its just tableX wont work

You need to research Linked Servers. Also, you need to seriously consider upgrading your environment. The extended lifecycle support for SQL Server 2000 ended 4.5 years ago. — S3S
– S3S, Commented Oct 4, 2017 at 13:03
is the linked server in both Server2 and Server3 refer to the same server ? How about user rights ? does the user in Server3 has access to the table in Server1 ? — Squirrel
– Squirrel, Commented Oct 4, 2017 at 13:15
Guys ive check the right and permission and its all good. Same with the linked Servers. But ive got an update. Please do check it — Jesun Bicar
– Jesun Bicar, Commented Oct 4, 2017 at 13:23

dbajtr · Accepted Answer · 2017-10-04 13:16:00Z

1

First check that tableX exists on the destination server then check that a linked server is present

Run:

SELECT *
FROM sys.servers;

On Server2 and Server3 and see if the results are the same. This will show name of the host server along with any other linked servers that may exist. The Microsoft Doc is HERE.

If there isn't a linked server set up on Server3 then create one, The Microsoft docs are HERE, but if you Google how to then there are plenty of guides out there.

And think about upgrading from SQL SERVER 2000 is was desupported April 2013

answered Oct 4, 2017 at 13:16

dbajtr

2,0442 gold badges16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query Invalid Object name via linked server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related