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!
Here's the relevant MSDN article: Configure File System Permissions for Database Engine Access
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With