Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FILESTREAM Setup and Testing without Visual Studio Expand / Collapse
Author
Message
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: Friday, September 13, 2013 8:20 AM
Points: 514, Visits: 55
Comments posted to this topic are about the item FILESTREAM Setup and Testing without Visual Studio


Post #781943
Posted Thursday, September 03, 2009 7:33 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: Thursday, April 03, 2014 11:02 AM
Points: 506, Visits: 837
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
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: Friday, September 13, 2013 8:20 AM
Points: 514, Visits: 55
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
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
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: Friday, September 13, 2013 8:20 AM
Points: 514, Visits: 55
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
Posted Thursday, September 03, 2009 11:37 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 1:27 AM
Points: 2,366, Visits: 1,837
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
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
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
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: Friday, September 13, 2013 8:20 AM
Points: 514, Visits: 55
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
Posted Tuesday, September 08, 2009 6:01 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,181, Visits: 1,368
Nice Post. Good one..


Post #784161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse