Sharepoint Foundation 2010 Search returns no results

Posted on April 20, 2011

SharePoint foundation 2010 includes basic searching features. Despite all rumors and recommendations to upgrade to higher level searching packages, the basic SharePoint search works quite well ... and it's very useful.

If your SharePoint server is not returning search results, the following may help you resolve the issue. It's important to create the right accounts, enable the right services, assign the accounts to these services and finally attach the search server to your web applications.

Let's begin ...

1) You need to create (2) domain accounts for Searching and Crawling. Using the Farm Account (or default accounts) is not recommended. In our example we will use "spSearch" and "spCrawl". Use complex passwords!! These domains accounts should only be standard users, no administrative privileges should be applied.

2) Log into the SharePoint Central Administration Page

3) CA > Security > General Security > Configure Managed Accounts > Register Managed Account.

  • Enter in "domain\spSearch" and the password you chose
  • Click "OK".
  • You should now see this account in the Managed Account list

3) CA > System Settings > Servers > Manage Services on Server > SharePoint Foundation Search -> Start.

  • Service Account -> "Domain\spSearch"
  • Content Access Account (Crawl) -> "Domain\spCrawl" and the password you chose
  • Leave everything else as defaults (you can change the Database Name if you are having issues)

4) CA > Security > General Security > Configure service accounts

  • Choose "Windows Service -> SharePoint Foundation Service"
  • Choose "Domain\spSearch" for the account selection
  • Click "OK"

5) CA > Application Management > Manage Content Databases

  • This is important! For each site you want automatically crawled, you must assign the search server.
  • In the top right corner under "Web Application", choose the web applications to be crawled, one at a time followed by a click on the "database name" column once they are loaded.
  • In the profile page, change the "Search Server" and "Preferred Server for Timer Jobs" to your server.
  • Click "OK"
  • Repeat for any other Website Applications you wish crawled

6> CA > Monitoring > Timer Jobs > Review Timer Jobs > SharePoint Foundation Search Refresh

  • Choose "Run Now" to begin indexing your web applications (sites)
  • This can take several hours depending on the size of your database(s). Please be patient.

7> If you're feeling eager and have a background in SQL, you can use the SQL Management Studio to check the progress. If you are not familiar with SQL, don't be a hero ... this can cause major damage.

  • Load the SQL Management Studio
  • Expand the search database created in the earlier steps (typically WSS_Search_%hostname%)
  • Right click the database -> new query
  • Enter in the following Query:select * from msscrawlhostlist
    (execute)

    You will be presented with a table of results including a column for Hostname and SuccessCount.
    SuccessCount increases as it indexes each page.

  • You can also lookup the crawl summary with:select * from MSSCrawlURLLog
  • And should there be any error codes in the MSSCrawlURLog, they can be referenced with:select * from MSSCrawlErrorList where ErrorID = '<ERRORID>'

If you run into issues where things are still not being crawled, i would suggest deleting the spCrawl and spSearch from SharePoint and Active Directory, re-creating them from scratch, repeating this entire process, and changing the "database" value in step 3). This will re-create the crawling database from scratch.

Good luck!

PDF icon missing in Sharepoint 2010

Posted on April 13, 2011

The default installation of SharePoint 2010 does not include an icon for PDF documents.
Here's how to fix that:

  • Log onto the sharepoint server
  • Browse to "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES"
  • Save the following image into this folder: (right click to save to your PC)
  • Browse to "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML"
  • Edit "DOCICON.XML"
  • Add the following line '<Mapping Key=”pdf” Value=”icpdf.png”/>' into the existing items
  • Save the modified XML file
  • Start -> Run -> iisreset /noforce

That's it!

PDF icon will now show up whenever a PDF document is listed.

Win XP RDP client fails to print Calibri font correct when connected to Win 2008 Server

Posted on April 11, 2011

Windows XP users using RDP to a Windows 2008 server may experience issues printing documents that contain Calibri. Locations that are not formatted with Calibri will print normally. This issue persists when using the Easy Print feature with XPS.

This is a known issue and Microsoft has released a hotfix for it.
Sadly, as you read the attached hotfix info you will notice that you have to call them to get the file.

http://support.microsoft.com/kb/946411

We located it here:

http://thehotfixshare.net/board/index.php?autocom=downloads&showfile=9930

(although we recommend calling microsoft to get it, you can likely find it online somewhere)

After installation, the RDP clients were printing Calibri correctly.