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

[Neil Aggarwal]

Brad:

I guess it is worth a try.  
I am looking at the cygwin stuff.  Are you saying that
I can use these commands in a dos prompt:
	mkdir /backups
	mount \\Shares\SQLBackups /backups

Then, I can write the backup to c:\cygwin\backups directory
(I wil lput cygwin in c:/cygwin) and it will be put on the 
Linux share?

How do I give the user name and password needed to access
the share to the mount command?

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 3:35 PM
> To: Neil Aggarwal; NTLUG Discussion List
> Subject: Re: [NTLUG:Discuss] Has anyone been able to access 
> Samba sharefromSQL Server Agent?
> 
> 
> 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
> > >
> > 
> >
> 
> _______________________________________________
> https://ntlug.org/mailman/listinfo/discuss
>