SQL 2016 - FILESTREAM feature is disabled. (bogus message) The 2019 Stack Overflow Developer Survey Results Are InEnabling filestream on SQL Server 2008file system not supported error while adding a file to sql filegroup with filestreamHow to reattach sql 2008 database without filestream?SQL Server 2008 SP2 installed, filestream failingChange SQL Server FileStream PathSQL Server filestream access from another computer using system accountSQL Server: How to shrink FileStream files?Can we use FILESTREAM in case of SQL Server clusterCannot generate SSPI context SQL Server 2016SQL Server 2016: Invisible Alias
Why isn't airport relocation done gradually?
How to create dashed lines/arrows in Illustrator
What is the use of option -o in the useradd command?
Is flight data recorder erased after every flight?
I looked up a future colleague on linkedin before I started a job. I told my colleague about it and he seemed surprised. Should I apologize?
What do hard-Brexiteers want with respect to the Irish border?
Which Sci-Fi work first showed weapon of galactic-scale mass destruction?
What is a mixture ratio of propellant?
Spanish for "widget"
Limit the amount of RAM Mathematica may access?
Manuscript was "unsubmitted" because the manuscript was deposited in Arxiv Preprints
Why is the maximum length of openwrt’s root password 8 characters?
How to deal with fear of taking dependencies
aging parents with no investments
Could JWST stay at L2 "forever"?
How can I fix this gap between bookcases I made?
"Riffle" two strings
Idiomatic way to prevent slicing?
What function has this graph?
Lethal sonic weapons
What tool would a Roman-age civilization have to grind silver and other metals into dust?
Dual Citizen. Exited the US on Italian passport recently
Any good smartcontract for "business calendar" oracles?
Why don't Unix/Linux systems traverse through directories until they find the required version of a linked library?
SQL 2016 - FILESTREAM feature is disabled. (bogus message)
The 2019 Stack Overflow Developer Survey Results Are InEnabling filestream on SQL Server 2008file system not supported error while adding a file to sql filegroup with filestreamHow to reattach sql 2008 database without filestream?SQL Server 2008 SP2 installed, filestream failingChange SQL Server FileStream PathSQL Server filestream access from another computer using system accountSQL Server: How to shrink FileStream files?Can we use FILESTREAM in case of SQL Server clusterCannot generate SSPI context SQL Server 2016SQL Server 2016: Invisible Alias
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting this error when trying to restore a filestream enabled database...
FILESTREAM feature is disabled.
I may need some suggestions beyond the obvious.
If I try to add a filestream filegroup to a test database, like so...
ALTER DATABASE test_fs
ADD FILEGROUP [FS] CONTAINS FILESTREAM
GO
I get...
Msg 5591, Level 16, State 3, Line 1
FILESTREAM feature is disabled.
If someone could give me some suggestions about what to check, it would be greatly appreciated.
filestream sql-server-2016
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
add a comment |
I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting this error when trying to restore a filestream enabled database...
FILESTREAM feature is disabled.
I may need some suggestions beyond the obvious.
If I try to add a filestream filegroup to a test database, like so...
ALTER DATABASE test_fs
ADD FILEGROUP [FS] CONTAINS FILESTREAM
GO
I get...
Msg 5591, Level 16, State 3, Line 1
FILESTREAM feature is disabled.
If someone could give me some suggestions about what to check, it would be greatly appreciated.
filestream sql-server-2016
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
add a comment |
I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting this error when trying to restore a filestream enabled database...
FILESTREAM feature is disabled.
I may need some suggestions beyond the obvious.
If I try to add a filestream filegroup to a test database, like so...
ALTER DATABASE test_fs
ADD FILEGROUP [FS] CONTAINS FILESTREAM
GO
I get...
Msg 5591, Level 16, State 3, Line 1
FILESTREAM feature is disabled.
If someone could give me some suggestions about what to check, it would be greatly appreciated.
filestream sql-server-2016
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting this error when trying to restore a filestream enabled database...
FILESTREAM feature is disabled.
I may need some suggestions beyond the obvious.
If I try to add a filestream filegroup to a test database, like so...
ALTER DATABASE test_fs
ADD FILEGROUP [FS] CONTAINS FILESTREAM
GO
I get...
Msg 5591, Level 16, State 3, Line 1
FILESTREAM feature is disabled.
If someone could give me some suggestions about what to check, it would be greatly appreciated.
filestream sql-server-2016
filestream sql-server-2016
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
asked Apr 1 '17 at 1:40
user1751825user1751825
200110
200110
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
I second the confirmation above. I'm on Windows 10 build 15063.138 and I have SQL 2016 with SP1 and I get the same error.
Thank you for at least validating what I'm seeing. There doesn't seem to be a work-around posted at this time.
More detail on the bug is posted here:
https://blogs.msdn.microsoft.com/sql_server_team/filestream-issues-with-sql-server-on-windows-10-creators-update/
answered Apr 27 '17 at 2:20
JoelJoel
261
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
add a comment |
Are you on Win10 build 15063.x? If so, there is a bug which effects filestream. Installing SQL 2016 sp1 might help.
answered Apr 2 '17 at 9:53
gokhangokhan
111
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
add a comment |
Fist you have to enable FILESTREAM in GUI as is shown.
Then create New Query
In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx
Now it works for me.
answered Jul 18 '17 at 17:53
bobbob
11
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f841913%2fsql-2016-filestream-feature-is-disabled-bogus-message%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
I second the confirmation above. I'm on Windows 10 build 15063.138 and I have SQL 2016 with SP1 and I get the same error.
Thank you for at least validating what I'm seeing. There doesn't seem to be a work-around posted at this time.
More detail on the bug is posted here:
https://blogs.msdn.microsoft.com/sql_server_team/filestream-issues-with-sql-server-on-windows-10-creators-update/
answered Apr 27 '17 at 2:20
JoelJoel
261
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
add a comment |
I second the confirmation above. I'm on Windows 10 build 15063.138 and I have SQL 2016 with SP1 and I get the same error.
Thank you for at least validating what I'm seeing. There doesn't seem to be a work-around posted at this time.
More detail on the bug is posted here:
https://blogs.msdn.microsoft.com/sql_server_team/filestream-issues-with-sql-server-on-windows-10-creators-update/
answered Apr 27 '17 at 2:20
JoelJoel
261
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
add a comment |
I second the confirmation above. I'm on Windows 10 build 15063.138 and I have SQL 2016 with SP1 and I get the same error.
Thank you for at least validating what I'm seeing. There doesn't seem to be a work-around posted at this time.
More detail on the bug is posted here:
https://blogs.msdn.microsoft.com/sql_server_team/filestream-issues-with-sql-server-on-windows-10-creators-update/
answered Apr 27 '17 at 2:20
JoelJoel
261
I second the confirmation above. I'm on Windows 10 build 15063.138 and I have SQL 2016 with SP1 and I get the same error.
Thank you for at least validating what I'm seeing. There doesn't seem to be a work-around posted at this time.
More detail on the bug is posted here:
https://blogs.msdn.microsoft.com/sql_server_team/filestream-issues-with-sql-server-on-windows-10-creators-update/
answered Apr 27 '17 at 2:20
JoelJoel
261
edited Apr 27 '17 at 2:59
answered Apr 27 '17 at 2:20
JoelJoel
261
answered Apr 27 '17 at 2:20
JoelJoel
261
answered Apr 27 '17 at 2:20
JoelJoel
261
261
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
add a comment |
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– peterh
Apr 27 '17 at 2:44
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@peterh Why do you say this doesn't answer the question. It provides validation of the issue, and an official link detailing the bug. This is the most helpful response I've had yet, and I think qualifies as an answer.
– user1751825
Apr 27 '17 at 9:55
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
@user1751825 I think it could be an answer, although it may be better if you would mention that there is already a workaround on the referred page.
– peterh
Apr 27 '17 at 10:16
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
This site is waaay to caught up in semantics to be useful. 3/4 of the entries I've found in the comments are about the answer someone provided instead of a solution to the original question. Its all dribble and its a waste of my time to be a part of it.
– Joel
Apr 28 '17 at 15:07
add a comment |
Are you on Win10 build 15063.x? If so, there is a bug which effects filestream. Installing SQL 2016 sp1 might help.
answered Apr 2 '17 at 9:53
gokhangokhan
111
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
add a comment |
Are you on Win10 build 15063.x? If so, there is a bug which effects filestream. Installing SQL 2016 sp1 might help.
answered Apr 2 '17 at 9:53
gokhangokhan
111
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
add a comment |
Are you on Win10 build 15063.x? If so, there is a bug which effects filestream. Installing SQL 2016 sp1 might help.
answered Apr 2 '17 at 9:53
gokhangokhan
111
Are you on Win10 build 15063.x? If so, there is a bug which effects filestream. Installing SQL 2016 sp1 might help.
answered Apr 2 '17 at 9:53
gokhangokhan
111
answered Apr 2 '17 at 9:53
gokhangokhan
111
answered Apr 2 '17 at 9:53
gokhangokhan
111
answered Apr 2 '17 at 9:53
gokhangokhan
111
111
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
add a comment |
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
This makes sense. I was using an insider build, but I'm not sure exactly what version. I ended up re-installing Windows 10 Enterprise on the laptop (it was about due for a re-install), and setting everything up again from scratch. SQL 2016 with Filestream is working fine now.
– user1751825
Apr 2 '17 at 23:00
add a comment |
Fist you have to enable FILESTREAM in GUI as is shown.
Then create New Query
In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx
Now it works for me.
answered Jul 18 '17 at 17:53
bobbob
11
add a comment |
Fist you have to enable FILESTREAM in GUI as is shown.
Then create New Query
In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx
Now it works for me.
answered Jul 18 '17 at 17:53
bobbob
11
add a comment |
Fist you have to enable FILESTREAM in GUI as is shown.
Then create New Query
In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx
Now it works for me.
answered Jul 18 '17 at 17:53
bobbob
11
Fist you have to enable FILESTREAM in GUI as is shown.
Then create New Query
In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx
Now it works for me.
answered Jul 18 '17 at 17:53
bobbob
11
answered Jul 18 '17 at 17:53
bobbob
11
answered Jul 18 '17 at 17:53
bobbob
11
answered Jul 18 '17 at 17:53
bobbob
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f841913%2fsql-2016-filestream-feature-is-disabled-bogus-message%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
