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.
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
- EXEC master.dbo.sp_configure 'xp_cmdshell', 1
Note: The above queries will be executed by a Rancelab executive only.