CODEWITHSUNDEEP
sql-server
user2057185
user2057185

Reputation: 39

Enabling Filestream - Adding Filegroup filestream doesn't work

I am trying to enable Filestream in my database (i am working on (localdb)\v11.0).

I went to the SQL server configuration manager and enabled the filestream, so far so good then i went to my object explorer and opened the properties of my server and in the Advanced Tab i changed FileStream Access level to full access enabled.

I made a query to add a filegroup for my filestream but i always got the following error : Msg 5598, Level 16, State 3, Line 1 FILESTREAM feature is not supported on user instances.

this is the query i tried to execute:

ALTER DATABASE QuizDatabase ADD
FILEGROUP FileStreamQuizDatabase CONTAINS FILESTREAM;
GO

I've no idea what am i doing wrong or if i should enable something else.

thanks in advance

Upvotes: 3

Views: 4415

Answers (3)

user3285954
user3285954

Reputation: 4729

LocalDB doesn't support filestream, use SQL Express or full edition.

Here's a feature matrix:

http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx

Upvotes: 2

smortan
smortan

Reputation: 21

Filestreams seem not to be supported in the (VS integrated) Microsoft SQL Server Data Tools (which you appear to be using)

according to this (same issue) you have to use an ordinary sql server

Upvotes: 2

user2762785
user2762785

Reputation: 11

You have to enable the File stream at the service level.

  1. Go to SQL Server configuration tool folder --> SQL server Configuration manager --> SQL server services --> Your instance.
  2. Double-click and navigate to file stream tab.
  3. Enable and apply.
  4. Restart your instance and you should be good to go.

Upvotes: 0

Related Questions