Unable to Create In-Memory OLTP File on AWS FSX

Here’s an example SQL statement to add a memory optimized file. This works fine in a non-clustered environment, but fails in a clustered environment with FSx backing storage.

USE [master]

GO

— Memory Optimized File

ALTER DATABASE [Test] ADD FILE ( NAME = N’TestMemory’, FILENAME = N’\AWSFSXShareLocation.myDomain.net\MYSQLServerName\sqldata\TestMemory’ ) TO FILEGROUP [MemoryOptimizedFG]

GO

Cannot use file ‘\AWSFSXShareLocation.myDomain.net\MYSQLServerName\sqldata\TestMemory’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

Msg 5184, Level 16, State 2, Line 4

Cannot use file \AWSFSXShareLocation.myDomain.net\MYSQLServerName\sqldata\TestMemory’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

Msg 5009, Level 16, State 14, Line 4

One or more files listed in the statement could not be found or could not be initialized.

We have looked at https://aws.amazon.com/blogs/storage/simplify-your-microsoft-sql-server-high-availability-deployments-using-amazon-fsx-for-windows-file-server/ and https://aws.amazon.com/about-aws/whats-new/2021/05/aws-launch-wizard-adds-support-for-sql-server-always-on-failover-cluster-instances-deployed-on-amazon-fsx-for-windows-file-server/

Nowhere do any instructions talk about making the UNC share from AWS fsx storage a dependency in the sql cluster. Creating files for "regular" databases works just fine.