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
DBAmp error referencing 'xp_cmdshell'
This topic has been closed for replies.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

