{"id":63,"date":"2008-10-27T22:47:00","date_gmt":"2008-10-27T22:47:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/"},"modified":"2008-10-27T22:47:00","modified_gmt":"2008-10-27T22:47:00","slug":"using-windows-sharepoint-30-wss-and-sql-search-is-failing","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/","title":{"rendered":"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing?"},"content":{"rendered":"
\n
\n

Ok, this was a timely lesson learned.<\/em> <\/p>\n<\/blockquote>\n

\u00a0<\/p>\n

If you are getting the following error trying to search a Windows SharePoint Services 3.0 (WSS), you might be experiencing the same problem we did…<\/p>\n

\u00a0<\/p>\n

\n
\n
\n
   1:<\/span> No results matching your search were found. Check your spelling. Are the words in<\/span> your query spelled correctly? Try using<\/span> synonyms. Maybe what you're looking for<\/span> uses slightly different words. Make your search more general. Try more general terms in<\/span> place of specific ones.<\/pre>\n
   2:<\/span> Try your search in<\/span> a different scope. Different scopes can have different results.<\/pre>\n<\/div>\n<\/div>\n
\u00a0<\/p>\n<\/blockquote>\n
And\/or<\/em><\/p>\n
\n
\n
   1:<\/span> Context:<\/pre>\n
   2:<\/span> Application 'Search index file on the search server'<\/span>, Catalog 'Search'<\/span><\/pre>\n
   3:<\/span>\u00a0 <\/pre>\n
   4:<\/span> Details:<\/pre>\n
   5:<\/span> Access is<\/span> denied. Check that the Default Content Access Account has access to this<\/span> content, or add a crawl rule to crawl this<\/span> content.   (0x80041205)<\/pre>\n<\/div>\n<\/div>\n
<\/em><\/p>\n
The gist – if you want to crawl\/search WSS content, you will need an NTLM authenticated website (ie. not basic). But you can have both – NTLM for search, basic for UPN (protected by SSL of course)…<\/em><\/p>\n
<\/em><\/p>\n
Reference: http:\/\/technet2.microsoft.com\/Office\/en-us\/library\/b6bc8fec-c11c-4ed7-a78d-3ad61c7ef6c01033.mspx?mfr=true<\/strong><\/a><\/p>\n
\u00a0<\/p>\n
To ensure that the index component can crawl content within the Web application:<\/p>\n
– Configure at least one zone to use NTLM authentication. Ensure that the search content access account has the Read permission level to content accessed through this zone. You can do so by creating a policy that gives this account the Read permission level. <\/p>\n
– Do not configure the default zone to use Anonymous, Basic, Digest, Certificates, or Kerberos authentication (that is, any forms of authentication other than NTLM). <\/p>\n
And clarified again in the reference:<\/p>\n
– If you want content within the Web application to be included in search results, ensure that at least one zone is configured to use NTLM authentication. NTLM authentication is required by the index component to crawl content. Do not create a dedicated zone for the index component unless necessary. <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Ok, this was a timely lesson learned. \u00a0 If you are getting the following error trying to search a Windows SharePoint Services 3.0 (WSS), you might be experiencing the same problem we did… \u00a0 1: No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using … <\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[337,14,428,339],"tags":[],"acf":[],"yoast_head":"\nUsing Windows SharePoint 3.0 (WSS) and SQL Search is Failing? - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing? - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Ok, this was a timely lesson learned. \u00a0 If you are getting the following error trying to search a Windows SharePoint Services 3.0 (WSS), you might be experiencing the same problem we did… \u00a0 1: No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using …\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-27T22:47:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/\",\"name\":\"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing? - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2008-10-27T22:47:00+00:00\",\"dateModified\":\"2008-10-27T22:47:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing? - Brainlitter - Inside the mind of Sean Wallbridge","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":"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/","og_locale":"en_US","og_type":"article","og_title":"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing? - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Ok, this was a timely lesson learned. \u00a0 If you are getting the following error trying to search a Windows SharePoint Services 3.0 (WSS), you might be experiencing the same problem we did… \u00a0 1: No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using …","og_url":"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2008-10-27T22:47:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/","url":"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/","name":"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing? - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2008-10-27T22:47:00+00:00","dateModified":"2008-10-27T22:47:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2008\/10\/27\/using-windows-sharepoint-30-wss-and-sql-search-is-failing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Using Windows SharePoint 3.0 (WSS) and SQL Search is Failing?"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/63"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}