Enumerate drives available to SQL Server
I'm guessing you're actually running on a clustered instance.

EXEC master..xp_fixeddrives is returning all the drives that the underlying OS is aware of, so a lot aren't available to your cluster instance

use:


SELECT * FROM sys.dm_io_cluster_shared_drives


instead, which will just list the ones available to your instance