Home Forums SQL Server 2008 SQL Server 2008 - General xp_cmdshell access denied to desktop file when logged as administrator - why ? RE: xp_cmdshell access denied to desktop file when logged as administrator - why ?

  • isuckatsql (3/23/2010)


    I am logged in as an administrator and each time i run the following query

    exec master.dbo.xp_cmdshell 'dir c:\users\administrator.mydomainname\desktop\resumes\*.*'

    I get an 'Access is denied' error!

    This worked fine on my other server, what am i missing?

    Thanks

    Are the account has sysadmin privilege ?

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/