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:
- 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)
- 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:
- Delete the Search Server Application
- Verify that your Search Server databases were also deleted
- Restart the SharePoint machine (not just the app, but the entire machine instance)
- Finally, recreate a Search Server Application
Presto! No more errors.