Wednesday, March 7, 2012

List of data mining techniques not populated - BI Studio hangs

From within the Business Intelligence Studio, I've created a data source and a data source view. Next, when I try to build a mining structure from a relational database, the studio hangs when it goes to the screen which lists the data mining techniques.

Has anybody come across this issue? What needs to be done to get further?

I'm using the June CTP of SQL Server 2005.

Thanks,
-GB.

In http://www.sqlserverdatamining.com I found a post talking about the same problem; the suggested fix was that a previous installation of Analysis Services be removed.

In my case, there was no previous installation of Analysis Services. However, there was an installation of SQL Server 2005 Express Edition, which the install program for SQL Server 2005 CTP detected, and asked me to remove (including a Beta of .NET version 2.0).

-GB.|||

A few questions:

Can you connect to your AS instance from SQL Mgmt Studio or another client?

Are you running a named instance? If yes, make sure that the SQL Server Browser service is functioning correctly.

Do you have network connectivity? There is a known issue with client-server connectivity when you're off the network.

|||Thank you for your reply, Raman.

I can connect to the AS instance from within SQL Management Studio. I can see the data source and data source views that I've already saved before starting with the data mining structure creation. I do not use any other client to connect to this instance.

I am using a default non-named instance.

About network connectivity: I have the TCP / IP stack running, but it is not (always) connected to a network. I also have the ZoneAlaram personal software firewall running. I've turned this off, but it still does not work.

Thanks,
-GB.|||This might be the result of a configuration/install bug. I would suggest uninstalling your June CTP version and moving to the RTM build.

No comments:

Post a Comment