Search

Tuesday, June 7, 2011

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

This is a Virus related Problem. This error occurs due to the blocking of the SQL server by Viruses. To recover from this error use any one of the following steps…
  • Step1: Restart Server
  • Step2: Run the following Query: --
  • EXEC master.dbo.sp_configure 'show advanced options', 1
  • RECONFIGURE
  • EXEC master.dbo.sp_configure 'xp_cmdshell', 1
  • RECONFIGURE

No comments:

Post a Comment