December 23, 2016 at 1:56 pm
Just trying to referenced a mapped drive in SQl Agent. The service acct for SQl Agent is a domain acct with local admin rights on the 2008 r2 server.
I need to access a shared folder on a different 2008 r2 server. I thought Net use would do it but whenever I list the shared folder, it errors out. I've confirmed my sql agent service domain account has access to the share.
net use J: \\servername works net use J: \\servicename\shared drive does not.
Do I need to use xp_cmdshell to do this?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
December 23, 2016 at 2:20 pm
fizzleme (12/23/2016)
Just trying to referenced a mapped drive in SQl Agent. The service acct for SQl Agent is a domain acct with local admin rights on the 2008 r2 server.I need to access a shared folder on a different 2008 r2 server. I thought Net use would do it but whenever I list the shared folder, it errors out. I've confirmed my sql agent service domain account has access to the share.
net use J: \\servername works net use J: \\servicename\shared drive does not.
Do I need to use xp_cmdshell to do this?
Is there some reason you can't use a UNC path? Those tend to be more reliable than mapped drives.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply