Allow Excute_CmdShell command in sQL Server

The user must have ‘sysadmin’ or ‘serveradmin’ server roles access for this.

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