November 23, 2007 at 4:52 am
Hi,
I am getting following errors
I have a database A_BRK51003R43 and
its mdf files are in E:\MSSQL\Data folder and
log files are in f:\mssql\Log folder
This E drive and F drive there are 3 gorups
all the groups has full permissions on these folders
4 groups are
Administrators
Users
Risks
Shine
All these groups are given full acccess in both drives
when i detach this from Database only the person who detached
only able to access the log files
when i click the log files right clik i can see only the person who detached only is existing,
I need when i detach the DB all the groups should also have access
because soem time other person will again attach this file
when he does he is getting the following error
Access Denied-As his group is not having the permission
Could anyoen help on this issue
November 26, 2007 at 10:43 am
You indicate that the users in the groups have full rights to the actual drives (E and F) but what are the rights of these four groups in the SQL Server?
What is the roles given to the four groups (i.e. sysadmin...) I would check that.
November 28, 2007 at 9:06 pm
I would just reset the NTFS permissions, either by forcing the permissions from the parent folder to flow down to the children or by altering the permissions on the files directly.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
November 29, 2007 at 2:33 am
You need to check the actual permissions on the folders containing your database files. When SQL 2005 is installed, it will set its own permissions on the folders it uses.
As already suggested, you may need to reset folder permissions to gain access to the database files.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply