I am trying to run a report through SSRS 2008 web interface. The credentials that are being used to execute the report are through a service account. The point of using a service account was so that the subscriptions feature could be used.
However, two particular reports connect directly though a linked server to an excel workbook. I get the following error when I try to execute the report:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "YTWCHECK" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "YTWCHECK".
How can I correctly add my service account to the linked server?
View Complete Post