February 10, 2015 at 10:55 am
I have a windows login that is part of sysadmin, that is trying to run a stored procedure that includes xp_cmdshell. It ran fine until the user had to update their password. Now we get the following error:
An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1326'.
My understanding is this is because of the password change. My question is what's the best way to fix this. We change our passwords every 90 days, so we don't necessarily want to have to make manual changes each time.
I'm not overly familiar with xp_cmdshell, so perhaps there is an easy way to do this.
All help is appreciated!
Thanks!
February 10, 2015 at 11:51 am
Quick thought, use EXECUTE AS
😎
February 10, 2015 at 11:55 am
Its using Execute As "domain\user" currently, and that user is a sys admin
February 10, 2015 at 12:01 pm
bmahony993 (2/10/2015)
Its using Execute As "domain\user" currently, and that user is a sys admin
Is "domain\user" password expired?
😎
February 10, 2015 at 12:12 pm
Yes. The password expired, and the user updated with a new one via Windows. Now we can't run xp_cmdShell and get the error above.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply