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?
Hello,
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) 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