SQL Server 2008 filestream access is denied


Can someone help with an Access is denied error message received when attempting to insert FILESTREAM data into SQL Server 2008?

I have an ASP.NET application running within an application pool configured with an application-specific user. The web.config uses integrated security...

   <add name="MyApp" 
        connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=SSPI;"
        providerName="System.Data.SqlClient" />

The application's Windows user belongs to a database role, web_app. This role has execute and select permissions. However I receive the following exception...

System.ComponentModel.Win32Exception (0x80004005): Access is denied

Thanks in advance for all help.

asked on Stack Overflow Oct 19, 2012 by Ian Warner • edited Jul 6, 2020 by Martijn Pieters

1 Answer

  1. Check that SQL Server Service Account have right access to filestream folder.
  2. Check that filestream folder is not readonly.
answered on Stack Overflow May 3, 2014 by mehdi lotfi

User contributions licensed under CC BY-SA 3.0