I have a vps and on it I install sql server express and host some sites. in same hard drive I locate web site content and Databases datafile. I chnage the permission of the root of drive and only Administrator and sytem have permission to read or write.
web sites work perfectly but I can't create any database on this drive.from SQL server management this drive dosnt show and I can't select folder on it for datafile location.
Which permission are needed by sql server to find a path and write file on it?