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 ««12

Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "CHIMSSQLDEV" does not contain the table ""ArrowProdDB"."dbo"."sysfiles"".... Expand / Collapse
Author
Message
Posted Tuesday, November 19, 2013 8:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 4, 2014 7:58 AM
Points: 2, Visits: 114

The OLE DB provider "SQLNCLI10" for linked server "A" does not contain the table "DatabaseA""."dbo"."TableA"".
The table either does not exist or the current user does not have permissions on that table.

E.G.

Connecting from server A to Server B using a linked server

Example

From Server B

select *
from [A].[DatabaseA].dbo.TableA

error message:

The OLE DB provider "SQLNCLI10" for linked server "ServerA" does not contain the table ""DatabaseA"."dbo"." TableA "".
The table either does not exist or the current user does not have permissions on that table.


Check the login context for linked server on server B

Server Objects
Linked Servers
[ServerB]

Right click
Properties
Security
REMOTE LOGIN username..----------------------------------------------------------*


Then go to Server A

Go

Security
Logins
Username from --------------------------------------------------------------------------* above

Make sure this Username has access to Database being queried above. (DatabaseA)

Give DBO access or atleast DATAREADER..
Post #1515582
Posted Tuesday, November 19, 2013 8:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 4, 2014 7:58 AM
Points: 2, Visits: 114


The OLE DB provider "SQLNCLI10" for linked server "A" does not contain the table "DatabaseA""."dbo"."TableA"".
The table either does not exist or the current user does not have permissions on that table.

E.G.

Connecting from server B to ServBr A using a linked server

Example

From Server B

select *
from [A].[DatabaseA].dbo.TableA

error message:

The OLE DB provider "SQLNCLI10" for linked server "ServerA" does not contain the table ""DatabaseA"."dbo"." TableA "".
The table either does not exist or the current user does not have permissions on that table.


Check the login context for linked server on server B

Server Objects
Linked Servers
[ServerB]

Right click
Properties
Security
REMOTE LOGIN username..----------------------------------------------------------*


Then go to Server A

Go

Security
Logins
Username from --------------------------------------------------------------------------* above

Make sure this Username has access to Database being queried above. (DatabaseA)

Give DBO access or atleast DATAREADER..
Post #1515589
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse