February 15, 2006 at 6:54 pm
Hi ,
The proxy username on one of my sql 2k sp4 servers has stopped working and I now get the following error when I issue an xp_cmdshell command
Msg 50001, Level 1, State 50001
xp_cmdshell failed o execute because CreateProcessAsUserW returns error 1314. please make sure the service account SQL Server running under has appropriate privilege. For more information, search Book Online for topic related to xp_sqlagent_proxy_accoun
When I try and change the proxy agent username I get the following error :-
Unable to set the QL Agent proxy account becouse of the reason listed below.
The system cannot ind the path specified.
Any one come across this one.
PS I have re-booted the server several times just on the safe side
Kevin
Kevin
February 16, 2006 at 1:15 am
Hi ,
Pls check lightweight pooling is enabled.
If it is disabled pls put it on.
HTH
Killer
February 16, 2006 at 1:21 am
Lightweight pooling ?
where is it located
kevin
Kevin
February 16, 2006 at 3:11 am
hi,
exec sp_configure
u have to enable permission to update system tables then u can enable light weight pooling
from
killer
February 16, 2006 at 1:41 pm
I have checked and light weight pooling is set to 0 (off)
Let me spread some more light on my problem. The application that calls xp_cmdshell is run under an sql user and has been running for sometime (several years) no problem. However about 6 weeks ago it stopped. the only change to the network has been the Domain controller crashed and has been replaced. I had anouther server (test) with the same problem however re-booting the server managed to fix the problem.
The proxy account being used is a domain admin with full rights to the local server.
Kevin
February 16, 2006 at 11:25 pm
Hi,
Also check do the server is running under Fiber mode.If not then enable light weight pooling.
Set the value to 1.
I am sure that the SQL user is mapped to Domain user account.Check out that.
Secondly see that permission is set to that user for xp_cmdshell.
HTH
from
Killer
February 17, 2006 at 12:51 am
Hi Killer,
All the above checks out OK on both servers
kevin
Kevin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply