SQLServer: SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’

Problema:

Mensagem 15281, Nível 16, Estado 1, Procedimento xp_cmdshell, Linha 1 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. A system administrator can enable the use of ‘xp_cmdshell’ by using sp_configure. For more information about enabling ‘xp_cmdshell’, see “Surface Area Configuration” in SQL Server Books Online.

Solução:

Habilitar o acesso ao uso do xp_cmdshell:

EXECUTE SP_CONFIGURE ‘show advanced options’, 1

RECONFIGURE WITH OVERRIDE

GO

EXECUTE SP_CONFIGURE ‘xp_cmdshell’, ’1′

RECONFIGURE WITH OVERRIDE

GO

EXECUTE SP_CONFIGURE ‘show advanced options’, 0

RECONFIGURE WITH OVERRIDE

GO