what is the best permission should I assign for sql server folder?
Can anyone advise me here what is the best permission should I assign in sql server folder, what is the best recommended by Microsoft ?
RiteshShah
do you want to create some file from SQL Server and that is why asking for permission? or your goal is something else, please bit elaborate your question. as long as SQL Server's folder under Program file, you don't need to give any additional permission, and if you want to access some folder by SQL Server job than you have to give proper permission to that folder so that the user of your job can access that folder.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sql server folder is not in program files, I must ensure that this server has stringent access as the information is really really sensitive.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok,
I presume that u explained me on service account which I use to start the services.
and this user account already has sysadmins in sql server, do we need still for diskadmin roles?
I presume that u explained me on service account which I use to start the services.
and this user account already has sysadmins in sql server, do we need still for diskadmin roles?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.