Home Forums SQL Server 2008 SQL Server 2008 High Availability XP_Cmdshell 'Access is denied' RE: XP_Cmdshell 'Access is denied'

  • May 9, 2012 at 10:10 am

    #1485168

    ravisamigo (5/8/2012)

    Hi All,

    xp_cmdshell 'dir \\Server001\e$' - running in Server2

    xp_cmdshell 'dir \\Server002\e$' - running in server1

    OUTPUT : 'Access is denied.'

    But I'm able to access through RUN(WIN+R) command from server1 to server2 and vice versa.

    NOTE: I've given 'full control' permission on both folders in E\ drive in both servers.

    Please advice.

    Thanks and Regards,

    Ravi

    Please post the result of the foloowing query when executed against the sql server instance

    select value_in_use from sys.configurations

    where name = 'xp_cmdshell'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉