Xp_cmdshell and permissions

Asked Mar 15 '17 at 15:40

Active Apr 06 '17 at 15:48

Viewed 573 times

I have an SQL non-sysadmin user. I am running xp_cmdshell in stored procedures so I was having issues as expected. I configured a proxy account to allow to run this.

I've used the following blog's instructions to do this Blog

I've successfully created a windows user for proxy account and I can run xp_cmdshell now .. but what I am facing is

SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'domain\accountName'. NULL

I couldn't find a workaround to this error.

where am I doing wrong..

Any help would be much appreciated

Thanks

asked Mar 15 '17 at 15:40

Muhammad Usman

10,039
22
39

What command are you running for `xp_cmdshell`? It could be permissions for what you are doing **outside** of SQL Server. – Shaneis Mar 15 '17 at 15:45
I am running bcp for xp_cmdshell\ – Muhammad Usman Mar 15 '17 at 15:48
check out the MSDN for permissions on bcp to rule them out as causing your error message https://msdn.microsoft.com/en-us/library/ms162802.aspx#Permissions – Shaneis Mar 15 '17 at 15:52
I've all the permission on that db like read/read etc – Muhammad Usman Mar 15 '17 at 15:55
can there be any issue with account type ? – Muhammad Usman Mar 15 '17 at 15:57
Possibly, you could be trying to pass a Windows Username as a SQL_Login. Can you add your `LOGIN` script and `bcp` command to your question? – Shaneis Mar 15 '17 at 16:02
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/138131/discussion-between-shaneis-and-usman-rana). – Shaneis Mar 15 '17 at 16:15

Xp_cmdshell and permissions

0 Answers0