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

[Paul Ingendorf]

I forgot to add it makes a huge difference if you are using encrypted
passwords for some areas of the network and not for others.

-----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