Error 997 From Getproxyaccount
record in a table via a stored procedure. That table has a trigger which gets fired on an insert. The trigger has the following code EXEC master..xp_cmdshell 'C:\MyApp\try.exe' This all works when the stored procedure is fired inserting the record in turn firing off the trigger; but when the ASPX page runs the stored procedure I get the following error. A severe error occurred on the current command. The results, if any, should be discarded. xpsql.cpp: Error 997 from GetProxyAccount on line 472 The Guest login has permissions to the extended stored procedure xp_cmdshell on the master db, but this has not helped. Any help would be greatly appriciated. Phil Top master..xp_cmdshell Error 997 from GetProxyAccount by Hari » Tue, 15 Jun 2004 14:09:11 Hi, You need to set up a proxy account. Create an user and then configure that in EM (Management, right-clickSQL Agent, configure that proxy account). Have a look into below article:- http://www.yqcomputer.com/ ://support.microsoft.com: 80/support/kb/articles/Q264/1/55.ASP&NoWebContent=1 Top master..xp_cmdshell Error 997 from GetProxyAccount by toomuchphi » Wed, 16 Jun 2004 12:51:54 Thanks for that Hari, I am going forward... I think The error I am getting now is General network error. Check your network documentation. I have now configured the proxy account within EM. I unticked the 'Only users with SysAdmin privileges can execute cmdExec and ActiveScripting job steps.' I have since changed the trigger from executing my .exe to execute a .bat which simply copies a file. The Internet Guest account has privileges to the directory. The batch file is being run but the copy is not working. I guess this is to do with the privileges still. Any suggestions would be greatly appreciated. Phil. Top master..xp_cmdshell Error 997 from GetProxyAccount by RnJhbm » Sat, 31 Jul 2004 09:49:04 - Start SQL Enterprise manager - Open your server - open the Management folder - right mouse on SQL Server Agent and select properties - select Job System tab - UNCHECK the box in the section 'Non SysAdmin job step proxy account' which says 'Only users with SysAdmin priveleges can ...' - when the dialog comes up enter the username, password, [domain] of some defined Windows user with sysAdmin priveleges (create one if needed first). - click Apply and OK Top 1. ftp sessio
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » T-SQL » Error 997 GetProxyAccount Error 997 GetProxyAccount Rate Topic Display Mode Topic Options Author Message DonnaOsburnDonnaOsburn Posted Saturday, July 5, 2003 10:13 PM Forum Newbie Group: General Forum Members Last Login: Monday, February 13, 2006 8:31 AM Points: 6, Visits: 1 I am getting the following error.xpsql:ccp:Error 997 from GetProxyAccount on line 472 when I call http://www.yqcomputer.com/931_27595_1.htm a stored procedure from Visual Foxpro. The stored procedure works if I run it in the debugger. Is this a permissions issue? I can't find any info on GetProxyAccount in BOL Post #13887 mccorkmccork Posted Sunday, July 6, 2003 3:33 AM SSCertifiable Group: General Forum Members Last Login: Sunday, August 21, 2016 6:04 PM Points: 5,464, Visits: 440 Here's the URL http://www.sqlservercentral.com/Forums/Topic13887-8-1.aspx from hell . I hope it posts ok and navigates ok for you. It shows a discussion and resolution for similar symptoms. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=uinmn6PTBHA.432%40tkmsftngp07&rnum=3&prev=/groups%3Fq%3DGetProxyAccount%2B997%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3Duinmn6PTBHA.432%2540tkmsftngp07%26rnum%3D3 Cheers,- Mark Post #69349 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You cannot send private messages. You cannot send emails. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot p
ProgramadoresIniciar sesiónCorreo: Contraseña: Entrar Recordar sesión en este navegadorRecordar contraseña?Iniciar sesiónCrear cuentaDocumentación y RecursosCursos y ManualesBiblioteca de TemasCódigo FuenteNoticias/ArtículosForos http://www.lawebdelprogramador.com/foros/SQL/175773-xpsql.cpp-Error-997-from-GetProxyAccount-on-line.html y ConsultasForos de ConsultaChats de prog.Nuevo!!Tablón de NotasDiccionario informáticoProgramadoresProgramadoresOfertas de TrabajoSolicitudes para prog.Lista de CorreoProgramasProgramas/UtilidadesNuestros ProgramasIconos y CursoresPreguntas/RespuestasOtrosUtilidadesColaboradoresEncuestas/EstadísticasContactarLWP » Foros » SQL » xpsql.cpp: Error 997 from GetProxyAccount on line SQL - xpsql.cpp: Error 997 from GetProxyAccount on line VolverNuevo Tema<<>> Vista: arbolcronológicoxpsql.cpp: Error 997 from GetProxyAccount on linePolyta(03/09/2002 23:07:00)3.523 error 997 visitas1 respuestaRE:xpsql.cpp: Error 997 from GetProxyAccount on liEDELRIO(04/09/2002 01:05:58) xpsql.cpp: Error 997 from GetProxyAccount on linePublicado por Polyta(1 intervención) el 03/09/2002 23:07:00hola...alguien me ayude porfis...ejecuto un bcp en sql2000 y me da este error "xpsql.cpp: Error 997 from GetProxyAccount on line 472"...lo cual no da error en sql6.5....el bcp es el error 997 from siguiente : exec master..xp_cmdshell "bcp bdes_poliza..tcod_movimientos out d:\th\temp1.tmp /U th /P th /S ise_prueba2000 / c / t@ / b 100000" alguien sabe por que me da ese error????...les agradecere mucho...Valora esta pregunta0ResponderOtras secciones de LWP con contenido de SQL- Código fuente de SQL- Cursos de SQL- Temas de SQLCódigos de SQL- Cursores en SQL Server- Dias SQL Server- formatear numeros en SQL Server RE:xpsql.cpp: Error 997 from GetProxyAccount on liPublicado por EDELRIO(540 intervenciones) el 04/09/2002 01:05:58Su error es probablemnte porque se esta tratando de conectar a otro servidor no de forma local.... Como se conecta a el??? Modem, Red Novell o cual?? Gracias y espero respuesta...Valora esta respuesta0Comentar Consulta SQL con RangosNumero unico de la Base Enviar a un amigoOtras secciones relacionadas con SQLCursosBiblioteca de TemasCódigo FuenteGeneral RSS del foroExpertosTus mensajesRecomendar Seguir a @lwp_ Información y RecursosCursos y ManualesBiblioteca de TemasCódigo FuenteNoticias/ArtículosForos y ConsultasForos de ConsultaChats de programaciónTablón de NotasDiccionarioProgramadoresPro