SQLTeam.com | Weblogs | Forums

Install SQL 2014 data/log to root drive problem


#1

Hi, folks,

I got in this installation dilemma, and need your help to move forward.

It is a new VM windows server 2012 R2. I installed SQL 2014 Ent by accidentally specified User db and tempdb log directory to F:\ and backup directory to H:.

Then my restore command failed. and under file explorer the F and H drives said is not accessible, access is denied. And under properties, showed 0 bytes size.

It turned out, SQL tightens the ACL for default data/log directories to exclude broad access for all authenticated users. If the drive root is chosen as the default data/log location then SQL will tighten the root ACL and thus effectively locking down the whole volume.
The recommended course of action is to always use a subdirectory to store SQL data/log files.

My question is what options do I have now to correct above installation?

Thanks!


#2

for instance, I have tried from within SSMS, server properties, database settings. That seems do not work.
Installation repair has not such option.

Next step, unistall sql server?


#3

uninstall then reinstall solved the problem. There may be other options, but running out of time.

thanks!