• erikd (7/10/2013)


    The directory itself is everyone: full control. I'll bug someone about the rights assigned to the user again and post back. The last email I got about it said something about creating a clients\ user for me to specifically run processes as, but I'm not sure if that will help with the SQL Server Service itself logging in as clients\SQLService?

    The directory is everyone: full control, good. If you use xp_cmdshell to do a dir of that share what do you get?

    EXEC master.dbo.xp_cmdshell 'DIR \\server\share'

    I'm gonna bet you get access denied or network name not found or something.. If you do then most likely the SQL user doesn't have access to the share or its misspelled..

    CEWII