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
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
Thanks Trevor
it worked
Thanks Trevor it worked for me too.
Have to found the user on services.
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?
