SQL can't create files on drive d or e
Posted on 2011-02-22
When trying to create a database on our new SQL server ( with drive d set for data and e for log files ) I get the following message:
CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'D:\SQLDatabases\test.mdf'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5123)
Outside of SQL we can create files in the relevant folders. It makes no difference if I login using windows or SQL authentication. Also when trying to restore files from d or e SQL does not show the files in the browse window.