Title: Microsoft SQL Server Management Studio
------------------------------
The requested dialog cannot be displayed.
------------------------------
Additional information:
Unable to execute the requested command.
------------------------------
The Agent XP component has been turned off as part of this server's security configuration. System administrators can use sp_configure to enable Agent XP. For more information about enabling Agent XP, see Peripheral Application Configurator in the SQL Server Online Books series. (Microsoft.SqlServer.Management.MaintenancePlanWizard)
------------------------------
Button:
Are you sure
------------------------------ 
Just run the following statement
sp_configure This is a call to a stored procedure of the system, there are a total of 36 server options,
By default, only 10 of sp_configure stored procedures are displayed, no advanced options are included in the displayed results, and all new SQL Server configuration options do not appear in this stripped-down list.
However, we can use the show advanced options command parameter to make SQL Server show all options.
To enable show advanced options, we use the following command format: EXEC sp_configure 'show advanced options', '1' RECONFIGURE
To install an option, you must run the RECONFIGURE command after configuring the server with sp_configure.
The output of the above command is as follows: "The configuration option 'show advanced options' has been changed from 1 to 1. Run the RECONFIGURE statement to install it. ”
After running this stored procedure, be sure to remember to run reconfigure once
There is a similar command
1 EXEC sp_configure 'show advanced options' , 1
sp_configure is a stored procedure that modifies the system configuration
When the show advanced options parameter is set to 1, it is allowed to modify some advanced phase selections in the system configuration!! These advanced options in the system are not allowed to be modified by default! ('xp_cmdshell' is one of the advanced options parameters!) ）
2 RECONFIGURE
(Submit the first step)
Update the current configuration of configuration options that use sp_configure system stored procedure changes
3 EXEC sp_configure 'xp_cmdshell' ,1
Execute the system stored procedure Modify the advanced options parameter 'xp_cmdshell' equal to 1
This parameter is equal to 1 to allow sqlserver to call operating system commands outside of the database
For example, executing the dir command under server200 can be written as xp_cmdshell 'dir *.exe', NO_OUTPUT
4 RECONFIGURE
Submit the action for step 3 of the update
|
Posted on 7/9/2018 1:42:16 PM
|
|
|
|
