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

[brad angelcyk]

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
>