All geek questions in one place

SQL Server 2008 FileStream on a web server

I am developing a site using ASP.NET MVC and decided to use the new SQL Server 2008 mechanism FILESTREAMto store files “inside” the database, and not as separate objects. Although it originally worked in VS2008 (using a reliable connection to the database), everything was fine and dandy. However, problems arose when I moved the site to IIS7 and switched to SQL authentication in the database.

It seems that streaming FILESTREAMdoes not work with SQL authentication, only with Windows authentication. Given this, what is the best practice?

  • Is there a way to get this to work under SQL authentication?
  • Should I add NETWORK SERVICEas a database user and then use trusted authentication?
  • Should I create another user and run under it both the IIS site and the database connection?
  • Any other suggestions?
+3
source share
1 answer

Have a look in this article . I don’t know much about FileStreaming and security, but there are some interesting options in configuring FileStreaming, such as allowing remote connections and allowing remote clients to access FileStreaming

+1
source

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

More articles:


All Articles