I have a problem with Analysis Server:

When I try to Process Cube in Analisys Manager, ERROR:
Data source provider error: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified;IM002; Time:10/12/2004
01:04:42

Data source name exists and works fine.

There are two security environments in Analysis Services. When you create
the data source, you are using the services available on the machine where
Analysis Manager is running. However, processing is done by the service
itself on the Analysis Server; not the interactive account. This is a common
problem when you are doing remote administration (administering AS from one
workstation against a different server). The DSN and the ODBC provider, etc.
must be available on both machines and available to both the interactive
account and the service account used by the MSSQLServerOLAPService service.

Could that be happening in your case?
--
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.

"Araujo" <araujo (AT) secrel (DOT) com.br> wrote

I am using only one Windows XP SP2 machine with SQL Server 2000 SP3

Araujo

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> escreveu na mensagem
news:OqJ$ygp3EHA.1188 (AT) tk2msftngp13 (DOT) phx.gbl...

So you are running SQL Server 2000 Developer Edition Analysis Services on
your WindowsXP machine -- Everything on one machine. You create this data
source, create all of your dimensions (and you process them successfully),
and you create all of your cubes, but when you go to process the cubes you
get this error. Do I have it right?

A few additional questions:
1) What kind of ODBC provider are you using?
2) What type of DSN is it? System, File, Machine or what?
--
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.

"Araujo" <araujo (AT) secrel (DOT) com.br> wrote

Following the Analysis Manager Tutorial, I create, edit, design storage the
cube Sales.
When I try to Process Cube in Analisys Manager... ERROR!

Provider: Microsoft OLE DB Provider for ODBC Drivers
Type of DSN: User



"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> escreveu na mensagem
news:edy7kut3EHA.2568 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Dave,

Your second question was very important.
With System DSN I process the cube sucessfully.

Thank you.


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> escreveu na mensagem
news:edy7kut3EHA.2568 (AT) TK2MSFTNGP11 (DOT) phx.gbl...