ID #1270

How to recover from the following Sql Error which is being shown at the time of login from Node?

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.


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. 


Tags: Error Message, Message, Settings, SQL server

Related entries:

You cannot comment on this entry