CCE-19897-8| Platform: ms-sql2005 | Date: (C)2013-02-19 (M)2022-10-10 |
Ad hoc data mining queries configuration option should be configured appropriately
Parameter:
(1) enable/disable
Technical Mechanism:
(1) The configuration file (msmdsrv.ini) may be found in the [install dir] \ MSSQL.[#] \ OLAP \ Config directory.
(2) AllowAdHocOpenRowsetQueries
or
From the SQL Server 2005 Surface Area Configuration GUI:
1. Click on Surface Area config for features
2. Expand Analysis Services
3. Select Ad Hoc Data Mining Queries
4. Enable or disable as necessary
| CCSS Severity: | CCSS Metrics: |
| CCSS Score : | Attack Vector: |
| Exploit Score: | Attack Complexity: |
| Impact Score: | Privileges Required: |
| Severity: | User Interaction: |
| Vector: | Scope: |
| | Confidentiality: |
| | Integrity: |
| | Availability: |
| | |
References: | Resource Id | Reference |
|---|
| DISA STIG SQL 2005 INS Version 8, Release 1.7 Benchmark Date: 27 August 2010 | Rule ID: V0015183 Rule Title: The Analysis Services ad hoc data mining queries configuration option should be disabled if not required. STIG ID: DM6085 Severity: CAT II Class: Unclass |
