Skip to main content

DBAmp error referencing 'xp_cmdshell'

  • July 20, 2023
  • 0 replies
  • 131 views

Forum|alt.badge.img

The error: "Error: SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server.", shows up because xp_cmdshell is not enabled for the user you have running the stored procedure. Most of the DBAmp stored procedures require xp_cmdshell, so you'll need to enable it for the user in question. That is an option in SQL Server, and you can find configuration instructions here: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/xp-cmdshell-server-configuration-option?view=sql-server-ver15 

This topic has been closed for replies.