Surface Area Configuration for Features (Ad Hoc Data Mining Queries) - Analysis Services

The Data Mining Extensions (DMX) OPENROWSET function supports ad hoc queries using external providers. If your applications and scripts do not use this function, disable ad hoc data mining queries.

If you enable ad hoc data-mining queries, you can enable or disable the passing of OLEDB provider name and connection string when using OPENROWSET.

Enable Ad hoc data mining queries

If checked, the DMX OPENROWSET function is enabled.

For more information, see OPENROWSET (DMX) in Microsoft SQL Server Books Online.

For more information about configuring server options, see sp_configure (Transact-SQL) in SQL Server Books Online.

Community Additions