{"id":379,"date":"2006-01-12T17:50:00","date_gmt":"2006-01-12T17:50:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/"},"modified":"2006-01-12T17:50:00","modified_gmt":"2006-01-12T17:50:00","slug":"using-windows-sharepoint-30-wss-and-sql-and-trying-to-search","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/","title":{"rendered":"Using Windows Sharepoint 3.0 (WSS) and SQL and trying to search?"},"content":{"rendered":"
\n

Ok, this was a timely lesson learned. <\/p><\/blockquote>\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

No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using synonyms. Maybe what you’re looking for uses slightly different words. Make your search more general. Try more general terms in place of specific ones. Try your search in a different scope. Different scopes can have different results.<\/p><\/blockquote>\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

Reference: http:\/\/technet2.microsoft.com\/Office\/en-us\/library\/b6bc8fec-c11c-4ed7-a78d-3ad61c7ef6c01033.mspx?mfr=true<\/a><\/p>\n

To ensure that the index component can crawl content within the Web application:<\/p>\n

\u2022 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

\u2022 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

\u2022 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. 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… No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using synonyms. Maybe what … <\/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,339],"tags":[],"acf":[],"yoast_head":"\nUsing Windows Sharepoint 3.0 (WSS) and SQL and trying to search? - 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\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/\" \/>\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 and trying to search? - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Ok, this was a timely lesson learned. 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… No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using synonyms. Maybe what …\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2006-01-12T17:50: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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/\",\"name\":\"Using Windows Sharepoint 3.0 (WSS) and SQL and trying to search? - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2006-01-12T17:50:00+00:00\",\"dateModified\":\"2006-01-12T17:50:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/#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 and trying to search?\"}]},{\"@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 and trying to search? - 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\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/","og_locale":"en_US","og_type":"article","og_title":"Using Windows Sharepoint 3.0 (WSS) and SQL and trying to search? - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Ok, this was a timely lesson learned. 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… No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using synonyms. Maybe what …","og_url":"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2006-01-12T17:50:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/","url":"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/","name":"Using Windows Sharepoint 3.0 (WSS) and SQL and trying to search? - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2006-01-12T17:50:00+00:00","dateModified":"2006-01-12T17:50:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2006\/01\/12\/using-windows-sharepoint-30-wss-and-sql-and-trying-to-search\/#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 and trying to search?"}]},{"@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\/379"}],"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=379"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/379\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}