I am using MS SQL Server 2012, and I am trying to extract data from a Linked Server database.
In SQL Server management studio, I can see the linked server. I can browse the database on the server. I can see all tables in database.
When I try and query a linked table
select * from openquery(somedatabase,'select top 4 * from test')
I get error:
The OLE DB provider "MSDASQL" for linked server "somedatabase" indicates that either the object has no columns or the current user does not have permissions on that object.
When I try to script the table.. right_click on the linked table, Script table as, Select to, New Query Editor window, I get same error.
Any help would be greatly appreciated.
I referred to following posts but it did not help.