On one of my SharePoint installations, I was having a ton of issues with SharePoint Search.  I had created a SharePoint Search Application post-install with a different service account.  The search application starting adding an additional 10 MB to the individual log files.  I would reset the IIS application pool, but would see the search application continuing to run.

When examining the log files,  I saw a “loop” of errors like those below:

04/11/2011 10:04:22.59  mssearch.exe (0x1294)                       0x1A14  SharePoint Server Search        UtilCommon                      cd08    High        SQL call failed (0x80004005: Unspecified error  )                               [atldbext.cxx:1290]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        Common                          0000    High        Application c5facd31-489b-4a83-a12b-de3b2f2ed39f-query-0, resource 2: pIDBInitialize->Initialize error. Failed to create a non fast load session.  [resourcemanagerimpl.cpp:1070]  d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp  
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        Common                          0000    High        CResourceManager::CreateSessionEx2 Error creating non fastload session 'Provider=SQLNCLI10;Extended Properties='Server=SQLSERVER\sharepoint;Database=Search_Service_Application___v2_DB_8664cac1db4b49228fae5aa71a191d47;Trusted_Connection=yes;App=Microsoft SharePoint Foundation;Timeout=15';'.  [resourcemanagerimpl.cpp:1124]  d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp    
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        UtilCommon                      cd08    High        SQL call failed (0x80004005: Unspecified error  )                               [atldbext.cxx:1290]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        UtilCommon                      cd09    High        error 0: Cannot generate SSPI context (source Microsoft SQL Server Native Client 10.0, 0x80004005, code -2146893044: Unspecified error  )  [atldbext.cxx:1386]  d:\office\source\search\libs\utild\atldbext.cxx  
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        UtilCommon                      cd09    High        error 1: SQL Server Network Interfaces: The logon attempt failed   (source Microsoft SQL Server Native Client 10.0, 0x80004005, code -2146893044: Unspecified error  )  [atldbext.cxx:1386]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        UtilCommon                      cd08    High        SQL call failed (0x80004005: Unspecified error  )                               [atldbext.cxx:1290]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        UtilCommon                      cd08    High        SQL call failed (0x80004005: Unspecified error  )                               [atldbext.cxx:1290]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        GatherPI                        e5he    High        CGatherPluginMgr::CompleteRemoveWithInfiniteRetries Failed in GetSession, Error is 0x80004005  [gatherpimgr.cxx:809]  d:\office\source\search\native\gather\server\gatherpimgr.cxx   
04/11/2011 10:04:22.63  mssearch.exe (0x1294)                       0x19F4  SharePoint Server Search        UtilCommon                      cd08    High        SQL call failed (0x80004005: Unspecified error  )                               [atldbext.cxx:1290]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.67  mssearch.exe (0x1294)                       0x210C  SharePoint Server Search        Common                          0000    High        Application c5facd31-489b-4a83-a12b-de3b2f2ed39f-crawl-0, resource 1: pIDBInitialize->Initialize error. Failed to create a non fast load session.  [resourcemanagerimpl.cpp:1070]  d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp  
04/11/2011 10:04:22.67  mssearch.exe (0x1294)                       0x210C  SharePoint Server Search        Common                          0000    High        CResourceManager::CreateSessionEx2 Error creating non fastload session 'Provider=SQLNCLI10;Extended Properties='Server=SQLSERVER\sharepoint;Database=Search_Service_Application___v2_PropertyStoreDB_bc6086261d6c48719a2972016ded8162;Trusted_Connection=yes;App=Microsoft SharePoint Foundation;Timeout=15';'.  [resourcemanagerimpl.cpp:1124]  d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp   
04/11/2011 10:04:22.67  mssearch.exe (0x1294)                       0x210C  SharePoint Server Search        UtilCommon                      cd08    High        SQL call failed (0x80004005: Unspecified error  )                               [atldbext.cxx:1290]  d:\office\source\search\libs\utild\atldbext.cxx     
04/11/2011 10:04:22.67  mssearch.exe (0x1294)                       0x210C  SharePoint Server Search        UtilCommon                      cd09    High        error 0: Cannot generate SSPI context (source Microsoft SQL Server Native Client 10.0, 0x80004005, code -2146893044: Unspecified error  )  [atldbext.cxx:1386]  d:\office\source\search\libs\utild\atldbext.cxx

Microsoft offered a few solutions:

  1. Verify you can connect to SQL (i.e. TCP/IP is enabled in the SQL configuration manager, firewall ports are open, SQL credentials are correct)
  2. Disable TCP Chimney Offloading (see http://support.microsoft.com/kb/951037) on your SharePoint and SQL machines

However, neither of these worked. Every 30 minutes, the Search Sever Application would generate another 10 MB worth of the above errors.  Finally, what I did was:

  1. Delete the Search Server Application
  2. Verify that your Search Server databases were also deleted
  3. Restart the SharePoint machine (not just the app, but the entire machine instance)
  4. Finally, recreate a Search Server Application
Presto! No more errors.