Post reply

Creating Remote folder using XP_CMDSHELL in SQL 2005

  • August 5, 2008 at 6:22 am

    #93611

    I have a code to create remote folder in SQL 2000. It is not working in SQL 2005. I have enabled the xp_cmdshell option in 2005 and working fine creating local folder.

    the command is as follows

    EXEC MASTER..XP_CMDSHELL 'MD "\\server1\Reports\files\06 Aug 2008"'

    Its return error as Access denied. The shared folder has necessary permissions to created folders.

  • August 7, 2008 at 3:11 am

    #854287

    Are you sure that you have given permission to SQL Server Service Account to create the directory? (check the service itself and see what log on it is using.)

    The best explanation of all this seems to be on

    http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx

    There are subtle differences between SQL Server 2000 and 2005 as you'll see.

    Best wishes,
    Phil Factor

  • August 8, 2008 at 1:03 am

    #854942

    Thanks for your reply. I have checked the shared path. That machine not in the same domain as source

    Is it possible to create folder in remote machine which is not in the same domain??

  • August 18, 2008 at 4:28 pm

    #859715

    You could create a cross-domain trust relationship which would allow the logon the agent is using in your domain to have privileges in the target domain. This would typically be setup by the domain administrator of the target domain.

    Have Fun!
    Ronzo

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply