March 25, 2004 at 2:31 pm
I've written a batch file that uses isql to send an email via xp_sendmail. I would like it to run when a particular service fails. I would also like isql to connect to sql using a trusted connection. The service in question runs under the local system account. My question then is would the local system account have the rights to execute xp_sendmail?
Thanks!
Noel
March 25, 2004 at 5:22 pm
COnsider that SQL Agent can actually be run under local system accoutn and talk thru a trusted connection. However I am not sure if anything else goes on behind the scenes that makes that work, I suggest just test it to know for sure.
March 25, 2004 at 5:49 pm
I was thinking that about the agent also. Any suggestions as to how to test it? I'm not able to make the service fail not can I log in as local system.
March 25, 2004 at 5:51 pm
Not sure and I don't have a test system running here at the house right now.
March 26, 2004 at 10:11 am
I don't believe that it can. I think you should just setup a local user account on the system.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply