I'm trying to run an exe that also looks at an ini file to read in some values using xp_cmdshell.
There's no user input to this exe.
The exe and ini are somewhere on the network and I logged into QA using the login/pwd the client gave us. I did this : exec master..xp_cmdshell '\\main\folder\..\..\..\mytest.exe". I get the error:
xp_cmdshell failed to execute because current security context is not sysadmin and proxy acount is not setup correctly. For more information, refer to Book Online, search for topic related to xp_sqlagent_proxy_account.
I did this :EXEC master.dbo.xp_sqlagent_proxy_account N'GET'
and I got no rows back.
*** So I did this: logged to QA as admin. Copied the exe and ini to a c:\test folder on the server that has the sql server. I ran the exec master..xp_cmdshell 'c:\test\mytest.exe'.
At first, I got the error: system cannot find path and another row that has "NULL". I ran it couple of other times and I only got the "null" row back. Checked the Windows Task and dont see the exe running.
What to do??