SharePoint Central Administration High Availability, Load Balancing & General Recommendations

A few questions have come up about having dual SharePoint Central Administation servers in a farm. In short, it is possible to run two CAs in a farm. (It is Microsoft supported).
In a 5 server farm (3 WFE, 1 Index, 1 CA), we may feel the need to load balance the CAs with Microsoft’s Network load balancing NLB.
I found a good article that helped reinforced some concepts..

Configure SharePoint search pdf files with a free ifilter

1. Download Free ifilter from:
You can also download Download Adobe Reader 9.0 which contains the ifilter.  Necessary for x64 bit systems.

2. Run the newly downloaded file and go through the install wizard with your preferences.

3. Enable the pdf extension in SharePoint. Central Administration > SharedServices > Search Settings > File Types >New File Type
4. Enter ‘pdf’ as a file extension and Click OK.

5. Right click and save the pdf icon from

6. Add the Acrobat pdf icon to the SharePoint templates directory. Copy the Acrobat PDF picture called pdficon_small.gif in the 12 Hive\TEMPLATE\IMAGES folder, e.g. %programfiles%\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\IMAGES.

7. Open the 12 Hive\TEMPLATE\XML\DOCICON.XML file.
Find the <DocIcons.ByExtension> part
Add the following: <mapping Key=”pdf” Value=”pdficon_small.gif” OpenControl=”” />

8. Run
net stop osearch
net start osearch

9. Perform a full crawl to reindex your pdf files.

The directory C:\Inetpub\wwwroot\wss\VirtualDirectories\80 is already being used by another IIS Web Site. Choose a different root directory for your new Web application.

When creating a new web application, you may experience this error:

The directory C:\Inetpub\wwwroot\wss\VirtualDirectories\80 is already being used by another IIS Web Site.  Choose a different root directory for your new Web application.

1. Ensure you have a proper dns name / entry in the hosts file of your server for the new url you are wanting to create.
2. Ensure you have typed in the ‘host header’ typed in when creating the new web application.
3. If this doesnt work, open IIS Manager – Start>run> inetmgr> and verify the home directory – it could be located on a different drive.

Content type ‘0x01010007FF3E057FA8AB4AA42FCB67B453FFC100E214EEE741181F4E9F7ACC43278EE811’ not found in web

You may sometimes see this error when creating a new page in a SharePoint MOSS 2007 publishing portal.

“Content type ‘0x01010007FF3E057FA8AB4AA42FCB67B453FFC100E214EEE741181F4E9F7ACC43278EE811’ not found in web ‘http://yoururl’

Two step solution:

1. Go to Central Admin, Application Management, User Permissions for Web Application.
Ensure “Use Client Integration Features” and “Use Remote Interfaces” are enabled.

2. Go to Central Admin, Application Management, Policy for Web Application.
Add your user account with Full Control and Finish!

You may have to do an IISRESET and you should be able to create new pages.

SharePoint MOSS Shared Services SSP delete unprovisioning

When you try to delete a SharePoint Shared Services Provider – SSP, you may notice the SSP stuck with unprovisioning as its state. Eg. SharedServices1 (Unprovisioning)

Possible Cause: The SSP database has been deleted in SQL and SharePoint is unable to delete the SSP.
Some objects may still be dependent on the configuration database, hence you are unable to delete the SSP.

Solution: Manually delete the SSP by the following stsadm command:
stsadm -o deletessp -title “ssp_name”

You may also want to check if your SSP is providing services to other farms.
1. Go to Central admin > Application Management > Manage Shared Services between Farms
2. Disable “This farm will provide shared services to other farms”
3. Enable “This farm does not participate in shared services between farms”

Try to delete the SSP again.

You may also receive this error:

“An object in the SharePoint administrative framework, “SharedResourceProvider Name=SSP Parent=SPFarm Name=MOSS”, could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation.

Solution: Identify the GUID of the SSP in SQL and then delete the configuration object by the GUID.

Perform the following steps to get the GUID of the unprovisioning SSP and then delete it:
1. Log into the SQL Management studio and go to the configuration database.

2. Expand the tables and open dbo.object

3. Update the following queryto your database name and run it to receive the GUID

SELECT * FROM [Name of your configuration database].[dbo].[Objects]where name like ‘Name of the Shared Services’

4. Run the following stsadm command

stsadm -o deleteconfigurationobject -id “GUID retrieved from object table in SQL database”

(Provisioning failed: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)))

When creating a SharePoint Shared Services provider (SSP), you receive the following error:
(Provisioning failed: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)))

Check the Windows SharePoint Services Timer if its running and try restarting it. You may have to update the services logon credentials.

This link can help you further:

SharePoint Timer Job Administration

I came across a solution to modify timer jobs from the Central Admin interface. This is the equivalent of using the stsadm -o setproperty command. The best part is you can modify your timer jobs without having to redeploy them!
When you install it, you will get a link in your Central Administration site to ‘Manage Timer Jobs’.

Wait! Theres more, you can also deploy your own custom timer jobs, update job properties and schedule all from this neat interface.

Read more and download here:

SharePoint stsadm commands reference

Are you stsadm hungry? I have attended many SharePoint presentations, technical talks, web casts and promotions and only a very few have discussed on whats ‘under the bonnet’ in SharePoint. Probably now is the time for us to dig deeper into the behind-the-scenes, more powerful SharePoint that Administrators and Developers need to be very familiar with.

Continue reading

SharePoint database maintenance

In this article.. learn how to maintain your SharePoint 2007 database (best practices).

Once you have won all your SharePoint battles, its no time for relaxing.. its time for your next task!
Have you wondered what are some of the ways you could ‘make’ SharePoint go faster? Are you confident to say that your SharePoint databases are at an optimum? The database administrators I have worked with stay far away from SharePoint databases. This time, I got on to the task myself..
Continue reading

What is SharePoint BDC – Business Data Catalog

Business Data Catalog, a new feature introduced in Microsoft Office SharePoint Server 2007, provides an easy way to integrate business data from back-end server applications, such as SAP or Siebel, within Office SharePoint Server 2007 without writing any code.

Thats the Microsoft definition of the BDC (Business Data Catalog). WOWIE! That means you can interface any Line of Business application currently existing in your organisation with SharePoints, BDC – without coding! (for guys like me!)

It is a shared service (found in the SSP – Shared Services Provider) and it enables Office SharePoint Server 2007 to surface business data from back-end server applications without any coding. Business Data Catalog bridges the gap between the portal site and your business applications and enables you to bring in key data from various business applications to Office SharePoint Server 2007 lists, Web Parts, search, user profiles, and custom applications.

Has this got your mind thinking? Are you thinking of reports? dashboards? data manipulation and display, archiving, external read only interfacing of limited business data – eg. Suppliers/Distributors? I am sure this has got you thinking..

Continue reading