March 9, 2011 at 8:31 am
Using 2005 SSRS, and have deployed various reports to reportserver. In an attempt to 'clean things up' our SL guy suggested we change to Shared Data Resources in the reports. This was done, tested, deployed and can execute.
The Shared Data Resources use an SA account and Use as Windows credentials when connecting to the data source.
We wish to use Snapshots, and when we set them up, we receive the following when attmpting to view the reports in rportmanager or reportviewer - The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)
When we attempt to Check the box Create a report snapshot when you click the Apply button on this page, when setting up the snapshot, we receive
"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot impersonate user for data source 'xxxxxxxxxx'. (rsErrorImpersonatingUser) Get Online Help
Logon failed. (rsLogonFailed).
Have checked everything I know to check, any help much appreciated. Thanks in advance:crying:
March 17, 2011 at 3:05 pm
The first thing I would do is copy one of the dataset queries into SSMS. Then at the very top of the query I would put
EXECUTE AS LOGIN = 'DomainName\UserName'
Where DomainName is the domain of the account that runs the report, and UserName is the username. Then execute your query. If the query fails, you do not have SQL Server permissions set up properly for the user under which the reports are supposed to execute and the failure notice will be more specific than the failure on the Report manager.
If that doesn't work, then I would go to the data sources in the Report Manager and make sure the account and password were set up properly there. By default BIDS will not overwrite data sources that are already deployed, so you may not have deployed the new data source definitions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply