Procedure master..xp_cmdshell

  • smoham22

    Mr or Mrs. 500

    Points: 525

    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.

  • Sue_H

    SSC Guru

    Points: 90701

    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

    I created proxy account with windows account with valid permissions.

  • Sue_H

    SSC Guru

    Points: 90701

    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

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

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