Return
-
Title
Getting error "Cannot use xp_cmdshell.No data available" when trying to open Support Services -
Description
Getting error "Cannot use xp_cmdshell.No data available" when trying to open Support Services
-
Cause
XP_cmdshell is not enabled
-
Resolution
Please enable XP_cmdshell on the SQL Server to use the Start and Stop options.
To use the Start and Stop options when connected to SQL Server, in addition to the Spotlight user being a member of the Quest Diagnostics Administrators group, the Diagnostic Server must be connected to the SQL Server as a sysadmin level user and XP_cmdshell must be enabled on the SQL Server. If the Diagnostic Server is not connected as a sysadmin user and /or xp_cmdshell is disabled, the Start and Stop options will not perform the expected service control actions when they are used.