Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't add file permissions need to relocate SQL Server 2012 files to separate drive

After installing a new SQL Server 2012 Instance, I wish to move the database files to a separate drive. When I perform File->Properties on the target location and then click Security->Edit->Add->Advanced, select Location=MachineName, and click find, I see only the form related to analysis services:

SQLServerMSASUser$MachineName$InstanceName

I think the permission I really need is this one which I can see exists in the default C: drive location:

MSSQL$InstanceName

When I attempt to just enter it directly it is unrecognized. If I set the directory to "Everyone" and then move the database there (using a restore) it works and shows the above permission on the mdf file. How can I set that permission on the parent directory when it isn't showing up as an available entry in the list. Thanks!

like image 851
crokusek Avatar asked May 29 '12 20:05

crokusek


1 Answers

Here's the relevant MSDN article: Configure File System Permissions for Database Engine Access

like image 172
Reality Extractor Avatar answered Sep 18 '22 20:09

Reality Extractor