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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy