I am creating a data source in MS Analysis Services 8.0, this data
source is using ODBC driver to connect to MySql database.

Everything goes fine, from creating the dimensions to browsing the data,
until I process the cube and it starts giving me this error message:
"Data source provider error". I have tried creating another cube with
another MySql database, but it still gives me the same error when I
process the cube.

Can MS Analysis Services connect to MySql database? If it can not, then
why I am able to see the tables and create dimensions? If it can, then
why I am always getting this error?

Any help is appreciated.

*** Sent via Developersdex http://www.developersdex.com ***

What I think is happening is actually quite common, i.e. a problem where
processing "looks" different from interactive browsing with Analysis
Manager. The actual processing of an object is NOT done by Analysis
Manager -- it is done by the msmdsrv service. My guess is that there is some
setting, e.g. domain account for the service logon, or something like that
which is causing problems.

If this was SQL Server, a similar thing would be caused by having the
msmdsrv service using Local System as the logon for the
MSSQLServerOLAPService service and attempting to access a SQL database on
another machine. The Local System has administrator permissions on the local
machine but is not allowed network access -- so the service cannot connect
to the remote SQL Server. A similiar configuration problem might be the root
cause here.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Tarek Soukieh" <tsoukieh (AT) hotmail (DOT) com> wrote

Thanks, but I do not know what configuration do I have to change?

Note that MySql database exist on the same machine that MS Analysis
services is on.



*** Sent via Developersdex http://www.developersdex.com ***