Issue in Linked Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Issue in Linked Server

Issue in Linked Server

Rate Topic

Display Mode

Topic Options

Author

Message

OnlyOneRJ

Posted Thursday, March 21, 2013 5:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:31 AM
Points: 165, Visits: 463

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 !!!!!

Post #1433743

Erin Ramsay

Posted Thursday, March 21, 2013 9:29 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:03 AM
Points: 438, Visits: 808

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

Robert klimes

Posted Thursday, March 21, 2013 10:23 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:56 AM
Points: 893, Visits: 1,893

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
-----------------------------------------------------------------------------
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #1433895

David McKinney

Posted Thursday, March 21, 2013 10:29 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:02 AM
Points: 583, Visits: 1,612

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 »

Permissions