We install SQL Express on various OSs. We enable filestream for TSQL access using the installer when we can (or via filestream_enable.vbs). We then confirm we have RsFXVersion 0103 active using filestream_enable.vbs...we had problems with 0102. Then run sp_configure filestream_access_level, 1. Then ALTER DATABASE whatever ADD FILEGROUP [BLOB] CONTAINS FILESTREAM; then ALTER DATABASE whatever ADD FILE ( NAME = N'BLOB', FILENAME = N'whatever' ) TO FILEGROUP [BLOB]. On most machines this works just fine, but occasionally it simply hangs the machine on the ADD FILE. The machine is totally hung, can't do anything but cycle power, which is similar to this (http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a8d3e5a1-a93d-45e1-b441-54b484255a28).
I originally submitted this (http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d53f9ef8-33b0-40f7-8dbf-cc91392c05d0) when it appeared to be related to webroot being installed and figured it was a one-off situation. Since then it also appears to be Kaspersky A/V as well. Same symptoms, same result. I started doing more methodical testing and it does seem AV-related.
I determined this by running wmic /NAMESPACE:\\root\securitycenter PATH AntiVirusProduct (or the equivalent command which is different for each OS). This happens on every OS and is reproducible.
1)Install Kaspersky 220.127.116.116 or webrootr Client Security 3.5
2)run wmic command above and ensure onAccessScanningEnabled = TRUE
3)Run SQL steps outlined above and machine will hang.
4)Disable scanning (verify with wmic), follow SQL steps, and note machine *STILL* hangs.
5)Totally uninstall SQL Server and reinstall with scanning disabled and it *STILL* hangs.
6)Totally uninstall SQL Server *and* totally uninstall A/V and reinstall sql and it works.
Seems ridiculous to me that disabling scanning still means a hang. Is there anything you guys can do/recommend to avoid the hang at a minimum or, better yet, get filestream to work without a total reinstall?
Since the machines are always totally hung I can't even look at processmon/filemon. No logs, nothing in Profiler, eventvwr, debug files, whatever. I have no clue how to proceed (except Step 6 above). Is this a bug in RsFx? An overly-aggressive A/V vendor? Something else?