"Michael Kr" <anonymous@discussions.microsoft.com> wrote in message
news:101001c4acb9$cac657e0$a301280a@phx.gbl...
> 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