Sharepoint Backup Event Error 18204

SharePoint 2010 SP2
Windows 2012 R2 Server

SQL 2008
Windows 2008 R2 Server

On SharePoint I am trying to backup my Site using Central Administration

When I run the backup I get this error

Log Name:      Application
Source:        MSSQL$SHAREPOINT
Date:          7/12/2015 2:41:42 PM
Event ID:      18204
Task Category: Server
Level:         Error
Keywords:      Classic
User:          Mydom\spfarm
Computer:      SERV010.FQDN.com
Description:
BackupDiskFile::CreateMedia: Backup device 'f:\sharepoint\spbr0001\000000C4.bak' failed to create. Operating system error 3(The system cannot find the path specified.).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL$SHAREPOINT" />
    <EventID Qualifiers="49152">18204</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-12T18:41:42.000000000Z" />
    <EventRecordID>164869</EventRecordID>
    <Channel>Application</Channel>
    <Computer>SERV010.FQDN.com</Computer>
    <Security UserID="S-1-5-21-3054588571-1341459584-784128302-3142" />
  </System>
  <EventData>
    <Data>BackupDiskFile::CreateMedia</Data>
    <Data>f:\sharepoint\spbr0001\000000C4.bak</Data>
    <Data>create</Data>
    <Data>3(The system cannot find the path specified.)</Data>
    <Binary>1C470000100000001300000054004700430053003000310030005C005300480041005200450050004F0049004E005400000000000000</Binary>
  </EventData>

This error occurred on the Windows 2008 running SQL 2008 Server

I figured out that since the SQL Server is on another server is the reason why this is happening.

So on the Windows 2008 Server running SQL I created a network share for the backup folder
Share name is camsecurity  the folder is SharePoint 2010 Backup

So in SharePoint backup I changed the path to
\\SERV010\camsecurity\sharepoint 2010 backup

The job ran and not I get this error

Log Name:      Application
Source:        MSSQL$SHAREPOINT
Date:          7/13/2015 4:44:46 PM
Event ID:      18204
Task Category: Server
Level:         Error
Keywords:      Classic
User:          Mydom\spfarm
Computer:      SERV010.fqdn.com
Description:
BackupDiskFile::CreateMedia: Backup device '\\serv010\camsecurity\sharepoint 2010 backup\spbr0000\000000C5.bak' failed to create. Operating system error 5(Access is denied.).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL$SHAREPOINT" />
    <EventID Qualifiers="49152">18204</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-13T20:44:46.000000000Z" />
    <EventRecordID>165238</EventRecordID>
    <Channel>Application</Channel>
    <Computer>serv010.fqdn.com</Computer>
    <Security UserID="S-1-5-21-3054588571-1341459584-784128302-3142" />
  </System>
  <EventData>
    <Data>BackupDiskFile::CreateMedia</Data>
    <Data>\\tgcs010\camsecurity\sharepoint 2010 backup\spbr0000\000000C5.bak</Data>
    <Data>create</Data>
    <Data>5(Access is denied.)</Data>
    <Binary>1C470000100000001300000054004700430053003000310030005C005300480041005200450050004F0049004E005400000000000000</Binary>
  </EventData>
</Event>


SPARM has full rights to the share
NTFS permissions everyone has full rights


What am I missing here

Thanks
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

Robin CMSenior Security and Infrastructure EngineerCommented:
This is definitely a permissions issue. How did you grant your Mydom\spfarm user access to the share and NTFS folder? Did you do it by adding the user to a group in Active Directory? If so you'll need to stop and restart the SQL server service to get it to pick up the new group membership.

To verify the permissions are correct you can try to map a drive to the share from a different machine and specify the Mydom\spfarm username and password. Then try to create files/folders etc. if the drive maps ok.

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
Thomas GrassiSystems AdministratorAuthor Commented:
Robincm

First thanks for the fast reply.
This is definitely a permissions issue. How did you grant your Mydom\spfarm user access to the share and NTFS folder? Did you do it by adding the user to a group in Active Directory? If so you'll need to stop and restart the SQL server service to get it to pick up the new group membership

I added spfarm directly to the share permissions and the nTFS permissions

To verify the permissions are correct you can try to map a drive to the share from a different machine and specify the Mydom\spfarm username and password. Then try to create files/folders etc. if the drive maps ok.


Yes I tested that method I am mapped to the share from my computer and can create a file  folder modify them both and deleted anything in that folder  using spfarm account and password

Thoughts.
Robin CMSenior Security and Infrastructure EngineerCommented:
OK, so it is definitely the instance of SQL server trying to run the job that's having the permissions problems, and not the account. I'd be interested to know if restarting the SQL service makes any difference, if you've not already tried it.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Thomas GrassiSystems AdministratorAuthor Commented:
I also added SA account to the NTFS and Share Permissions same as SPFARM

should I add anyone else?

I can restart the SQL Services at days end
Robin CMSenior Security and Infrastructure EngineerCommented:
You only need to give share+folder access to the account that the SQL server service is running as (which I assume is the Mydom\spfarm account referenced in the event you posted above?).
Thomas GrassiSystems AdministratorAuthor Commented:
Robincm

Thanks for all your help

Got it working had to add Network Service account to the NTFS and Share permissions that is the service account that is running the SQL instances.

Good call..
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 SharePoint

From novice to tech pro — start learning today.