Sharepoint Errors

Showing old server as configuration database server after moving config db

I was in the process of moving content and config databases from one server to another server for Sharepoint 2007.  All went smooth but when i checked under operations -> Servers in the Farm.
The page was showing oldserver as the configuration database server.

I tried everything including running the Sharepoint configuration wizard, shutting down my old sql server but everything was running smooth and i still had that problem, until i looked into the config database and fixed one column.

Open config database on the new server and run the following queries

1. select * from objects where name = ‘Sharepoint_Config’

- You might get two rows. Check if the parent ID of both the entries are same.
- One of the row will also have the parent ID equals to the ID of that row.
- Note down the ID the other row where parent ID is not equal to the it’s own ID (ID1)

2. Get ID of the newsqlserver (ID2)
 - Select ID from objects where name =’newsqlservername’

3.  Select ID from objects where parentid= ID2 (note down the ID = ID3)

4. Update objects set parentid=ID3 where ID=ID1

Try visiting Server in the farm page (FarmServers.aspx). you might still see the old server name.

5. Now restart your box and thry visiting the FarmServers.aspx page and it should now display the new server name.

When we moved the config database from one server to other server, it somewhow retained the reference to the old server.
in step 4 we are now linking the config database to the new server

Before doing all the steps, please make sure you take a back up of your config database incase you have to roll it back.

An indexer is not assigned to the Shared Services Provider

I got into trouble after moving all my SSP to new database server.

Problem:
Error:  When i tried to view profile information in the Shared Service Provider:

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.

Error:  When i tried to the search settings in Shared Service Provider:

An indexer is not assigned to the Shared Services Provider.

Normally this happens when you try to stop the search service. In that case you will also need to restart the service.
Solution:

GoTo Central Administration -> Shared Services Administration

Select the SSP -> Edit properties

Enter SSP password and select Index Server the from the drop down

Click OK and wait for couple of minutes.

This should resolve the issue.

Breadcrumb (PlaceHolderTitleBreadcrumb) problem in OrangeSingleLevel.master Sharepoint 2007

Customizing MOSS 2007 could be difficult sometimes. There are some Out of Box customized Master pages within SharePoint which can be used.

When using OrangeSingleLevel.master, you might encounter some problems

- PlaceHolderTitleBreadcrumb is one of them

Problem:

It only display the breadcrumb if .aspx pages are selected but does not display anything if you select csub sites
Solution:

Use default breadcrumb used by the default.master

 - locate the tag below

 <asp:ContentPlaceHolder id=”PlaceHolderTitleBreadcrumb” runat=”server”>
  <div>
   <asp:SiteMapPath ID=”siteMapPath” Runat=”server” SiteMapProvider=”CurrentNavSiteMapProviderNoEncode” RenderCurrentNodeAsLink=”false” SkipLinkText=”" cssclass=”breadcrumb” CurrentNodeStyle-CssClass=”breadcrumbCurrent” NodeStyle-CssClass=”ms-sitemapdirectional” />
  </div>
 </asp:ContentPlaceHolder>
- Change id=”PlaceHolderTitleBreadcrumb” to id=”xPlaceHolderTitleBreadcrumb” in the above tag

- Paste the tag below to the above tag

<asp:ContentPlaceHolder id=”PlaceHolderTitleBreadcrumb” runat=”server”/>

What we have done above is modified the id=”PlaceHolderTitleBreadcrumb” to id=”xPlaceHolderTitleBreadcrumb” so that OrangeSingleLevel.master does not use
id=”PlaceHolderTitleBreadcrumb” to display breadcrumb and it will display the default breadcrumb what is displayed if using default.master

Now we are using second tag <asp:ContentPlaceHolder id=”PlaceHolderTitleBreadcrumb” runat=”server”/> which displays the breadcrumb defind by id=”PlaceHolderTitleBreadcrumb” in OrangeSingleLevel.master

so at this point we have two breadcrumbs coming up on the page.

Now let’s hide the second one:

Because OrangeSingleLevel.master ContentPlaceHolder id=”PlaceHolderTitleBreadcrumb” contains both breadcrumb and search (which displays on the results pages of the search center), we will hide just the breadcrumb so that it still displays the search box

- Just before </head> tag, insert the text below

<style>
#ctl00_PlaceHolderTitleBreadcrumb_siteMapPath{
display:none
}
</style>