The solution to the problem of attaching .MDF permissions to sqlserver
Sqlserver appends the solution to the problem of .MDF permissions. In view of this problem, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.
Problem: when the .MDF file is attached to the database, the physical file cannot be opened. Operating system error 5: "5 (access denied)" error: 5120.
Solution: the current account of the database does not have enough permissions on the folder where .MDF files are stored, and the folder permission role is added to Everyone. And give read and write permission.
So much for the solution to the problem of additional .MDF permissions for sqlserver. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.