Problems with Scheduled Emailing on Datasources

I'm trying to set up my report server to send reports by email to my
management team in the company but I'm unable to do so. It seems like the
report server is able to send hyperlinks but not any other format. The error
I receive is strangely these,
"Cannot create a connection to data source 'Datawarehouse'"
"Database 'Datawarehouse' does not exist"
This "Datawarehouse" is a Analysis Service datasource. Below is my
connection string
Connection Type = OLE DB
Connection String
Provider=MSOLAP;Client Cache Size=25;Auto Synch Period=10000;Data
Source=AP5184;Initial Catalog=Datawarehouse
I have no problems accessing the reports from the web browser but why is RS
reporting that the datasource cannot be found? Anyone got any idea?
Any advice is appreciated.has anyone got any advice to this problem?
"Nestor" <n3570r@.yahoo.com> wrote in message
news:O1b3Q7bVFHA.1452@.TK2MSFTNGP14.phx.gbl...
> I'm trying to set up my report server to send reports by email to my
> management team in the company but I'm unable to do so. It seems like the
> report server is able to send hyperlinks but not any other format. The
> error I receive is strangely these,
> "Cannot create a connection to data source 'Datawarehouse'"
> "Database 'Datawarehouse' does not exist"
> This "Datawarehouse" is a Analysis Service datasource. Below is my
> connection string
> Connection Type = OLE DB
> Connection String
> Provider=MSOLAP;Client Cache Size=25;Auto Synch Period=10000;Data
> Source=AP5184;Initial Catalog=Datawarehouse
> I have no problems accessing the reports from the web browser but why is
> RS reporting that the datasource cannot be found? Anyone got any idea?
> Any advice is appreciated.
>
>