MS SQL backup resto...
 
Notifications
Clear all

MS SQL backup restore access denied

5 Posts
4 Users
0 Likes
2,879 Views
Posts: 103
Topic starter
(@boushehri)
Estimable Member
Joined: 5 years ago

Hello

i am using 1.4.2 with MS SQL 2017 on windows 2019

and setting for MS SQL in Solidcp is below :

User can Create Database normally and it is ok , but on Backup and Restore they get below errors :

on Backup Database :

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot open backup device 'C:UsersSCPServerAppDataLocalTempfarazamo.bak'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.

and on restore Database :

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot open backup device 'C:UsersSCPServerAppDataLocalTempfarazamoozdb.bak'. Operating system error 5(Access is denied.).
RESTORE FILELIST is terminating abnormally.

Whats wrong?

Best Regards

4 Replies
Posts: 1456
Admin
(@trobinson)
Noble Member
Joined: 8 years ago

Hello,

It sounds like your permissions in C:UsersSCPServerAppDataLocalTemp need to be  adjusted to give the user running your MsSQL server (Found in services) full access to this folder.

This will normally be with the instance name. With SQLExpress it would default to: NT ServiceMSSQL$SQLEXPRESS

Kind Regards,

Trevor Robinson

Reply
Posts: 103
Topic starter
(@boushehri)
Estimable Member
Joined: 5 years ago

Thanks Trevor

it worked

Reply
Posts: 1
(@exoid)
New Member
Joined: 5 years ago

Thanks Trevor it worked for me too.

Have to found the user on services.

Reply
Posts: 66
(@dolphyn5)
Trusted Member
Joined: 7 years ago

Same problem here, running SQL Server 2016 on Windows Server 2012 R2, but for some reason tweaking the permissions on the folder didn't work. (EDIT: It worked after I tried "everyone" permission; turns out I'd made a mistake!)

I don't understand why it's trying to write to C:UsersSCPServerAppDataLocalTemp when I've configured the database server to backup to a folder under E:Backup. Any ideas?

Reply
Share: