Re: kb956572 and sql 2008 filestream
andrea dal farra wrote:
> Hello to all,
> did anyone noticed problem with the kb956572 update and filestream on
> SQL 2008 (without SP1)?
> we have upgraded a windows 2003 SP2 with an instance of SQL 2008 and
> with the update kb956572 we get the following errors on the activation
> of a database with filestream enabled:
> STREAMFCB::Startup: Operating system error 0x80070005(Access is
> denied.) occurred while creating or opening file 'D:\Microsoft SQL
> Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\xxxxFileStre amData'. Diagnose
> and correct the operating system error, and retry the operation
> FCB::Startup () failed: Could not open file D:\Microsoft SQL Server
> \MSSQL10.MSSQLSERVER\MSSQL\DATA\xxxxxxxFileStreamD ata for file number
> 65537. OS error: 0x80070005(Access is denied.).
> A file activation error occurred. The physical file name 'D:\Microsoft
> SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\xxxxFileStre amData' may be
> incorrect. Diagnose and correct additional errors, and retry the
> Some logging with procmon does not reveal anything supicious
> (the directory is opened without errors).
> since the update changes the way the impersonification is made for
> some accounts (as far i understand) I've been thinking on changing the
> account of msssqlserver service (currently is NT AUTHORITY
> \NetworkService - the default from the setup).
> Is a viable workaround?
See that reported. Some have recommended changing to a true domain
account rather than network service.