Error "Provider cannot be found. It may not be properly installed." after deploying ap

hello folks

i have recently started to work with the analysis services and i am having some problems.

i have made a web application that for now just tries to connect to an analysis server.

The server is installed on an xp sp 2 system.

for testing, i used my local computer, which is running also win xp sp2. After deploying, the application can connect to the AS server on the other machine. the problem occurs when i try to deploy the applicatuion on the production server, which is running win 2k3 server on 32 bit. When deploying, i use the same connection string, so it should try to connect to the AS server installed on a win xp sp2 system.

The first thing that came to my mind was to check the MDAC versions, be cause of the message: "Provider cannot be found. It may not be properly installed."

on my computer, where the application worked ok, the version is MDAC 2.8 SP 1 Windows XP SP 2

on the win2k3 server, the MDAC version is : MDAC 2.8 SP2.... i thought it was the version of the service pack, so o searched for the update of MDAC 2.8 SP1, trying to install mdac 2.8 sp2 to see if i was to see the same error, but i found that mdac 2.8 sp2 is only for win2k3 server, and for win xp is mdac 2.8 sp1, according to this link: http://support.microsoft.com/default.aspx/kb/884103

Now i got confused and have no clues how to make this work...

Can anybody give any hint?

?|||

The Analysis Services provider is not part of the core MDAC, it is available for download from the feature pack at http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

look for the downloads under Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Error - Analysis Services Processing Task

We have an Integration services package that executes a few TSQL tasks, then processes an Analsys Services database. This has been in production for about three weeks now and twice the package has failed with this error from the event log:

Event Type: Error

Event Source: MSSQLServerOLAPService

Event Category: (289)

Event ID: 3

Date: 7/11/2007

Time: 1:48:59 AM

User: N/A

Computer:

Description:

OLE DB error: OLE DB or ODBC error: An error has occurred while establishing a connection to the server.

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server

does not allow remote connections.; 08001;

Communication link failure; 08S01;

TCP Provider: An existing connection was forcibly closed by the remote host.

; 08S01.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I don't think that this error is accurate because the package and Analysis Services are on the same server.

Also, this does not happen in our development environment. Any help is appreciated.

Thanks,

Brian

Sorry to side track a bit, but processing cube using SSIS is not the most effiecent way of prcoessing a cube. Can't remember the specifics, but if you can I would get the sql agent to process the cube.

Cheers

Matt