I have a share on a Windows 2003 ( server1 ) named sqlback.
The everyone one group has full control over this share.
Administrators, system, sa_SQL2k5 and the group dbrefresh all have full control to the sqlback folder and all sub folders and files.
The user test is a member of the dbrefresh group. Using the effective permissions tab on the 2003 box I can see that the user test has full control over the sqlback folder and all the files in it.
This is the only access that test has to server1.
However, if test tries to access the share using a UNC path, the message "Access is Denied" is displayed.
Looking at the security event log on server1, I can only see sucessfully logins, there are no failure audits that corespond to the access denied (there is also nothing on the workstation I am using to connect to the share).
Additionally, if you look at the Shared Folders snap-in and the Sessions node, I can see that the test user is connected to server1.
Even more interstingly, I can sucessfully map a drive to the share from the command prompt using net use. However, if I then dir the drive, the dir comes back with "File not found".
And now moving into the realm of bizare, I can actually write to share via the mapped drive from the command line.
For example if I do mkdir test the test folder will appear under the share(spotted using explorer on server1), however doing a dir from mapped drive still shows "File Not Found".
Also if I try and browse the mapped drive from explorer I will also get access denied.
I have tried adding the test users directly to the Administrators group on server1, however the problem still persists, so I am thinking there is issues at the share or network work communication level.
I am hoping some of the experts here have any ideas.
We have restricteive GPo which sets all the user rights assignment values, so I am guessing it is something with this that is causing the problem. I will list out all the settings if it is helpful, but I am hoping someone has experienced this before and can narrow it down a bit first!