title: SharePoint Foundation 2010 - Search running but not working. Errors in Event log
body: <p>I was recently tasked with the responsibility of setting up our SharePoint Foundation 2010 server with the built in SharePoint Search functionality.</p>
  
  <p>We created two accounts for this purpose.  A spSearch to run the service and spCrawl to crawl the content DBs.  I setup the Foundation Search service with the spSearch account as the service account, the spCrawl account with pwd was added to the Content Access Acount.  The database was added (no specific instance required) and the database left at default settings. I updated the index timings and clicked ok.</p>
  
  <p>I then clicked on the start link and clicked again on the start button.  I ensured the crawl account had access to the content database and added the server running search to the content database.</p>
  
  <p>As near as I can tell none of the accounts are setup with any special rights or restrictions.</p>
  
  <p>Since the Search was started we are receiving the following errors in Event Log:</p>
  
  <p>Log Name:      Application</p>
  
  <p>Source:        Microsoft-SharePoint Products-SharePoint Foundation Search</p>
  
  <p>Date:          8/15/2012 3:11:53 PM</p>
  
  <p>Event ID:      57</p>
  
  <p>Task Category: Search service</p>
  
  <p>Level:         Warning</p>
  
  <p>Keywords:      </p>
  
  <p>User:          XXXXXXXXXXX</p>
  
  <p>Computer:      XXXXXXXXXXX</p>
  
  <p>Description:
  A database error occurred. Source: Microsoft OLE DB Provider for SQL Server Code: 14 occurred 257 time(s) Description: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.</p>
  
  <pre><code>Context: Application 'dfa254b7-8bac-4842-83b8-3033ebc424f2'
  Event Xml:
  &lt;Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"&gt;
    &lt;System&gt;
      &lt;Provider Name="Microsoft-SharePoint Products-SharePoint Foundation Search" Guid="{1C415899-58B3-4BFC-9236-105E7FD38719}" /&gt;
      &lt;EventID&gt;57&lt;/EventID&gt;
      &lt;Version&gt;14&lt;/Version&gt;
      &lt;Level&gt;3&lt;/Level&gt;
      &lt;Task&gt;173&lt;/Task&gt;
      &lt;Opcode&gt;0&lt;/Opcode&gt;
      &lt;Keywords&gt;0x2000000000000000&lt;/Keywords&gt;
      &lt;TimeCreated SystemTime="2012-08-15T21:11:53.516367700Z" /&gt;
      &lt;EventRecordID&gt;6100&lt;/EventRecordID&gt;
      &lt;Correlation /&gt;
      &lt;Execution ProcessID="5720" ThreadID="3280" /&gt;
      &lt;Channel&gt;Application&lt;/Channel&gt;
      &lt;Computer&gt;XXXXXXXXXXXXX&lt;/Computer&gt;
      &lt;Security UserID="XXXXXXXXXXXXX" /&gt;
    &lt;/System&gt;
    &lt;EventData&gt;
      &lt;Data Name="string0"&gt;Microsoft OLE DB Provider for SQL Server&lt;/Data&gt;
      &lt;Data Name="string1"&gt;14&lt;/Data&gt;
      &lt;Data Name="string2"&gt;257&lt;/Data&gt;
      &lt;Data Name="string3"&gt;[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.&lt;/Data&gt;
      &lt;Data Name="string4"&gt;
  
  Context: Application 'dfa254b7-8bac-4842-83b8-3033ebc424f2'&lt;/Data&gt;
    &lt;/EventData&gt;
  &lt;/Event&gt;
  </code></pre>
  
  <p>I have tried everything I can think of and spent a day googling this issue with no luck.  Any suggestions?</p>
  
  <p>Thanks.</p>