Hi,
I am getting the following
Error executing 'RESTORE' task on 'test' SQL_DATABASE --->
System.Web.Services.Protocols.SoapException: Server was unable to process request. --->
System.Data.SqlClient.SqlException:
Cannot open backup device 'C:UsersSCPServerAppDataLocalTempGTFS-Beta.bak'.
Operating system error 5(Access is denied.).
What permissions does the AppData folder need?
Hello,
In this case the folder:
C:UsersSCPServerAppDataLocalTemp needs read/write/modify for the user: SCPServer if i remember correctly.
Regards,
Marco
That is what I had set before, that why I came here to see what needs to be done 🙂
hmm well a quick solution would be to allow everyone but that doesn't seem too secure haha.
can you try the mssql user? (found in the services settings of mssql)
Ah thank you for that report 🙂
Hopefully we can get a manual up for that soon so it becomes more easy for everyone 🙂
Apart from SCPServer user, you need to make sure that the Logon user under which SQL server is running has read, write, modify permissions on this folder. If you have SQL express with default installation, it should be NT ServiceMSSQL$SQLEXPRESS by default.
