April 28, 2017 at 10:36 am
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?
April 30, 2017 at 5:49 pm
You need to look at how the permissions are setup for the linked server, not just the permissions a user may have in a database referenced in a linked server. You also need to check the credentials for the data source used by the report.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply