1.check agent_exe and subsystem_dll’s path in MSDB database

select subsystem_dll,agent_exe from syssubsystems;

2.open xp_cmdshell modular

exec sp_configure 'show advanced options',1;

reconfigure; exec sp_configure 'xp_cmdshell',1;reconfigure; test:

exec mater..xp_cmdshell "whoami"

select * from syssubsystems;

update syssubsystems set agent_exe='F:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe' where subsystem_id='4' update syssubsystems set subsystem_dll='F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\binn\SQLOLAPSS.DLL' where subsystem_id='10' update syssubsystems set agent_exe = (select subsystem_dll from syssubsystems where subsystem_id = '1') update syssubsystems set subsystem_dll='F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\binn\SQLPOWERSHELLSS.DLL', agent_exe='F:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLPS.exe' where subsystem_id='12'