Retour
-
Titre
Why does the SQL server agent use xp_cmdshell for monitoring the server? -
Description
Why would Foglight be using xp_cmdshell for monitoring the server? -
Cause
The SQL Server agent uses xp_cmdshell for two collections (refer to the linked Knowledgebase articles for details on these collections) -
Résolution
To turn on this parameter in SQL Server, run the following commands:
EXEC sp_configure ‘show advanced options’,1 GO --To update the currently configured value for advanced options. RECONFIGURE GO —- To enable the feature. EXEC sp_configure ‘xp_cmdshell’, 1 GO —- To update the currently configured value for this feature. RECONFIGURE GO
To turn off a collection
- Navigate to the Global View Databases dashboard
- Select the problematic agent and click Settings | Administration
- Select Collections and highlight the collection name (i.e. Configuration and/or Cluster Summary)
- Click the Edit button
- Uncheck the Enable Collection checkbox
- Click the Set button
- Click the Save changes button
Note: Enhancement ID FGSS-I-160 has also been logged for the SQL Server Agent to suppress the use of xp_cmdshell as in the Cluster Summary and Config Suggestion collections it has been deemed by some customers to pose a security risk. This will be reviewed by Product Management for consideration in a future release of the SQL Server cartridge. -
Identifiant du défaut
SSDB-9138