Web access Data Analysis

P

Participant

Hi,

I am facing a problem in Data Analysis through web access. At the beginning
when I used to connect to DB it used to show me an error stating that my
machine has not permission to access data source. After solving this problem,
now I am trying to connect again to my Project Server DB (Published DB) and
it shows the following error:
“The query could not be processed. The object could not be foundâ€

Regards
 
P

Paul Conroy

I'm confused as what you're trying to do, can you explain in more detail ?

Data Analysis Views use Analysis Services as the data source and not any of
the Project DB's.

For other queries you should be using the Reporting DB and not the Published
DB or Analysis Services.
 
P

Participant

In the Provider I am choosing: MS OLE DB Provider for SQL Server
In the Connection I am specifying the DB server and Reporting DB and still
faced the same problem. (the connection test was successful)
Am I missing something?

Regards
 
P

Paul Conroy

There is no dialogue to enter a provider in DA views, so I'm assuming your
doing something different.

Have you checked the permissions on the database. When accessing data via
PWA connections use the security identity of the SSP App Pool. If you're
creating a custom connection, then you will need to assign explicit
permissions to the datasource.
 
Top