SQL Server - error 5 access denied

Question

I try to attach a database and get an "error 5 access denied" error. I changed the permisions on the folder for the user "NT Service\MSSQL$MS64BITSQLSERVER" and gave full access but the error is still there.

The SQL Server service logs on as "NT Service\MSSQL$MS64BITSQLSERVER"

I'm sure that is an problem with the access rights. Any further suggestions?

Thanks and regards

Possible duplicate of [SQL Server Operating system error 5: "5(Access is denied.)"](http://stackoverflow.com/questions/18286765/sql-server-operating-system-error-5-5access-is-denied) — Thanos Markou, May 24 '16 at 08:23
Add the Administrators Group to the file security permissions with full control for the Data file and the Log File. — gofr1, May 24 '16 at 08:27
No. But the user which starts the SSMS is an adminstrator as well. — knowledge, May 24 '16 at 08:28
@gofr1 Administrators group is already added with full access. Doesn't change anything. — knowledge, May 24 '16 at 08:29

score 0 · Answer 1 · answered May 24 '16 at 09:03

0

The user which connects to database via windows authentication is already an Admin. But I must gave the user additional explicit full access on the folder which contains the files (properties/security). After that the error 5 file access disappears.

answered May 24 '16 at 09:03

knowledge

941
1
11
26

SQL Server - error 5 access denied

1 Answers1