Home Forums SQL Server 7,2000 Administration getting error "The system cannot find the path specified." using xp_cmdshell RE: getting error "The system cannot find the path specified." using xp_cmdshell

  • January 23, 2008 at 12:04 pm

    #771016

    asif_ku (1/23/2008)

    First of all thanks for quick respond!

    Yes, that folder exisit on same machine where Sql server is running.

    I am not sure how to give permission to that folder? Can u plz let me know the steps to do so?

    Thanks.

    xp_cmdshell will use the account which is running your SQL server.

    To figure out the account running SQL:

    - Start | Run | services.msc

    SQL2000

    - MSSQLSERVER(INSTANCENAME)

    SQL2005

    - SQL Server(INSTANCENAME)

    - Double click the service

    - Click Log On

    - Note the account running the service

    Now that you know the account, check your folder permissions

    - Right click the folder in question

    - Go to Properties / Security

    - Ensure the account in question has the appropriate permissions (read/write from the sounds of it)