proxy login account can't execute xp_cmdshell
Thsi really weird to me and I really dunno how to fix it.
1: Login has been granted for Database role "CanUseXP_cmdshell" and it has access in master db.
2: when I test the login it says access is denied.
3: hwen I try to access the path using windows with using this login it works to display me the directory.
4: XP_cmdshell has been set to 1 in sp_configure
5: Few logins which have same privileged have no issues to execute the xp_cmdshell
I also have my test server where the same users exist and connected to the same path and it works fine from test server
what am I missing which caused the login cannot use to execute xp_cmdshell ?
1: Login has been granted for Database role "CanUseXP_cmdshell" and it has access in master db.
2: when I test the login it says access is denied.
3: hwen I try to access the path using windows with using this login it works to display me the directory.
4: XP_cmdshell has been set to 1 in sp_configure
5: Few logins which have same privileged have no issues to execute the xp_cmdshell
I also have my test server where the same users exist and connected to the same path and it works fine from test server
what am I missing which caused the login cannot use to execute xp_cmdshell ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks it work,
But I curious ...
when I ran under my context, it display me the folder, but I do not have access to the folder below
exec master..xp_cmdshell 'dir \\servername22\sharedfolde
select SUSER_SNAME()
select @@servername
revert
Then I try from the other sql instance query with same command above, it says "access is denied " You have any explanation for this ?
But I curious ...
when I ran under my context, it display me the folder, but I do not have access to the folder below
exec master..xp_cmdshell 'dir \\servername22\sharedfolde
select SUSER_SNAME()
select @@servername
revert
Then I try from the other sql instance query with same command above, it says "access is denied " You have any explanation for this ?
No perhaps someone else might have some ideas. We were mapping the drive as a workaround solution. We assumed than it was a bug in Server2k8 missed by Microsoft.
No perhaps someone else might have some ideas. We were mapping the drive as a workaround solution. We assumed than it was a bug in Server2k8 missed by Microsoft.
ASKER
We are using sql2008 std edition. Let me try with the suggestion then come back to u guys