Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Hugh Thomas » FILESTREAM Setup and Testing without Visual...
Add to briefcase

FILESTREAM Setup and Testing without Visual Studio Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Hugh Thomas
Posted Thursday, September 03, 2009 12:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:37 PM
Points: 514, Visits: 47
Comments posted to this topic are about the item FILESTREAM Setup and Testing without Visual Studio


Post #781943
Adam Seniuk
Posted Thursday, September 03, 2009 7:33 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:13 PM
Points: 478, Visits: 732
Great post, I was wondering how to setup FILESTREAM without the need of Visual Studio.

One item I wasn't sure of was how is the file system security handled, since the file isn't encrypted.

Over 11yrs in IT and 9yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012
- Oracle 8/9/10
- MySQL 4/5
Post #782156
Hugh Thomas
Posted Thursday, September 03, 2009 10:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:37 PM
Points: 514, Visits: 47
One item I wasn't sure of was how is the file system security handled, since the file isn't encrypted.


Ravi S. Maniam mentions this in his blog post on Filestream. Looks like the physical files should just be available, from an NTFS security perspecitive, by the account that the SQL service is running under. Because my testing was done in a sandbox where the SQL service account did match my windows login account, it wasn't an issue for me when I opened my test file.

If you try to open the test file and are denied, this would be the reason. Sounds like a pretty decent security scheme as long as admins don't run around adding permissions to the filestream folder.


Post #782358
a.rajmane
Posted Thursday, September 03, 2009 4:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, April 16, 2011 10:43 PM
Points: 19, Visits: 39
Will enabling filestream help if its not a BLOB?
Post #782624
Hugh Thomas
Posted Thursday, September 03, 2009 5:20 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:37 PM
Points: 514, Visits: 47
a.rajmane (9/3/2009)
Will enabling filestream help if its not a BLOB?


I'm not sure exactly what you mean, but I will try to clarify in hopes that it answers your question.

In a traditional varbinary(MAX) field without FILESTREAM, the data is stored as a blob in the database. With FILESTREAM, the binary data is stored in the file system as an actual file, of any type. It could be a MS Word document, image file, PDF, or most any other type regular file. Therefore, whatever methods are available through ASP.NET, T-SQL, etc. to import or retrieve the data, the core data is an actual file where the database is simply storing a pointer to that file.

I hope that helps.


Post #782634
ChiragNS
Posted Thursday, September 03, 2009 11:37 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825
While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same in BOL.

-- Create the test table for FILESTREAM
CREATE TABLE [dbo].[tFileStreamTest](
[id] [int] IDENTITY(1,1) NOT NULL,
[FileStreamTest] [varbinary](max) FILESTREAM NULL,
[FileGUID] UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL
UNIQUE DEFAULT NEWID()
) ON [PRIMARY]
FILESTREAM_ON [FileStreamGroup1];
GO

"Keep Trying"
Post #782730
mchou
Posted Saturday, September 05, 2009 8:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 08, 2009 6:58 AM
Points: 4, Visits: 24
Hi,

I follow your step-by-step process, however, I got "FILESTREAM feature is disabled" error at "Add Filestream Filegroup to db" step. I am little bit confused about this error msg because I did configure/reconfigure at step 1 as you described in the doc. Any tips? Thanks.


Post #783333
herman-991596
Posted Saturday, September 05, 2009 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 01, 2010 5:55 PM
Points: 2, Visits: 21
Very good article. It works.
I have a database for my wine inventory and i added filestream columns to store information for a particular wine (info from websites and other documents (jpg, pdf).

I can store the documents with filestream. Great!
But how can i show that info via sql or via MS Access which is still my frontend for maintaining my database?

(I maintain de filestream info manually via a stored procedure, because i don't see a possibility via MS Access)

THANKS!
Post #783361
Hugh Thomas
Posted Monday, September 07, 2009 6:58 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:37 PM
Points: 514, Visits: 47
Chirag (9/3/2009)
While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same in BOL.

-- Create the test table for FILESTREAM
CREATE TABLE [dbo].[tFileStreamTest](
[id] [int] IDENTITY(1,1) NOT NULL,
[FileStreamTest] [varbinary](max) FILESTREAM NULL,
[FileGUID] UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL
UNIQUE DEFAULT NEWID()
) ON [PRIMARY]
FILESTREAM_ON [FileStreamGroup1];
GO



This is only required for partitioned tables as described here. Search for the text "If the table contains FILESTREAM data and the table is partitioned" to find the section that explains. Sorry for the confusion.


Post #783948
Anipaul
Posted Tuesday, September 08, 2009 6:01 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,814, Visits: 1,343
Nice Post. Good one..


Post #784161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.