All geek questions in one place

Filestream Folder Permission Issues

I am trying to drag a file from my desktop to the local / MSSQLSERVER folder used for filestream files. Every time I do this, I get the following Windows error: "You need permission to complete this action."

I feel like I tried everything under the sun to solve this problem, from adding users and groups to the list of permissions for shared access (and providing full access) - up to setting permissions in SQL Server (for the database and individual table file) .

My local MSSQLServer service is registered as a network account, and I am trying to drag and drop it using a Windows authenticated account. I tried to modify so that the service would go to the Windows auth account, reboot, but still no luck.

Any thoughts?

thanks

+4
source share
1 answer

You tried to enable "Allow remote clients to have streaming access to FILESTREAM data" in SQL Server Configuration Manager | SQL Server Services | SQL Server (MSSQLSERVER) | FILESTREAM?

I tried to change ownership. File access level: EXEC sp_configure filestream_access_level, 2 RECONFIGURE (0 - disabled, 1 - T-SQL access is enabled and 2 - full access [including access via Windows Explorer] is enabled.)

( http://lennilobel.wordpress.com/2010/12/12/sql-server-2008-filestream-part-2-of-3-enabling-and-using-filestream-2/ )

PS: Sorry for my English.

+3
source

Source: https://habr.com/ru/post/1491427/

More articles:


All Articles