Home Forums Reporting Services Reporting Services 2008 Development Reporting Services Error on Linked Server Executing Stored Procedure - Permissions issue? RE: Reporting Services Error on Linked Server Executing Stored Procedure - Permissions issue?
Sue_H
SSC Guru
Points: 90860
More actions
April 30, 2017 at 5:49 pm
#1940523
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