Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue in Linked Server Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 5:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
I Have done the Linked server configuartion on Server 1
Server1 - ABCD
Server2 - XYZZ

Configured XYZZ on ABCD * ABCD on XYZZ

so after this when i execute the below query on XYZZ Server
select foo.agent_id
from [ABCD].db_Test.dbo.Students foo


It got executed.. when i am trying to run the query on ABCD
select foo.agent_id
from [XYZZ].db_Test.dbo.Students foo

Error comes

Msg 7314, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "XYZZ" does not contain the table ""db_Test"."dbo"."Students"". The table either does not exist or the current user does not have permissions on that table.








************************************
Every Dog has a Tail !!!!!
Post #1433743
Posted Thursday, March 21, 2013 9:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 3:36 PM
Points: 541, Visits: 1,044
I hesitate to suggest it but the error is self-explanitory? Make sure you've got the table right.. you also may want to enclose the table name in [] as it looks like you have a space there.

Are the two servers running the same version of sql?
Post #1433865
Posted Thursday, March 21, 2013 10:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 1,345, Visits: 2,528
Erin Ramsay (3/21/2013)
I hesitate to suggest it but the error is self-explanitory? Make sure you've got the table right.


That. Or the other part of the error about permissions. What type of security did you use to setup your linked server(current security context, specific account)? Does current user or specific user have permissions on the remote server?


Bob
-----------------------------------------------------------------------------
How to post to get the best help
Post #1433895
Posted Thursday, March 21, 2013 10:29 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 646, Visits: 1,850
Erin Ramsay (3/21/2013)you also may want to enclose the table name in [] as it looks like you have a space there.


don't think it's a space - it's an alias
Post #1433899
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse