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.