I am unable to restore a DB file, I get eh following error:
Stack Trace: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Exception: Error executing ‘RESTORE’ task on ‘nyccharterdatacentral’ SQL_DATABASE —> System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Cannot open backup device ‘C:\Users\SCPServer\AppData\Local\Temp\8aa6a0ae-c506-482e-9f9c-dd88295ddd73\REDATCTED.bak’. Operating system error 5(Access is denied.).
RESTORE FILELIST is terminating abnormally.
I checked the folder C:\Users\SCPServer, and it has FULL CONTROL on both the users: SCPServer, MSSQLSERVER
I am at a complete loss as to what user the CP is using that does not have access to this folder…
::Sigh:: Crappy crap crap …
So, I was applying the permissions on the local machine that was running the SCP Website Portal. I thought it was complaining about local permissions. With all the machines involved, I got turned around. It didn’t occur to me that it was complaining about the permissions on the remote SQL system, not the local one. I logged into the remote SQL Server machine, added SQLSERVER to have Full Control on the Temp folder, and it worked.
I apologize for taking your time. I am working with so many servers with this mandatory upgrade migration for my company that I am completely turned around on what server needs what and where.
That kind of defeats the purpose of using the CP. The problem I posted is about the CP, not looking for a solution outside of the CP. But thank you for your input.
It sounds like your permissions in C:\Users\SCPServer\AppData\Local\Temp need to be adjusted to give the user running your MsSQL server (Found in services under SQL Server (INSTANCENAME) ) full access to this folder.
This will normally be with the instance name. With SQLExpress it would default to: NT Service\\MSSQL$SQLEXPRESS
If you have selected to use an local account then it will be that.
Thank you for your input. However, in my OP I already mentioned that SCPServer, MSSQLSERVER have Full Control over the folder. Those permissions apparently are not the problem.
In your OP you mentioned just the C:\Users\SCPServer folder, did you verify the appdata\local\temp has it too? (not all folders inherit).
And if everything else fails just give the user “Everyone” full permissions to the temp folder. (if not only to test)
Yes, I verified that all the child folders are inheriting from the parent. I am attaching an image of the permissions on the folder here.
I also just did as you suggested, gave EVERYONE “Full Control” of the Temp folder. Tried the restore again, same error.
I am going to try a reinstall of SCP. I just have a nagging feeling something didn’t install correctly. I’ll update after the reinstall.
- Views610 times
- Answers8 answers