fsutil fsinfo drive: can’t see winfsp drive as SQL Server account

Tomas Dalebjörk

unread,

Feb 15, 2021, 6:02:01 PM2/15/21

to WinFsp

Hi

I have mounted the winfsp drive as administrator, and can see the drives using fsutil tool
but when I tried to list the drives from my SQL Server, the drive is not listed?
and I cant see that the winfsp is queried?

SQL> exec xp_cmdshell ‘fsutil fsinfo drive’
SQL> go

why isn’t the drive letter from winfsp available and visible for the ‘NT USERS\MSSQLSERVER’ account?

Regards Tomas

Sent from my iPhone

Dalebjörk, Tomas

unread,

Feb 16, 2021, 5:37:36 AM2/16/21

to Bill Zissimopoulos, WinFsp

Hi Bill,

I tried also the memfs sample driver, and that resulted in same limitations, that the SQL Server can't see the drives.

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>fsutil fsinfo drives

Drives: C:\ D:\ E:\ X:\

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>sqlcmd
1> exec xp_cmdshell 'fsutil fsinfo drives'
2> go
output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Drives: C:\ D:\ E:\
NULL

(3 rows affected)
1>

The debug log file from memfs:

C:\Program Files (x86)\WinFsp\bin>memfs-x64.exe -d -1 -D - -m X: -u \memfs\X
memfs -t -1 -n 1024 -s 16777216 -u \memfs\X -m X:
The service memfs has been started.
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\Desktop.ini", FILE_OPEN, CreateOptions=60, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=120089, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=c0000034[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\Desktop.ini", FILE_OPEN, CreateOptions=60, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=120089, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=c0000034[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\AutoRun.inf", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=c0000034[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE6987C60: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE6987C60: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE6987C60: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
memfs-x64[TID=1288]: FFFF9A8EE6987C60: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE6987C60: >>QueryVolumeInformation
memfs-x64[TID=1288]: FFFF9A8EE6987C60: <<QueryVolumeInformation IoStatus=0[0] VolumeInfo={TotalSize=4:0, FreeSize=3:ff000000, VolumeLabel="MEMFS"}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
memfs-x64[TID=1288]: FFFF9A8EE7098940: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000198[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
memfs-x64[TID=1288]: FFFF9A8EE7098940: <<Create IoStatus=0[1] UserContext=000001BECE108990, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:0, FileSize=0:0, CreationTime=2021-02-16T10:32:49.566Z, LastAccessTime=2021-02-16T10:32:49.566Z, LastWriteTime=2021-02-16T10:32:49.566Z, ChangeTime=2021-02-16T10:32:49.566Z, IndexNumber=0:1}
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: >>Close 000001BECE108990
memfs-x64[TID=1288]: FFFF9A8EE5C7ED50: <<Close IoStatus=0[0]
The service memfs has been stopped.

C:\Program Files (x86)\WinFsp\bin>

Den 2021-02-16 kl. 11:30, skrev Dalebjörk, Tomas:

Hi Bill,
How are you doing?
We are trying to roll out our WinFsp based solution that we call SPFS to our governmental institutes here in Sweden, but we run into an issue.
Not sure were this issue is related, as we couldn't find any WinFsp functions getting called in the trace logs.

I have mounted the winfsp drive as administrator, and can see the drives using fsutil tool

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>fsutil fsinfo drives
Drives: C:\ D:\ E:\ Z:\
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>

but when I tried to list the drives from my SQL Server, the drive is not listed?

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>sqlcmd
1> exec xp_cmdshell 'fsutil fsinfo drives'
2> go
output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Drives: C:\ D:\ E:\
NULL

(3 rows affected)
1>

But I can't see any indications that the WinFsp driver is being called in the log files

why isn’t the drive letter from winfsp available and visible for the ‘NT Service\MSSQLSERVER’ account?

Even if I add the 'NT Service\MSSQLSERVER' credentials on the volume, it is still not listed and available under the MS SQL Server account.

How do I troubleshoot, and resolve that the WinFsp drive is not visible under the 'NT Service\MSSQLSERVER' account?

C:\Users\Administrator\Desktop\repos\spictera\WIN-SPFS>spfs -p \\SPFS\X -m Z: -d -1 -D -
2021-02-16.11:10:17 SP99999D spgs:FspLoad:LEAVING:return FspServiceRun()
2021-02-16.11:10:17 SP99999D SvcStart():ENTRY
2021-02-16.11:10:17 SP99999D SvcStart():mountpoint:\\localhost\X
2021-02-16.11:10:17 SP99999D SvcStart():filespace:\\localhost\X
2021-02-16.11:10:17 SP99999D SvcStart():dataspace:\\localhost\X
2021-02-16.11:10:17 SP99999D SvcStart():driveletter:Z
...
The service spfs has been started.
spfs[TID=0c78]: FFFF9A8EE5E66BC0: >>QueryVolumeInformation
..
2021-02-16.11:10:22 SP99999E GetVolumeInfo(\\localhost\X:1):releaseworker()
spfs[TID=0c78]: FFFF9A8EE5E66BC0: <<QueryVolumeInformation IoStatus=0[0] VolumeInfo={TotalSize=300:0, FreeSize=300:0, VolumeLabel="SPICTERA backup data"}
spfs[TID=0c78]: FFFF9A8EE5C29950: >>Create [UT---C] "\autorun.inf", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F4[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=1254]: FFFF9A8EE5A0F470: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F8[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=1254]: FFFF9A8EE5A0F470: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:22.189Z, LastAccessTime=2021-02-16T10:10:22.189Z, LastWriteTime=2021-02-16T10:10:22.189Z, ChangeTime=2021-02-16T10:10:22.189Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5EC8960: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE5EC8960: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5EC8960: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F8[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
spfs[TID=1254]: FFFF9A8EE5EC8960: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:22.297Z, LastAccessTime=2021-02-16T10:10:22.297Z, LastWriteTime=2021-02-16T10:10:22.297Z, ChangeTime=2021-02-16T10:10:22.297Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5A0F470: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE5A0F470: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5EC8960: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F8[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
spfs[TID=1254]: FFFF9A8EE5EC8960: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:22.329Z, LastAccessTime=2021-02-16T10:10:22.329Z, LastWriteTime=2021-02-16T10:10:22.329Z, ChangeTime=2021-02-16T10:10:22.329Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5A0F470: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE5A0F470: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5EC8960: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F8[PID=d48], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=1254]: FFFF9A8EE5EC8960: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:22.329Z, LastAccessTime=2021-02-16T10:10:22.329Z, LastWriteTime=2021-02-16T10:10:22.329Z, ChangeTime=2021-02-16T10:10:22.329Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5A0F470: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE5A0F470: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5C29950: <<Create IoStatus=c0000034[0]
spfs[TID=0c78]: FFFF9A8EE5C29950: >>Create [UT---C] "\autorun.inf", FILE_OPEN, CreateOptions=60, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F4[PID=d48], DesiredAccess=120089, GrantedAccess=0, ShareAccess=7
spfs[TID=0c78]: FFFF9A8EE5C29950: <<Create IoStatus=c0000034[0]
spfs[TID=0c78]: FFFF9A8EE5C29950: >>Create [UT---C] "\autorun.inf", FILE_OPEN, CreateOptions=60, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F4[PID=d48], DesiredAccess=120089, GrantedAccess=0, ShareAccess=7
spfs[TID=0c78]: FFFF9A8EE5C29950: <<Create IoStatus=c0000034[0]
spfs[TID=0c78]: FFFF9A8EE5C29950: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F4[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=0c78]: FFFF9A8EE5C29950: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:22.890Z, LastAccessTime=2021-02-16T10:10:22.890Z, LastWriteTime=2021-02-16T10:10:22.890Z, ChangeTime=2021-02-16T10:10:22.890Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5EC8960: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=0c78]: FFFF9A8EE5EC8960: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5EC8960: >>Create [UT---C] "\AutoRun.inf", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=00000000000009F4[PID=d48], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=0c78]: FFFF9A8EE5EC8960: <<Create IoStatus=c0000034[0]
spfs[TID=1254]: FFFF9A8EE5891D20: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=000000000000061C[PID=d54], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=1254]: FFFF9A8EE5891D20: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:48.813Z, LastAccessTime=2021-02-16T10:10:48.813Z, LastWriteTime=2021-02-16T10:10:48.813Z, ChangeTime=2021-02-16T10:10:48.813Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5891D20: >>QueryVolumeInformation
spfs[TID=1254]: FFFF9A8EE5891D20: <<QueryVolumeInformation IoStatus=0[0] VolumeInfo={TotalSize=300:0, FreeSize=300:0, VolumeLabel="SPICTERA backup data"}
spfs[TID=1254]: FFFF9A8EE4EA9380: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE4EA9380: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5891D20: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=000000000000061C[PID=d54], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=0c78]: FFFF9A8EE5891D20: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:48.813Z, LastAccessTime=2021-02-16T10:10:48.813Z, LastWriteTime=2021-02-16T10:10:48.813Z, ChangeTime=2021-02-16T10:10:48.813Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5A0F470: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=0c78]: FFFF9A8EE5A0F470: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5891D20: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=000000000000061C[PID=d54], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=1254]: FFFF9A8EE5891D20: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:48.813Z, LastAccessTime=2021-02-16T10:10:48.813Z, LastWriteTime=2021-02-16T10:10:48.813Z, ChangeTime=2021-02-16T10:10:48.813Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5E66BC0: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE5E66BC0: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5E66BC0: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=000000000000061C[PID=d54], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=1254]: FFFF9A8EE5E66BC0: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:49.563Z, LastAccessTime=2021-02-16T10:10:49.563Z, LastWriteTime=2021-02-16T10:10:49.563Z, ChangeTime=2021-02-16T10:10:49.563Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5891D20: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=1254]: FFFF9A8EE5891D20: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5E66BC0: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=000000000000061C[PID=d54], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
spfs[TID=0c78]: FFFF9A8EE5E66BC0: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF851DD5A0, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:10:49.578Z, LastAccessTime=2021-02-16T10:10:49.578Z, LastWriteTime=2021-02-16T10:10:49.578Z, ChangeTime=2021-02-16T10:10:49.578Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE4EA9380: >>Close 0000000000000000:000001EF851DD5A0
spfs[TID=0c78]: FFFF9A8EE4EA9380: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5891D20: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=1034], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=0c78]: FFFF9A8EE5891D20: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:38.838Z, LastAccessTime=2021-02-16T10:13:38.838Z, LastWriteTime=2021-02-16T10:13:38.838Z, ChangeTime=2021-02-16T10:13:38.838Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5891D20: >>QueryVolumeInformation
spfs[TID=0c78]: FFFF9A8EE5891D20: <<QueryVolumeInformation IoStatus=0[0] VolumeInfo={TotalSize=300:0, FreeSize=300:0, VolumeLabel="SPICTERA backup data"}
spfs[TID=0c78]: FFFF9A8EE5E66EA0: >>Close 0000000000000000:000001EF83699220
spfs[TID=0c78]: FFFF9A8EE5E66EA0: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5891D20: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=1034], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=1254]: FFFF9A8EE5891D20: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:38.869Z, LastAccessTime=2021-02-16T10:13:38.869Z, LastWriteTime=2021-02-16T10:13:38.869Z, ChangeTime=2021-02-16T10:13:38.869Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5A0F470: >>Close 0000000000000000:000001EF83699220
spfs[TID=1254]: FFFF9A8EE5A0F470: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5891D20: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=200000, FileAttributes=0, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=1034], DesiredAccess=80, GrantedAccess=0, ShareAccess=7
spfs[TID=0c78]: FFFF9A8EE5891D20: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=80, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:38.869Z, LastAccessTime=2021-02-16T10:13:38.869Z, LastWriteTime=2021-02-16T10:13:38.869Z, ChangeTime=2021-02-16T10:13:38.869Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5BD2010: >>Close 0000000000000000:000001EF83699220
spfs[TID=0c78]: FFFF9A8EE5BD2010: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5F90B80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=0c78]: FFFF9A8EE5F90B80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:39.634Z, LastAccessTime=2021-02-16T10:13:39.634Z, LastWriteTime=2021-02-16T10:13:39.634Z, ChangeTime=2021-02-16T10:13:39.634Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5F7BAB0: >>Close 0000000000000000:000001EF83699220
spfs[TID=0c78]: FFFF9A8EE5F7BAB0: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5F90B80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=1254]: FFFF9A8EE5F90B80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:39.634Z, LastAccessTime=2021-02-16T10:13:39.634Z, LastWriteTime=2021-02-16T10:13:39.634Z, ChangeTime=2021-02-16T10:13:39.634Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5E66EA0: >>Close 0000000000000000:000001EF83699220
spfs[TID=1254]: FFFF9A8EE5E66EA0: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5F90B80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
spfs[TID=0c78]: FFFF9A8EE5F90B80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:39.634Z, LastAccessTime=2021-02-16T10:13:39.634Z, LastWriteTime=2021-02-16T10:13:39.634Z, ChangeTime=2021-02-16T10:13:39.634Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5A0F470: >>Close 0000000000000000:000001EF83699220
spfs[TID=0c78]: FFFF9A8EE5A0F470: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5F7CA80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=0c78]: FFFF9A8EE5F7CA80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:40.463Z, LastAccessTime=2021-02-16T10:13:40.463Z, LastWriteTime=2021-02-16T10:13:40.463Z, ChangeTime=2021-02-16T10:13:40.463Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5F7CA80: >>QueryVolumeInformation
spfs[TID=0c78]: FFFF9A8EE5F7CA80: <<QueryVolumeInformation IoStatus=0[0] VolumeInfo={TotalSize=300:0, FreeSize=300:0, VolumeLabel="SPICTERA backup data"}
spfs[TID=0c78]: FFFF9A8EE4EA9380: >>Close 0000000000000000:000001EF83699220
spfs[TID=0c78]: FFFF9A8EE4EA9380: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5F7CA80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=1254]: FFFF9A8EE5F7CA80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:40.478Z, LastAccessTime=2021-02-16T10:13:40.478Z, LastWriteTime=2021-02-16T10:13:40.478Z, ChangeTime=2021-02-16T10:13:40.478Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE5F7BAB0: >>Close 0000000000000000:000001EF83699220
spfs[TID=1254]: FFFF9A8EE5F7BAB0: <<Close IoStatus=0[0]
spfs[TID=0c78]: FFFF9A8EE5F7CA80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=21, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=3
spfs[TID=0c78]: FFFF9A8EE5F7CA80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:40.478Z, LastAccessTime=2021-02-16T10:13:40.478Z, LastWriteTime=2021-02-16T10:13:40.478Z, ChangeTime=2021-02-16T10:13:40.478Z, IndexNumber=0:0}
spfs[TID=0c78]: FFFF9A8EE5E66EA0: >>Close 0000000000000000:000001EF83699220
spfs[TID=0c78]: FFFF9A8EE5E66EA0: <<Close IoStatus=0[0]
spfs[TID=1254]: FFFF9A8EE5F7CA80: >>Create [UT---C] "\", FILE_OPEN, CreateOptions=800021, FileAttributes=10, Security=NULL, AllocationSize=0:0, AccessToken=0000000000000240[PID=9e4], DesiredAccess=100000, GrantedAccess=0, ShareAccess=0
spfs[TID=1254]: FFFF9A8EE5F7CA80: <<Create IoStatus=0[1] UserContext=0000000000000000:000001EF83699220, GrantedAccess=100000, FileInfo={FileAttributes=10, ReparseTag=0, AllocationSize=0:1000, FileSize=0:1000, CreationTime=2021-02-16T10:13:40.478Z, LastAccessTime=2021-02-16T10:13:40.478Z, LastWriteTime=2021-02-16T10:13:40.478Z, ChangeTime=2021-02-16T10:13:40.478Z, IndexNumber=0:0}
spfs[TID=1254]: FFFF9A8EE4EA9380: >>Close 0000000000000000:000001EF83699220
spfs[TID=1254]: FFFF9A8EE4EA9380: <<Close IoStatus=0[0]

Bill Zissimopoulos

unread,

Feb 16, 2021, 7:03:23 PM2/16/21

to Tomas Dalebjörk, WinFsp

When using SQL server I recommend mounting drives using the Mount Manager. This requires running your file systems with Administrator privileges and using the syntax \\.\X: rather than X: when mounting.

Bill

--
You received this message because you are subscribed to the Google Groups "WinFsp" group.
To unsubscribe from this group and stop receiving emails from it, send an email to winfsp+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/winfsp/94BF0092-26AD-4401-8C88-094F78F604EB%40gmail.com.

Tomas Dalebjörk

unread,

Feb 17, 2021, 2:35:00 PM2/17/21

to Bill Zissimopoulos, WinFsp

thanks Bill

sorry for a perhaps stupid question, but what is Mount Manager?
I know Disk Manager, but WinFsp is a file system, right? so I assume nothing can be mounted from there

regards Tomas

Sent from my iPhone

> On 17 Feb 2021, at 01:03, Bill Zissimopoulos <bill...@navimatics.com> wrote:
>
> When using SQL server I recommend mounting drives using the Mount Manager. This requires running your file systems with Administrator privileges and using the syntax \\.\X: rather than X: when mounting.

Bill Zissimopoulos

unread,

Feb 17, 2021, 3:41:01 PM2/17/21

to Tomas Dalebjörk, WinFsp

The Mount Manager is a Windows component that is used to manage persistent drives (like C:).

In general WinFsp file systems do not use (or need) the Mount Manager as WinFsp knows how to create drives. However some applications (notably SQL Server) misbehave if they encounter a disk file system that is not on a drive managed by the Mount Manager. For this reason WinFsp also supports the capability to create drives via the Mount Manager (rather than directly).

To create a Mount Manager drive use the syntax \\.\X: (rather than X:).

The caveats are:

- Mount Manager drives are always global (i.e. they cannot be local to the user session).

- Mount Manager drives require administrator privileges in order to be created.

- Mount Manager drives cannot be created for network file systems. (Please note that this is from memory and I may be wrong on this last one.)

Bill

Tomas Dalebjörk

unread,

Feb 17, 2021, 3:56:51 PM2/17/21

to Bill Zissimopoulos, WinFsp

thanks Bill

Sent from my iPhone

> On 17 Feb 2021, at 21:41, Bill Zissimopoulos <bill...@navimatics.com> wrote:
>
> The Mount Manager is a Windows component that is used to manage persistent drives (like C:).

Reply all

Reply to author

Forward