I am trying to implement Linked Servers. but I am having problems establishing connection to my two servers:
I have already created the linked server SRV-AXDEV under SRV-APP1 with the following configurations:
This is the list of my databases in SRV-AXDEV
But when I try to run this query:
Select * from [SRV-AXDEV].[GFII_AX2009_DB_LIVE].[dbo].[InventTable]
I keep on getting this error:
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "SRV-AXDEV" does not contain the table ""GFII_AX2009_DB_LIVE"."dbo"."InventTable"". The table either does not exist or the current user does not have permissions on that table.
I hope you could help me with this problem.
Thank you very much!