sql server reporting services: OLAP OLE DB Data Source Problem -- sql server reporting services

OLAP OLE DB Data Source Problem

Devon
9/22/2005 9:56:03 AM

sql server reporting services:

I am having a problem with my OLAP reports where I can execute the report if
I am running it from the server itself or through my machine within visual
studio development environment but when I execute the report from my machine
through the reporting services web site I receive an error

"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'OlaptestDB'.
(rsErrorOpeningConnection) Get Online Help
Database 'OlaptestDB' does not exist. "

Here is my connection string:
Provider=MSOLAP.2;Client Cache Size=25;Data Source=myServer;Auto Synch
Period=10000;Initial Catalog=OlaptestDB

RE: OLAP OLE DB Data Source Problem

johnE
9/23/2005 7:44:07 AM

I had this same problem. The problem is the users don't have acces to the
cube. Go into Analysis services and add the users you want to have access to
the report to the cube browser role.

[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 in the sql server reporting services group.