I am having a problem in the Enterprise Manager while
trying to use DTS to convert my database into a
warehouse. I was following a tutorial for building
warehouses, and reached the point in which I dragged the
OLAP cube into the Analysis Services Processing Task
window. When I attempt to open up my SQL server in
the "Select Object to process" pane, it thinks for about
30 seconds, and then comes up with an error box. It
states: "Unable to connect to server".

This server is running on my PC, I have tried connecting
with localhost box checked, and without. I also seem to
have connection issues when tryign to process the sample
Foodmart cube in a different tutorial, yet other SQL
functions work fine. I am able to use the database in
Visual Studio, and browse through it in the Enterprise
manager. It seems that only the Analysis services are
having trouble.

I am running SQL server 2000 with service pack 3a, with
the Analysis services installed.

Any thoughts? I also have Data Sources(ODBC) configured
in the same way shown in the tutorial.

Thanks,
Michael Kr

Is the user that you run the package under a member of OLAP Administrators
NT group on your Analysis Server box?

Regards,
Ilona Shulman

"Michael Kr" <anonymous (AT) discussions (DOT) microsoft.com> wrote