Analysis Services 2005: "OLE DB error: OLE DB or ODBC error : Access denied" using an

Hi,

The source DB is in Oracle 9.i . I use the native pilot from Oracle. The connection test is OK. I can also explore the data in the Data Source View whithout any problem. But when I try to process the dimension, I get the error message "OLE DB error: OLE DB or ODBC error : Access denied.." . I tried with the Native pilot from MS for Oracle but got the same result.

Could anyone help me ?

Rg.

In your datasource try to use Microsoft OLEDB Provider for Oracle or .NET Oracle Client Data Provider.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Edward, thanks for the fast answer.

with the MS provider and had the error :|||

During deployment of dimensions ( and cubes as well ) Analysis Server tries to process these dimensions. And for that it need to read data from Oracle.

The problem looks like related to the configuration of Oracle client. Also a good idea to check access permissions to Oracle database. See also if changing service account for the Analysis Server solves your problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edwards,

I changed the service account in the "SQL server configuration manager", for Analysis services and now it works fine :D

Thanks for your help,

Sbastien