samba - Mar 2005 - Permission problems writing to Share from SQL Agent

Hello:

I have a client that is using MS SQL Server in a Windows 2003
server.

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

Hello:

I forgot to say that the Windows 2003 server is not running
a domain, it is using the WORKGROUP workgroup.

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: samba-bounces+neil=jammconsulting.com@lists.samba.org 
> [mailto:samba-bounces+neil=jammconsulting.com@lists.samba.org]
>  On Behalf Of Neil Aggarwal
> Sent: Wednesday, March 23, 2005 3:13 PM
> To: samba@lists.samba.org
> Subject: [Samba] Permission problems writing to Share from SQL Agent
> 
> 
> Hello:
> 
> I have a client that is using MS SQL Server in a Windows 2003
> server.
> 
> 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
> 
> -- 
> To unsubscribe from this list go to the following URL and read the
> instructions:  https://lists.samba.org/mailman/listinfo/samba
>

Neil Aggarwal:
> I have a client that is using MS SQL Server in a Windows 2003
> server.
>
> 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
Search/help for "runas" on the Windows machine;

Google for:

sanur.exe
cpau.exe
encrypted runas.

These will work with normal AD, how they work with ADS (Kerberos) I don't
know.
> 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?
No. I've used them for other things requiring elevated privileges.

Best,

--Tonni

--
mail: tonye@billy.demon.nl
http://www.billy.demon.nl