SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server.

This is a common error when a stored procedure tries to execute xp_cmdshell command, by default 'xp_cmdshell'is disabled. To enable this in Sql Server 2008 R2, you need to right click on the server name and select 'facets'.

Have patience as it takes some time to load the 'view facets'window. Now select the drop down next to 'Facet' and select 'Surface Area Configuration'. Now turn the property for 'XPCmdShellEnabled' to True. Hit Ok and you are done.

If you want to run the script, you can visit xp_cmdshell Option