[NTLUG:Discuss] Has anyone been able to access Samba sharefrom SQL Server Agent?

[Neil Aggarwal]

Ralph:

I created a mapping to y: already.  I give it the user name
and password for the share and I can do anything I want on
the share from Windows Explorer.

But, when I set SQL Agent to use the Administrator account
and then tell it to write a backup to y:\pubs.bak, I get
an error that it could not find the path.

Any ideas?

Thanks,
	Neil

--
Neil Aggarwal, JAMM Consulting, (972)612-6056, www.JAMMConsulting.com
FREE! Valuable info on how your business can reduce operating costs by
17% or more in 6 months or less! http://newsletter.JAMMConsulting.com

> -----Original Message-----
> From: discuss-bounces at ntlug.org 
> [mailto:discuss-bounces at ntlug.org] On Behalf Of Ralph Green, Jr.
> Sent: Thursday, March 24, 2005 1:22 PM
> To: NTLUG Discussion List
> Subject: Re: [NTLUG:Discuss] Has anyone been able to access 
> Samba sharefrom SQL Server Agent?
> 
> 
> Howdy,
>  I would do this by defining a share and picking
> a drive for it. For example do something from a
> command prompt like:
>   net use p: \\Shares\SQLBackups /U:username
>  It will ask you for the password and you just type
> it in.  Then, just backup to the P: drive or
> whatever drive letter you pick.
> Good luck,
> Ralph
> 
> On Thu, 2005-03-24 at 10:48 -0600, Neil Aggarwal wrote:
> > Has anyone set up SQL Agent to write to a Samba share
> > before?  Where/how do I give it the user name and password
> > to use?
> 
> 
> 
> 
> _______________________________________________
> https://ntlug.org/mailman/listinfo/discuss
>