[NTLUG:Discuss] Has anyone been able to access Samba share fromSQL Server Agent?

[Neil Aggarwal]

Brad:

How is the cygwin share mapping different than windows
share mapping?

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 brad angelcyk
> Sent: Thursday, March 24, 2005 2:12 PM
> To: NTLUG Discussion List
> Subject: Re: [NTLUG:Discuss] Has anyone been able to access 
> Samba share fromSQL Server Agent?
> 
> 
> I would map the share using samba in cygwin.  I doubt SQL Server will
> allow you to write the logs out to a shared folder (if its mapped in
> windows).  Though, why do you want to do this?  The server is going to
> take a huge speed hit while waiting for samba to come back.
> 
> 
> On Thu, 24 Mar 2005 10:48:36 -0600, Neil Aggarwal
> <neil at jammconsulting.com> wrote:
> > Hello:
> > 
> > I have a client that is using MS SQL Server on a Windows 2003
> > server.  The server is running as a workgroup computer, they
> > do not have a domain.
> > 
> > They have a Linux machine (Fedora Core 3) that is acting as a file
> > server using Samba.
> > 
> > We want to write backups from the SQL Agent for SQL Server to
> > one of the shares on the Samba server.
> > 
> > If I set the share to allow guest access, the SQL Agent
> > can write the backups just fine using \\Shares\SQLBackups\pubs.bak
> > but, if I require a user name and password, it gives me
> > permission denied (Which I expect because I don't know how
> > to give it the user name and password to use).
> > 
> > I tried setting SQL Agent to use the Administrator account
> > and then mounted the share to Y: using the user name and
> > password I assigned, but when I try backing up to Y:,
> > I get that it could not find Y:\pubs.bak
> > 
> > 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?
> > 
> > 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
> > 
> > _______________________________________________
> > https://ntlug.org/mailman/listinfo/discuss
> >
> 
> _______________________________________________
> https://ntlug.org/mailman/listinfo/discuss
>