The parameter is not included in the SQL Server permissions script. To turn on this parameter in SQL Server, run the following commands manually against the SQL Server instance.
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.