Home All Groups Group Topic Archive Search About

xpsql.cpp: Error 87 from GetProxyAccount on line 604

Author
14 Jul 2005 5:09 PM
carloscajas
they reckoned,

I am executing these commands in slqanalyzer:

set @ruta ='\\aBsrvNET\reportes_TC\' + @mess + '\' + @mes +
dbo.f_it_fill_campo(convert(varchar(2),day(@pp_fecha)),1,'0') +
convert(varchar(4),year(@pp_fecha)) + '_LISTADOS\OTROS\'


-- BUSCA EL ARCHIVO PARA SABER
-- SI YA SE HA GENERADO
exec ATSRV01.master.dbo.xp_fileexist @ruta, @i out
if @i = 0
   begin
     select @creardir = 'md ' + @ruta
     exec atsrv01.master.dbo.xp_cmdshell @creardir
    end


But al to execute it for front_end appears me this message:

@@@@@@ERROR REG BASE: xpsql.cpp: Error 87 from GetProxyAccount on line 604

Author
14 Jul 2005 5:15 PM
Anith Sen
Most likely it could be an issue with the permissions of the user executing
xp_cmdshell. Do you have a proxy account set up? Or else check the topic
xp_sqlagent_proxy_account in SQL Server Books Online. You can do this from
EM under the SQL Agent Properties as well.

--
Anith

AddThis Social Bookmark Button