Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SQL 2012 Server, SP4 removes reg key FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT causing filestream error

SQL Server 2012 Standard with filestream enabled
Windows 2012 R2 6.3, build 9600 on VMware ESXi 6.0.0, 5224934

Upgraded SQL 2012 SP3 (11.3.6251.0) to SP4 (11.4.7001.0)
During upgrade reg key FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT was removed causing filestream error

From upgrade log:

(01) 2017-12-28 22:09:21 SQLEngine: : Entered RemoveFSCTLInRegistry.
(01) 2017-12-28 22:09:21 SQLEngine: : RemoveFSCTLInRegistry: Removing value FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT under System\CurrentControlSet\Services\LanmanServer\Parameters\FsctlAllowList
(01) 2017-12-28 22:09:21 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2017-12-28 22:09:21 Slp: Sco: Attempting to open registry subkey System\CurrentControlSet\Services\LanmanServer\Parameters\FsctlAllowList
(01) 2017-12-28 22:09:21 Slp: Sco: Attempting to delete registry value FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT
(01) 2017-12-28 22:09:21 Slp: Sco: Attempting to check if registry contains value FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT
(01) 2017-12-28 22:09:21 Slp: DeleteValue: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters\FsctlAllowList, Name = FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT
(01) 2017-12-28 22:09:21 SQLEngine: : Checking Engine checkpoint 'PatchFilestreamAfterRemoveOldRsFx'

0 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base