{"id":717,"date":"2008-02-28T17:58:00","date_gmt":"2008-02-28T17:58:00","guid":{"rendered":"\/blogs\/bobb\/post\/Configuring-Filestream-in-CTP6-(its-different).aspx"},"modified":"2013-01-03T23:59:52","modified_gmt":"2013-01-04T07:59:52","slug":"configuring-filestream-in-ctp6-its-different","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/","title":{"rendered":"Configuring Filestream in CTP6 (its different)"},"content":{"rendered":"<p>\nI&#39;ve been working with Filestream storage in SQL Server 2008 since it appeared in CTP5. The way I&#39;ve always set it up is to use sp_filestream_configure. During the CTP6 setup process, I noticed you could now configure Filestream as part of setup. Because I knew how to use sp_filestream_configure I skipped that part of setup. And everything just worked as expected when I used it.&nbsp;A friend of mine, not wanting to miss anything, configured Filestream as part of setup. When he tried to use it, the following &quot;Catch 22-like error messages occurred&quot;:\n<\/p>\n<p>\nEXEC sp_filestream_configure @enable_level = 3;\n<\/p>\n<p>\n&quot;The FILESTREAM feature is already configured to the specified level. No change has been made.&quot;\n<\/p>\n<p>\nCREATE DATABASE &#8230; with a filegroup for FILESTREAM\n<\/p>\n<p>\nMsg 5591, Level 16, State 1, Line 1<br \/>\nFILESTREAM feature is disabled.\n<\/p>\n<p>\nHuh? After checking the short list of usual suspects (e.g. NTFS file system, running SSMS as admin under Vista) we were both puzzled. Especially because it &quot;worked for me&quot; as it always had. There&#39;s nothing more frustrating to hear during problem resolution then &quot;Well, I&#39;m not sure what you did wrong because it works for me&quot;. Grrrr&#8230;\n<\/p>\n<p>\nThere is&nbsp;finally a resolution thanks to the storage engine team (confrmed and expounded on&nbsp;by <a href=\"http:\/\/blogs.msdn.com\/b\/sqlserverstorageengine\/archive\/2008\/03\/03\/filestream-configuration-and-setup-changes-in-sql-server-2008-february-ctp.aspx\" class=\"broken_link\">Joanna&#39;s blog entry on March 3<\/a>), and it turns out that the way filestream is configured changed in CTP6 for some very good reasons. You see, sp_filestream_configure sets up Filestream in the OS (requires OS privs) and SQL Server (requires SQL Server privs). Unless you&#39;re running sp_filestream_configure as an OS Admin who&#39;s also a SQL Server sysadmin, it may not work completely. But sp_filestream_configure is &quot;IN&quot; for one last CTP (CTP6). Gone before RTM.\n<\/p>\n<p>\nSo filestream configuration was broken into two parts:<br \/>\n1. Configuring filestream at an OS level is moved into setup. Or use SQL Server Configuration Manager. Or WMI scripting (with SMO\/WMI) is you like scripting (I do). In the SQL Server Configuration Manager GUI, you configure it by select SQL Server Services (left pane), right-click on your SQL Server service instance and choose &quot;properties&quot; and use the FILESTREAM tab. Note that the equivalent FILESTREAM tab does NOT appear when using Services Control Panel applet. I hope you switched (as you should have) to SQL Server Configuration Manager back in SQL Server 2005 days.\n<\/p>\n<p>\n2. Configuring filestream at a SQL Server instance level requires EXEC sp_configure &#39;filestream access level&#39;, &#39;2&#39;. Note that the access level choices in SQL Server are 0,1,2.\n<\/p>\n<p>\n3. BOTH configurations steps\/setting (OS and SQL Server instance) must be compatible for filestream to work. If, for example, filestream is enabled at the OS level but disabled in SQL Server, you&#39;ll get message 5591. See above.\n<\/p>\n<p>\nSo how did my friend get the &quot;Catch 22 errors&quot;? In CTP6 (but not in future), setup performed step 1, but not step 2. In future setup will do both steps. In CTP6, sp_filestream_configure (to be removed before RTM) will do both steps. But before sp_filestream_configure does anything, it CHECKS to see if either configuration job is already done. Thus the &quot;filestream feature is already configured&quot; message.\n<\/p>\n<p>\nGot it? So get used to configuring filestream in both places using SQL Server Configuration Manager AND sp_configure. That&#39;s the way of the future. The fact that both exist in one CTP can be frustrating but is understandable. Reminds me of a similar shift when configuring HTTP endpoints (which also requires both&nbsp;OS and SQL configuration) during the SQL Server 2005 CTPs.\n<\/p>\n<p>\nHope this post saves someone a few &quot;grrrr&#8230; moments&quot; when using this new useful feature.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#39;ve been working with Filestream storage in SQL Server 2008 since it appeared in CTP5. The way I&#39;ve always set it up is to use sp_filestream_configure. During the CTP6 setup process, I noticed you could now configure Filestream as part of setup. Because I knew how to use sp_filestream_configure I skipped that part of setup. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,29],"tags":[],"class_list":["post-717","post","type-post","status-publish","format-standard","hentry","category-filestream-storage","category-sql-server-2008"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Configuring Filestream in CTP6 (its different) - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configuring Filestream in CTP6 (its different) - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"I&#039;ve been working with Filestream storage in SQL Server 2008 since it appeared in CTP5. The way I&#039;ve always set it up is to use sp_filestream_configure. During the CTP6 setup process, I noticed you could now configure Filestream as part of setup. Because I knew how to use sp_filestream_configure I skipped that part of setup. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2008-02-28T17:58:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-04T07:59:52+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/\",\"name\":\"Configuring Filestream in CTP6 (its different) - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2008-02-28T17:58:00+00:00\",\"dateModified\":\"2013-01-04T07:59:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Filestream Storage\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/filestream-storage\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Configuring Filestream in CTP6 (its different)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configuring Filestream in CTP6 (its different) - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/","og_locale":"en_US","og_type":"article","og_title":"Configuring Filestream in CTP6 (its different) - Bob Beauchemin","og_description":"I&#39;ve been working with Filestream storage in SQL Server 2008 since it appeared in CTP5. The way I&#39;ve always set it up is to use sp_filestream_configure. During the CTP6 setup process, I noticed you could now configure Filestream as part of setup. Because I knew how to use sp_filestream_configure I skipped that part of setup. [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/","og_site_name":"Bob Beauchemin","article_published_time":"2008-02-28T17:58:00+00:00","article_modified_time":"2013-01-04T07:59:52+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/","name":"Configuring Filestream in CTP6 (its different) - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2008-02-28T17:58:00+00:00","dateModified":"2013-01-04T07:59:52+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/configuring-filestream-in-ctp6-its-different\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"Filestream Storage","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/filestream-storage\/"},{"@type":"ListItem","position":3,"name":"Configuring Filestream in CTP6 (its different)"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/717\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}