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.

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. 

 

Tags: Error Message, Message, Settings, SQL server

Related entries:

You cannot comment on this entry