03-17-2015 11:41 AM
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
03-18-2015 12:51 AM
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.