2011-03-25 10:47 AM - edited 2015-12-18 01:28 AM
I'm trying to restore a subsite from a site collection using SMSP 6 and I'm getting the following error log:
Path:Farm(Farm)\Microsoft SharePoint Foundation Web Application\SharePoint - spdev.domain.com443\DomainSP_Content1_sharepointdb
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED));
I've made sure to give appropriate access to agent service account.
Anyone having this issue or ideas?
2011-04-04 07:25 PM
Yes, I'm seeing this issue as well. Also have a customer who's seeing it. I see it while restoring at the item level.
Mon Apr 4 21:12:49 CDT [n6040-01a: app.log.err:error]: NA-SP2010: Item Version Level Restore SMSP 6.0: (10052) Restore: Plan: Full Farm Backup - Item Job: RS20110404211113 Control Agent: NA-SP2010 Farm: Farm(NA-SP2010:SHAREPOINT_CONFIG) SharePoint Version: SharePoint 2010 Components: 1 Start Time: 2011-04-04 21:11:13 Finish Time: 2011-04-04 21:14:50 Types of restore used: item in place restore Exceptions:
Mon Apr 4 21:12:49 CDT [n6040-01a: app.log.err:error]: NA-SP2010: Item Version Level Restore SMSP 6.0: (10052) Restore: 0 Exception Details: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Statistical Result: 1 MB data, 1(0) site collections, 0(0) sites, 0(0) lists, 0(0) items.
I've read over numerous articles on the NOW about which service accounts need which permission at either a SharePoint level and/or a SQL level and/or OS level. I'm curious which access you've given your agent service account.
2011-04-04 11:01 PM
I had the problem too.
Either set the smsp service account on the application pool or change the credential for the smsp agents active on the sharepoint servers. For my company it was easiest/best to change the credentials on the smsp agents and use the farm admin account used to install and configure sharepoint. After the change restores work.
2011-04-21 09:57 AM
I found out the solution to my problem with restoring individual items while overwriting existing. The trick was to set the SnapManager for Sharepoint Agent service to run as the same user that the SharePoint 2010 Timer service is running as. In my case, when I installed SQL and then SharePoint, I used sql2008 as the service account for the SQL 2008 installation and sp2010 for the Sharepoint 2010 service account. Through the SMSP interface, Control Panel -> Control Service -> Agent Monitor (tab) -> Configure.
2011-05-06 09:19 AM
Thanks for the feedback but I'm still getting the "ACCESS DENIED" error. Here are my settings:
I have a service account called svc_spapp and it has the following (based off of KB ID:3012702):
On the SQL side this account has:
I'm being able to mount the DB and obtain the data, it just doesn't look like it has the access to restore the file/site within the site collection.
2011-05-06 10:24 AM
Are you doing an in-place restore or out of place? The other suggestion is to enable the logs at the debug level and check the Media Service and Member Agent logs from the Log Manager.
2011-05-11 04:51 PM
I faced the same problem, and following the same KB shown by Reena, I was able to solve. It's a limitation on Microsoft IIS, so you have to use the same account you used to install SP.