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

[Paul Ingendorf]

Please let me know if I'm wrong in my assumptions here but you are using
something like AT to schedule the backup under the admin account.  This will
mount the remote share and output the backup and disconnect without
providing access to the resource for anyone else.  If this is the case an
administrator account needs to be configured on the remote server with
administrator in the /etc/samba/smbpasswd file.  The password then needs to
be set or a trust relationship needs to be configured between the samba file
server and your sql box.  With this in place you should be able to better
control the access to the share in the event you don't want everyone on the
network to have access to the resource.  I would also suggest checking out
some of the resources on samba.org keeping in mind most thing will be
explained in winXP/2k/98 contexts.

I've used at to fire off similar remote backups and it works fine as long as
your permissions are in place.

-----Original Message-----
From: discuss-bounces at ntlug.org [mailto:discuss-bounces at ntlug.org]On
Behalf Of Neil Aggarwal
Sent: Thursday, March 24, 2005 10:49 AM
To: 'NTLUG Discussion List'
Subject: [NTLUG:Discuss] Has anyone been able to access Samba share from
SQLServer Agent?


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