Backup SQL Enterprise 2012 to network location

We are having difficulty with the built-in SQL backup directing it to a network location.  It only functions properly when the destination is a local disk.  We are in a workgroup setup so no active directory.  When we tried to use a UNC path and a mapped drive we got permission errors.  Do we have any options?
tampatechmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick RhodeIT DirectorCommented:
Are you able to browse to that share/network location normally?  Permission issue usually just refers to not having access to the specific location.
0
tampatechmanAuthor Commented:
we can browse to there properly from a run box.  just SQL doesnt like it
0
Nick RhodeIT DirectorCommented:
This might help you:

http://technet.microsoft.com/en-us/library/ms179313.aspx#NetworkShare

Under "Using Disk Backup Devices"
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

tampatechmanAuthor Commented:
our DBA tried that and told us it failed with the following error:  cannot open backup device.
0
tampatechmanAuthor Commented:
would SQL respect a MKLink command making a network location a local junction?  See http://pingdennis.wordpress.com/2007/10/24/mklink-command-in-windows-server-2008/
0
Aneesh RetnakaranDatabase AdministratorCommented:
You need to grant your SQL Server service account the permission to write on that share.  if it is still failing, add that user as local admin on that remote server for debugging purpose
0
tampatechmanAuthor Commented:
The share already has permission for "Everyone"
0
Aneesh RetnakaranDatabase AdministratorCommented:
Did you add the user as local admin ? also can you make sure that the administrator on the sql server machine can connect to the UNC, and also the non admin can connect and create a file.
0
tampatechmanAuthor Commented:
the logged in server user is an administrator.  the SQL services are using the system account.
0
Aneesh RetnakaranDatabase AdministratorCommented:
can you change the service account to a non admin account, and try giving that user explicit permission to write on that share; if that doesn't work, add that user as local admin on the remote server.
Also make sure to check 'password never expires' feature for the service account
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David ToddSenior DBACommented:
Hi,

I understand that you're on a workgroup, but your issue perfectly illustrates the advice that SQL should run under a domain account - then things like access to network and shares etc is a lot easier to manage.

Suggestions to try:
Run SQL under a real account rather than local system or some such
Then add that account as rights to the filesystem and share on the target computer

HTH
  David
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.