March 21, 2013 at 5:55 am
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
March 21, 2013 at 9:29 am
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?
March 21, 2013 at 10:23 am
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?
March 21, 2013 at 10:29 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply