To enable the command shell
-- To allow advanced options to be
changed.
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
EXEC sp_xp_cmdshell_proxy_account '[Domain\username]','passw0rd'
use master
go
CREATE USER [Domain\username] FROM
LOGIN [Domain\username]
GRANT EXECUTE ON xp_cmdshell TO [Domain\username]
No comments:
Post a Comment