error in restore da...
 
Notifications
Clear all

error in restore database

4 Posts
3 Users
0 Likes
1,499 Views
Posts: 14
Topic starter
(@solicpuser)
Active Member
Joined: 7 years ago

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?

3 Replies
Posts: 14
Topic starter
(@solicpuser)
Active Member
Joined: 7 years ago

any idea?!

Does SolidCP have issue in restore database?!

Reply
Posts: 1456
Admin
(@trobinson)
Noble Member
Joined: 8 years ago

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

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

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.

Reply
Share: