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

[brad angelcyk]

I believe it uses Samba rather than Windows' SMB client.

I was able to trick WinCVS into letting me use a shared drive as the
repo using cygwin.  It threw a lot of errors when I tried to use a
drive mapping (through My Computer).


On Thu, 24 Mar 2005 15:27:46 -0600, Neil Aggarwal
<neil at jammconsulting.com> wrote:
> 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
> >
> 
>