Via the Failover Cluster Manager, I recently added a new disk to an existing SQL Server 2008 R2 Cluster, running on Windows Server 2012 R2.
When attempting to create a database on this new storage, I get the following error:
Msg 5123, Level 16, State 1, Line 1 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 'J:\DATA\mydatabase.mdf'. Msg 1802, Level 16, State 4, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
I can manually add a file to J:\data
The new storage can be moved between nodes without any errors
The SQL Server Service Account has full control over the entire J:\ drive
The SQL Server Service Account has full control over the J:\DATA Here is a layout of the drive, you will notice that DATA is a seperate volume mounted inside J:\
Can someone please help me figure out why I am getting this error?
From James, if I add a subdirectory to data, then the create database command works
CREATE DATABASE [MCO_DB] ON PRIMARY ( NAME = N'MYDATABASE_DB', FILENAME = N'J:\DATA\MYDATABASE\MYDATABASE_DB.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) LOG ON ( NAME = N'MYDATABASE_DB_log', FILENAME = N'J:\TRN\MYDATABASE_DB_1.ldf' , SIZE = 1024KB , FILEGROWTH = 10%) GO