Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

Can not find security principal to add to folder permission in sql data

In the default location for the sql2012 data      (C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA)     , when I check the folder permissions, I see a principal listed as MSSQLSERVER.  screenshot attached.

in the folder where I am moving the databases to.... there is no MSSQLSERVER principal that has access to the new location... this makes sense.... the problem is... I can't find the MSSQLSERVER principal in the pick list to give it permissions to the new location where I am placing the db files.... it's not there.  I have checked in domain and local.  screenshot attachedUser generated imageUser generated imageanyone offer any insight into this.
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

You can not add these account explicitly, These are sql server service group and sql server service is the member of these group. You can find these group in local group. You dont need to give permissions. you are moving database files to you can give permissions to sql service logon account.

if sql server service is running by local system account you dont need to give permissions on the folder.
In addition you can the same added in SQL serve logins.

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial