Error: Access is de...
 
Notifications
Clear all

Error: Access is denied for 'RESTORE' task on SQL Database

7 Posts
3 Users
0 Likes
1,373 Views
Posts: 18
Topic starter
(@kbdavis07)
Member
Joined: 8 years ago

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?

6 Replies
Posts: 1964
Admin
(@m-tiggelaar)
Noble Member
Joined: 8 years ago

Hello,

In this case the folder:
C:UsersSCPServerAppDataLocalTemp  needs read/write/modify for the user: SCPServer if i remember correctly.

Regards,

Marco

Reply
4 Replies
(@kbdavis07)
Joined: 8 years ago

Member
Posts: 18

That is what I had set before, that why I came here to see what needs to be done 🙂

Reply
Admin
(@m-tiggelaar)
Joined: 8 years ago

Noble Member
Posts: 1964

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)

Reply
(@kbdavis07)
Joined: 8 years ago

Member
Posts: 18

Adding Users seems to do the trick 🙂

Reply
Admin
(@m-tiggelaar)
Joined: 8 years ago

Noble Member
Posts: 1964

Ah thank you for that report 🙂
Hopefully we can get a manual up for that soon so it becomes more easy for everyone 🙂

Reply
Posts: 31
(@kailash)
Eminent Member
Joined: 8 years ago

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.

Reply
Share: