RanceLab

Find answers to common RanceLab questions, browse curated FAQ sections, and search across the knowledge base.

FAQ
Settings
/Database Mantinance
/SQL Server

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.