Data Mining Properties

Microsoft SQL Server Analysis Services supports the data mining server properties listed in the following tables. To view or change these properties for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties.

Non-Specific Category

  • AllowSessionMiningModels
    A Boolean property that indicates whether session mining models can be created.

    The default value for this property is false, which indicates that session mining models cannot be created.

  • AllowAdHocOpenRowsetQueries
    A Boolean property that indicates whether adhoc open rowset queries are allowed.

    The default value for this property is false, which indicates that open rowset queries are not allowed during a session.

  • AllowedProvidersInOpenRowset
    A string property that identifies which providers are allowed in an open rowset, consisting of a comma/semi-colon separated list of provider ProgIDs, or else [All].

  • MaxConcurrentPredictionQueries
    A signed 32-bit integer property that defines the maximum number of concurrent prediction queries.

Algorithms Category

  • Microsoft_Association_Rules\ Enabled
    A Boolean property that indicates whether the Microsoft_Association_Rules algorithm is enabled.

  • Microsoft_Clustering\ Enabled
    A Boolean property that indicates whether the Microsoft_Clustering algorithm is enabled.

  • Microsoft_Decision_Trees\ Enabled
    A Boolean property that indicates whether the Microsoft_DecisionTrees algorithm is enabled.

  • Microsoft_Naive_Bayes\ Enabled
    A Boolean property that indicates whether the Microsoft_ Naive_Bayes algorithm is enabled.

  • Microsoft_Neural_Network\ Enabled
    A Boolean property that indicates whether the Microsoft_Neural_Network algorithm is enabled.

  • Microsoft_Sequence_Clustering\ Enabled
    A Boolean property that indicates whether the Microsoft_Sequence_Clustering algorithm is enabled.

  • Microsoft_Time_Series\ Enabled
    A Boolean property that indicates whether the Microsoft_Time_Series algorithm is enabled.

  • Microsoft_Linear_Regression\ Enabled
    A Boolean property that indicates whether the Microsoft_Linear_Regression algorithm is enabled.

  • Microsoft_Logistic_Regression\ Enabled
    A Boolean property that indicates whether the Microsoft_Logistic_Regression algorithm is enabled.

Note

In addition to properties that define the data mining services available on the server, there are data mining properties that define the behavior of specific algorithms. You configure these properties when you create an individual data mining model, not at the server level. For more information, see Algorithm Reference (Analysis Services - Data Mining).