August 24, 2016 at 9:09 am
Hi,
I am getting the below error while running the query. Allow in process in unchecked as well. How to fix it.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "ADDCDB2P". OLE DB provider "MSDASQL" for linked server "ADDCDB2P" returned message "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'U.UPERSNX'.".
SELECT * FROM OPENQUERY(ADDCDB2P, 'select * from u.UPERSNX WHERE I_PERSN =1161526')
August 24, 2016 at 11:58 am
It sounds like there are not enough permissions for the account used in the linked server. Specifically, the account may not have correct permissions to the schema on the table it is being queried on. When you test the connectivity for the linked server, does it work with no errors?
August 25, 2016 at 2:29 am
Yes the test connection is successful. The same linked server i created on other server and it works fine. What kind of permission should i check upon ?
August 25, 2016 at 5:58 am
Since your query is a select, the account should only need db_datareader on the destination.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply