cancel
Showing results for 
Search instead for 
Did you mean: 

xp_cmdshell

Germinario
Not applicable

Hi,

I have this problem: I have BE installed on a 2003 server, where I run a software based on SQL 2005 too. This software needs xp_cmdshell to be activated, but occasionally this function gets disabled. I searched on event viewer and SQL logs, and I found that the command change after some BE operations, so I need to turn it on launching those queries:

 

1

USE master

GO

EXEC sp_configure 'show advanced option', '1'

GO

RECONFIGURE

GO

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE

GO

 

2

use master

GRANT EXECUTE ON xp_cmdshell TO [dominio\gruppo di active directory]

 

3

use master

EXEC sp_xp_cmdshell_proxy_account 'dominio\utenteamministratore', 'password

 

I have 4-5 customers with this problem, so i created a scheduled task which launch the queries periodically, but I don't like this solution. I really need to solve this problem: does anyone have a solution?

 

Thanks a lot,

Leonardo Germinario

1 REPLY 1

VJware
Level 6
Employee Accredited Certified

I am not aware of any BE processes which disable xp-cmdshell. Best to let BE use its own instance with SQL express and not use the production one. Similar post - https://www-secure.symantec.com/connect/forums/backup-exec-disabling-xpcmdshell-remote-sql-server

Infact, xp_cmdshell is disabled by default by MS on new installs.