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.