Upgrade from TR to RTM Work Around

Looks like at least one problem has snuck through that needs a work around. If you are getting errors like:

User Profiles and Properties Page: An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.


Search Settings: The search service is currently offline. Visit the Services on Server page in SharePoint Central Administration to verify whether the service is enabled. This might also be because an indexer move is in progress.

Then you need to perform the following work around.

  1. Go to the operations tab in Central Administration
  2. Click on services on server
  3. Find the Office SharePoint Server Search and click the Stop button to its right

  4. You will get a message asking “Are you sure you want to uninstall the Office SharePoint Server Search service from this server?” Click OK.
  5. Now go back and start the Office SharePoint Server Search and click Start
  6. Now perform an iisreset.
  7. It sometimes takes up to 5 minutes for search and profiles to begin working.


Shane SharePoint Help

11 Comments so far

  1.   Bob Fox on November 21st, 2006          Reply

    One other step you missed was to go back into Shared Services Administrator and repoint the Index server. If you dont you will get an error when entering SSP.


  2.   Sam on December 21st, 2006          Reply

    when you upgrade from B2TR to the RTM is it required that you install a language package or not?

  3.   Shane on December 21st, 2006          Reply

    You don’t need a language pack unless you are using another language on top of SharePoint. I would say for most customers the answer to your question is no.

  4.   Sam on December 21st, 2006          Reply

    Thank you for your reply.
    I performed un upgrade from B2TR to RTM step 8 of 9 hang didn’t want to finish when I checked the upgrade.log it sleep every 10 seconds its a farm environment.
    so then the search service is not working and I can’t create new content and everytime I run the configuration wizard it keep saying that cannot upgrade because upgrade is already in progress.
    I was thinking of running the spconfig update -force to stop any current upgrade actions and restart it because I don’t think it is done with step 8 of 9 and that was three days ago
    any Ideas

  5.   Dave Chan on March 17th, 2007          Reply

    I had that error and I performed the steps, still no go.

  6.   Peter on September 18th, 2007          Reply

    I have this problem and reset of service with IIS did not help me. any ideas that to do?

  7.   Lester on November 18th, 2007          Reply

    I had to perform a more indepth correction than the one described above. I was getting this error when I had to restore my farm. In my hours of digging through logs and data, I found a class record (config DB) with an ID of ‘1AAB936C-E65C-4829-9683-5CCF5BAB90B0’ and a name of ‘Microsoft.Office.Server.Search.Administration.SearchSharedDatabase, Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c’. My original configuration database contained a corresponding record with this classID specified and my new Farm configuration DB did not have this object record. I performed the following SQL to import the record into my new Farm configuration DB.

    INSERT INTO .[dbo].[Objects]
    SELECT [Id]
    FROM .dbo.[Objects]
    where classid = ‘1AAB936C-E65C-4829-9683-5CCF5BAB90B0’

    The Object.Name is the new SSP Search DB name and the parentID is the ObjectID of your Server(Perform following SQL to find the ID).

    Select *
    from .dbo.objects
    where classid = ‘3112E92F-B97D-481E-8CEB-03FDE15ED1A7’

    Note: Once this is done, you need to perform the steps described in the beginning of this post. Don’t forget to restart your IIS.

    Les Sims
    Microsoft MCP

  8.   Laura on February 11th, 2008          Reply

    THANKS!!! That did the trick for me, I appreciate your information as I am new working with Sharepoint!

  9.   Pooja on August 25th, 2008          Reply

    I have this problem and reset of service with IIS did not help me. any ideas that to do?

  10.   KrishnaPrasad H. on October 23rd, 2008          Reply

    good trouble shoot. Resolved my nightmare.

  11.   Buy Ambien on February 12th, 2010          Reply

    museum unequivocal stead asclepious alia besselaar euros desire iknu academia recap
    ambisoltersos makalavertonicos

Leave a Reply