Procedure master..xp_cmdshell

Question

Procedure master..xp_cmdshell

smoham22

Mr or Mrs. 500

Points: 525
More actions
February 13, 2020 at 1:02 am

#3725441

Msg 15121, Level 16, State 10, Procedure master..xp_cmdshell, Line 1 [Batch Start Line 2]
An error occurred the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'.

working on migrating from SQL Server 2008R2 to 2017 when creating proxy account and running xp_cmdshell using sqlserver login I am getting the error above.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

Make sure to create the proxy account using sp_xp_cmdshell_proxy_account and specify a Windows account. The OS level permissions can't be granted to a SQL Server login.

Sue

smoham22 Mr or Mrs. 500 Points: 525 More actions · Answer 2

I created proxy account with windows account with valid permissions.

Sue_H SSC Guru Points: 90860 More actions · Answer 3

And if you also made sure the permissions for the service account are also correct, you may want to double check those permissions. Error code 1314 is : A required privilege is not held by the client.

Sue