Issue : when you try to run xp_cmdshell on sql server , you get error message.
An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1385'
Observations :
1, The login which is trying to run xp_cmdshell has EXEC permission on the strored procedure xp_cmdshell
2, when we grant the login with sysadmin privilege , the login can run xp_cmdshell without any issues. however when sysadmin permission is revoked , the login faces belwo error message while using xp_cmdshell
"a call to LogonUserW failed with error code 1385"
steps for Fixing the issue :
1, open local security policy on the computer which has SQL server installed on it.
ex: if login was trying to connect to serverA and run the query xp_cmdshell , which resulted in error message. then connect to serverA and open local security Policy.
2, Navigate to Security Settings > Local policies > User rights assignment
3, Double click on policy 'Log on as a batch job' Add user or group which needs to run xp_cmdshell command in sql . apply the settings
performing above steps in my case solved the issue
An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1385'
Observations :
1, The login which is trying to run xp_cmdshell has EXEC permission on the strored procedure xp_cmdshell
2, when we grant the login with sysadmin privilege , the login can run xp_cmdshell without any issues. however when sysadmin permission is revoked , the login faces belwo error message while using xp_cmdshell
"a call to LogonUserW failed with error code 1385"
steps for Fixing the issue :
1, open local security policy on the computer which has SQL server installed on it.
ex: if login was trying to connect to serverA and run the query xp_cmdshell , which resulted in error message. then connect to serverA and open local security Policy.
2, Navigate to Security Settings > Local policies > User rights assignment
3, Double click on policy 'Log on as a batch job' Add user or group which needs to run xp_cmdshell command in sql . apply the settings
performing above steps in my case solved the issue
Why the button add user or group is disabled and there's a messaje "This setting is not compatible with configuration running 2000 service pack 1" ?? how can i enable it?
ReplyDelete