Cannot connect to OLAP database using Credential Stored in report server

Hi guys,

I'm having problem regarding connecting to OLAP Database when I use the Credential stored in the Report Server. When I tried using the Credential stored in the Report Server connecting to OLTP database, It works fine.

Below is the error I'm geting when connecting to OLAP Database.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DS_Project88_OLAP'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

There are several reasons why the connection could fail. I recommend to check the report server logfile for more information on the exception from the data provider, or enable remote errors (see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230593&SiteID=1) to turn on detailed errors for all users.

-- Robert