Hi there
We have Reporting Services webpage which processed accounts data from a SQL Server 2008 database and then loads this via a stored procedure
into an Access Dimensions SQL Server Database.
We use linked servers for the Access Dimensions server and RPC properties are set to true. Now we can click on Linked Servers and
query tables and views on it in sql server management studio.
However when a reporting services page tries to execute a stored procedure to read from a linked server table, we get the folllowing
error message:
An error has occurred duringreport processing. (rsProcessingAborted)
Query execution failed fordataset 'Data'. (rsErrorExecutingCommand)
The OLE DB provider"SQLNCLI10" for linked server "192.168.194.139" does notcontain the table""PARAccounts"."dbo"."sys_currency"".
The table either does not exist or the currentuser does not have permissions on that table
Now the table does exist and we can query.
Further the SQL user which is running the SSRS page , has the following permissions set on the database on the linked server:
- db_datareader
-db_datawriter
-db_executor
Any ideas on why this might be happening?