I've set up a virtual development domain, where I'm running SQL Server
2000 Dev. edition (SP3), Analysis Services (Dev. edition, sp3) and
Reporting Services (sp1).

I'm trying to use the Foodmart samples from the Reporting Services
installation. I can connect to the SQL Server, so the samples using
SQL statements work well. But I can't connect to the Foodmart cube.
Error message when I go to the data tab in "Foodmart Sales.rdl":
"A connection cannot be made to the database.
Set and test the connection string.
No error information available: E_Fail (0x80004005)."

This is my connection string
Provider=MSOLAP.2;Client Cache Size=25;Auto Synch Period=10000;Data
Source=192.168.1.202;Initial Catalog=FoodMart 2000
I've added the credentials of an account that is domain admin and
added to the OLAP administrators in the Credentials pane.
WHen I try to do "Test connection", I get this error message:

"Microsoft Data Link Error:
Test connection failed because of an error in initializing provider.
Unspecified error. "

I'd really like to not have to install more than the client tools on
my work station, but let the development server have all the
components.

Any help appreciated!

Sincerely,
Kaisa M. Lindahl

To connect to a server in different domain you will need to use http
connection to Analysis Services (Analysis Services http connection is only
available for Enterprise Edition of SQL Server). Verify that you have
Enterprise Edition of SQL Server on the Analysis Server box that you are
trying to connect to. Then use http connection in your connection string
like so:

Provider=MSOLAP.2;Data Source=http://192.168.1.202;Initial Catalog=Foodmart
2000;Roles=All Users;Client Cache Size=25;Auto Synch Period=10000

Regards,
Ilona Shulman

"Kaisa M. Lindahl" <kaisaml (AT) hotmail (DOT) com> wrote