XP_CMDSHELL problem

[SpiritOfLennon]

Hi,
I had xp_cmdshell all nicely set up and executeable. The database was being run as th machines local admin account. I then needed to set up sql mail. So I set up my MAPI profile and changed sql server to run as the domain account that I had set up a mail account for. I've given the domain account sys admin priviledges in Sql server and locally on the server and I've granted it permission on xp_cmdshell. However when trying to execute xp_cmdshell as the original sql server user that worked I now get the following message.

Msg 50001, Level 1, State 50001
xpsql.cpp: Error 1314 from LogonUserW on line 488


Anybody got any ideas? I'm stumped.

 

[SpiritOfLennon]

I'm going to answer my own question here and hopefully it may help someone else someday.
Changing the owner of the sql server service removes any previous proxy details that have been entered in enterprise manager and so you have to add them for the new user. DoHHH!

SOL
I'm only guessing but my guess work generally works for me.

 

[jitter]

Here is some info that might help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;248391&sd=tech

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45799&whichpage=1

Maybe these might help you.

jitter

Instead of shooting where I was, you should have shot where I was going to be. - Lrrr (Planet Nintendio64)