Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

FileStream with Sql Server Authentification

Posted on 2009-06-29
4
Medium Priority
?
438 Views
Last Modified: 2013-11-08
Hi there,

Can someone help me understand how I can configure a Sql Server 2008 filestream share so that it can be used on a web site that uses forms authentication and sql server authentication?
0
Comment
Question by:karakav
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 24741702
Well, you don't need a share per se. It is "owned" by sql server. SQL Server 2008 can store blobs in its own private NTFS namespace rather than in the database itself. The database contains pointers to that namespace (and it's contents are named for SQL server so no longer represents the original doco name).

So, it is the SQL Server (and agent) accounts that need access to that folder, and best via a domain accout for those services. The advantage is that SQL server manages it and you can hide all of it from the outside world.

There is a really good whitepaper : http://msdn.microsoft.com/en-us/library/cc949109.aspx

And a discussion : http://blogs.msdn.com/rdoherty/archive/2007/10/12/getting-traction-with-sql-server-2008-filestream.aspx

And an example : http://msdn.microsoft.com/en-us/library/cc716724.aspx  and http://mtaulty.com/CommunityServer/blogs/mike_taultys_blog/archive/2008/09/08/10729.aspx

And everything else you ever wanted to know about filestream (as a developer) : http://msdn.microsoft.com/en-us/library/bb895234.aspx

Sorry about the links, but they really are the best answers...

0
 
LVL 4

Author Comment

by:karakav
ID: 24742757
I actually implemented FileStream in a web application. The only downside is that I use integrated security and there everything is working perfectly. However I have to consider using forms authentication and sql server authentication and that's were I get a access denied error. I want to workaroung that problem but still use forms and sql server authentication.
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 2000 total points
ID: 24745551
Well, that is going to be fun, because "to access the FILESTREAM BLOB by using Win32, Windows Authorization must be enabled." (from the manual)

So, you will need to create a domain user, give them access to those folders / directories add them or associate them with a SQL login and then login using that SQL login. The only account that is granted NTFS permissions to the FILESTREAM container is the account under which the SQL Server service account runs. So, you MUST use the OpenSqlFilestream APIs



0
 
LVL 4

Author Closing Comment

by:karakav
ID: 31598090
In other words, it is impossible to take advantage of FileStream without using Windows authentication. Thanks any way.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question