OLAP Datasource -- sql server reporting services

sql server reporting services : OLAP Datasource

Lutz.Morrien
7/26/2004 2:29:10 AM

Sounds like you do not have the rights of your datasource
set correctly.

Check your datasource.

HTH

ashvsaod
7/26/2004 12:41:28 PM

2nd Attempt sorry...
Provider=MSOLAP;
Data Source=mshfsql;
Initial Catalog=SLA_LIVE

I receive the following error:

An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
a.. Cannot create a connection to data source 'Man_Par'.
(rsErrorOpeningConnection) Get Online Help
a.. Database 'SLA_LIVE' does not exist.
What am I doing wrong?

Help.

ashvsaod
7/26/2004 1:57:53 PM

One more thing. The report functions fine from within the development
environment.. But once deployed to the report server it fails.
[quoted text, click to view]

Will
7/27/2004 9:22:52 AM

I had the same error - you need to set a database role in Analysis Services
Manager for the cube you are using.

[quoted text, click to view]

ashvsaod
7/28/2004 9:51:51 AM

Of course... Thanks for that Will.. You have saved the day... Cheers...

Problem solved.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn