access to path is enied sql server 2017 developer edition

Here we can see that only one account has permission to the 'filename.mdf' file because that was the account that was used to detach the database. Right click on the 'filename.mdf' file and select properties to check the permissions of the mdf file. When we detach database files, the owner becomes the person who did the detach command, so to resolve the issue we need to change or add the other login as the owner of the mdf and ldf files. So the files, when detached, were owned by the first login, but the attach failed because the login that was used was not the owner of the mdf and ldf files.

You get this error because two different logins did the detach and attach operations. I just wanted to add this information as well. To keep the original permissions in tact you should take the database offline, then detach, then attach in that order like so: USE So later on when I tried to attach the db using the sa account, it threw the 'access denied' error. After doing that my windows user was the only one that had any permissions to the. I ran into this problem because I used SSMS to connect to the database (doesn't matter which sql server account) and detached the database. mdf file and double check the permissions. So do as others have said and right click your. Boom, all permissions gone just like that. mdf file had which included the user SQLServerMSSQLUser$$ and the Administrators account get overwritten by whichever windows user you are logged in as (not sql server user). I'd like to add additional info to the answers that were posted.īe careful when detaching the database because the windows user you are logged in as becomes the only user with permissions to the. That sounds weird to me, but I can reproduce it over and over again, so I have concluded that it is the answer. So, it looks as though the error occurs because some code (either in SQL Server or Management Studio) checks for the permissions that the user account holds, but it doesn't go so far as to check group permissions that the user account inherits. (oh, and yes, I checked the local groups on this machine, and I verified that my domain account is indeed a member of the local admins group). However, if I grant the same file permissions that the local admin group has directly to my Domain Account, then I can attach with no problems. If I try to do the attach, connect to SQL Server as me (where I am in the admins group), it fails with the NTFS problem. However, it had those permissions through group membership (the Local Administrators group had permissions, and my account is a member of local admins). The account that I was using had full control NTFS permissions to the mdf and ldf files. Further, it looks kind of bug-like (and it's repeatable).

It was an NTFS permission problem, and not a SQL problem. Some of you helped to lead me to the answer.

Access to path is enied sql server 2017 developer edition