Hi
I have Solidcp and installed SQL server 2014 on it. I cannot restore database because it responded following error :
ERROR: 'Microsoft SQL Server 2014' RestoreDatabase
System.Data.SqlClient.SqlException (0x80131904): Cannot open backup device 'C:UsersSCPServerAppDataLocalTemptest.bak'. Operating system error 5(Access is denied.).
RESTORE FILELIST is terminating abnormally.
My SCPServer does have full access to that folder.:
I attached share setting for that folder, can you please say how can I resolve this issue?
any idea?!
Does SolidCP have issue in restore database?!
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
This should be due to permissions issue. Check the "log on As" tab under "Services" for your SQL server. If it is running as NT ServiceMSSQL$SQLEXPRESS, assign read, write, modify permissions to this user for C:UsersSCPServerAppDataLocalTemp folder.
