Data mining in excel error. - cannot create model on sql AS instance.

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I am trying to play with the data mining in excel, but get an error on cannot create model on current instance.

I guess it is related with my SQL analysis or OS edition.

Here is what I have
1. Windows xp sp2
2. Excel 2007 with Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007
3. SQL20005 developer edition with SP2 (include analysis service and I created a database there already).
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Exact error message:
HighLight Exceptions:
Error (Data mining): Session mining objects (including special data source views used to process data mining dimensions) cannot be created on this instance.

Yours,
Yulin
.

Relevant Pages

  • Re: How to see sql 2005 dataming models in excel
    ... Exactly what kind of functionality do you want in Excel? ... Visualization of models? ... If you look in my book "Data Mining with SQL Server 2005" there is a chapter ...
    (microsoft.public.sqlserver.datamining)
  • Re: How to see sql 2005 dataming models in excel
    ... Excel doesn't currently have the same level of native support ... for Data Mining as it does for OLAP. ... the free Feature Pack for SQL Server 2005 Feature Pack ... SQL Server Data Mining ...
    (microsoft.public.sqlserver.datamining)
  • Re: Data Mining Addins for office 2007 Question
    ... Table Tools (and Analyze, which is part of Table Tools) show only when you ... click inside an Excel table. ... I downloaded Data Mining addins for office 2007 from below web site. ... I am assuning it suppose to install 3 different ...
    (microsoft.public.sqlserver.datamining)
  • Re: Third-Party Tool Selection using SSAS - Any Ideas???
    ... Excel is a great client tool for SSAS 2005. ... With SQL Server 2005 SP2 there is support for data mining. ... If you would integrate Excel with Sharepoint 2007, you will also have option for workflow support: Excel worksheets could be approved by boss, etc. ...
    (microsoft.public.sqlserver.olap)
  • Re: Trying to import several million rows- help!
    ... Especially if you're going into serious data mining Excel is NOT the ... > I tried the posted macro for importing more than 65K records- it ... > I can't tell whether the error is a system resource error or if it's ...
    (microsoft.public.excel.worksheet.functions)