Error Message:

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

Answer:

This error occurs due to the blocking of the SQL server by Virus. To recover from this error use either of the following steps:

• Step1: Restart Server

• Step2: Run the following:-    

• EXEC master.dbo.sp_configure 'show advanced options', 1
• RECONFIGURE
• EXEC master.dbo.sp_configure 'xp_cmdshell', 1
• RECONFIGURE

Note: The above queries will be executed by a Rancelab executive only. 

For more details please visit: http://www.rancelab.com/faq/category/13/sql-related.html