Access Denied in SQL 2008 EXPRESS

Question

Well now at the end of my program I'm facing an access denied

Dim sqlFile As SqlFileStream = New SqlFileStream(filePathName, fileToken, FileAccess.Write)

This is the last command in order to write the STREAM image in the table.

This command returns me an 'Access Denied' error no other comment.

I have give in my account a Login relation which is Windows Login account which is a member of

SQLServerMSSQLUser$developer$SQLEXPRESS

account

Means that we have all the prmissions on the server (as a machine)

Even so i receive the 'Access Denied'

The Service account it is not the problem because we have solve it from the very start of this program

anyone which can help me?

Answer 1

Try this:

1. In the SQL Server Configuration Manager under SQL Server Services right-click on the SQL Server (MSSQLSERVER) and select Properties
2. On the FILESTREAM tab make sure that Enable FILESTREAM for file I/O streaming access and Allow remote clients to have streaming access to FILESTREAM data are selected.