SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Issue in Linked Server


Issue in Linked Server

Author
Message
OnlyOneRJ
OnlyOneRJ
Old Hand
Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)Old Hand (348 reputation)

Group: General Forum Members
Points: 348 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.
w00t

************************************
Every Dog has a Tail !!!!! :-D
Erin Ramsay
Erin Ramsay
SSC Eights!
SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)

Group: General Forum Members
Points: 821 Visits: 1099
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?
Robert klimes
Robert klimes
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2685 Visits: 3422
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
David McKinney
David McKinney
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1309 Visits: 2090
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search