Event 7888 and 5555 populating the Event Viewer

This has been a pain for about 5 days now. I had blogged this before.

The main issue is that I had sometime ago performed a resolution on these events but I didnt perform the solution on all the Web Front Ends. So after the upgrade of clients SharePoint installation, I was performing a restore operation due to the fact that an SSP i restore was having search issues. So i created another SSP, on finally resolving this problem, I then deleted the new SSP, now the problem started.. I tweaked alot of timer jobs but it didnt help ..see a view of the error

Then I also had this

run stsadm -o sync -DeleteOldDatabases 0


SharePoint Deployment

You might be thinking of the hassles of creating your site in development and getting it deployed in your production environment.. no big deal..use the SPDeployment Wizard.!

Simple enough it can help to export your sites and you can do an import unto the live site.


My Sojourn with Event ID 27745, 5585 & 18456

For over a week, I kept seeing this event ID, all over the Web Front End server, it also had along side it Event 5586. It was a bother as the only known fix which I found here was to do a restart of the SQL server. As I waited for the weekend so I do perform the maintenance, the entire farm went down like the drowning noise of a power generator when it's out of gas.
Now the panic started..Where is the problem? Why did MSSQL go down?

Well I took the following steps;
1. Perform a farm reset. Restarted all the servers in the farm.

When all servers came up, it helped abit as the errors cleared out.
Now I faced the MSSQL server.
During this period, I had been faced with another dreaded issue which started as a result of one of my consultants deleting a Shared Services Provider which he created in a bid to fix another issue. So the DB created was still hanging around in the MSSQL brains..but needed to be cleared out.

Solution was... from this link.
Phew! what a relief. now let me watch the servers for a while..


Site Access from Authenticated Users

I got a mail from a client who was having problems with Site Authentication.
His problem was that after recent setup of a SharePoint installation he was having problems with Site User Authentication. So whenever a signed in user tries to access the Team site/ Collaboration then he/she gets a prompt to login to the sharepoint site.

His intial plan was that users will be authenticated with thier Windows logon.

The simple solution was to add the intranet site to the Local Intranet Settings.

1. Open IE, click Tools, Internet Options, Security, Local Intranet, Sites, Advanced
2. Type in the local intranet address and press Add.
3. Ok

Voila! Your sites would load as planned


Using SharePoint Designer 2007 to Backup & Restore Sites

Sometime ago, I stumbled on this. Its quite useful. Once you need to move sites between servers. You can make use of the SharePoint designer 2007.

I hope you find it useful


SharePoint Administration Tools

Recently, I was searching for SP Admin Tools.. you know some apps that can simulate SP admin on a day-to-day basis, that could give you a quick picture of whats happening to any installation.

I embarked on this because, for a while now, I have encountered different installations of SP. And this has created a load of different trouble scenarios. Then I thought, whats if you had a "magic wand" you could wave at that server.. Then it would tell you whats wrong and where..

I came across Eamon Barker's blog here. Its a good compilation, but my search continues.

Besides the Microsoft SharePoint Administration Toolkit which you can find here . It can only add the Batch Site Manager.

Which is added under the Apps Mgmt can only be used for Site Collection. I will rate this tool 30%.

The Facts..about SHAREPOINT

  1. SharePoint is the fastest-growing product in the history of Microsoft
  2. More than 100 million licenses sold
  3. Has attracted over 17,000 user companies
  4. Over $1 billion in sales for Microsoft
  5. 3/4 of the Fortune 100 companies use SharePoint
  6. SharePoint is positioned as a leader within the Gartner Magic Quadrant for Horizontal Portals products
  7. Six focus areas : Collaboration, Portal, Search, Enterprise ontent management , Business process management and Business intelligence

Free SharePoint Host

I just found this website.. you get a free sharepoint portal.

How to remove Orphaned Sites

Sometime ago, I had a problem with a SharePoint installation. The Event Log was populated with errors that was referring to a particular site collection that did not exist.
The problem was a site collection was deleted by the site administrator without doing this via Central Admin.
This infact affected the upgrade of this SharePoint installation to SP1. It was pain as you could see it under Site Collections List but it reports this site collection cant be deleted.
The simple solution was;

1. Goto Central Admin > Application Management
2. Select Content Databses under SharePoint Web Application Management
3. Click on the Top Level DB > scroll down and remove database
4. Do not delete DB or contents
5. Go back to Content DBs and add DB, Type the name of the one your removed to attach it again.

Voila! all orphan sites have disappeared

Restoring a SharePoint backup .fwp file

Well I got a question from my expert support site and I did a google and I got this

I suggest using SharePoint Designer 2007

Restoring permissions to sharepoint subsite

Question: I accidently deleted myself from my sub-site which i am the only owner of because i decided to use unique permission and not inheritance.
How can i get access back to my sub-site.

  1. Go to the Central Admin
  2. Click Apps Management
  3. Click Site Collection Administrators
  4. Add yourself as a site collection administrator.
  5. Go back to your site and you will be able to modify site settings

Change the Title Icon

I got this from a Support Site email I subscribed to as an Expert in SharePoint..


How do i change the icon (left side of the title 'Internal Project Group' on top left)..

Do I need sharepoint designer to change it?

  1. Move your mouse over the image, right-click on it and view the properties
  2. Note its name down
  3. Goto your Front End Server, wherein the site is hosted. Perform a search for the file name.
  4. Pronto you will find it among your search results.

Else, Use SharePoint Designer to change it!

Using IE6 to view document libraries

Some days ago, I got a mail from a client of mine complaining of unable to view his document libraries using Windows Explorer.

This is what I mean..

When you visit your document library, and click on Actions then select Open with Windows Explorer. Then you get this:

1. Upgrade your Internet Explorer to IE 7
2. Obtain the hotfix 325355 for Internet Explorer 6


Event ID 2424 Gatherer

This is a very common error in the Event Log
Event Type: Error
Event Source: Windows SharePoint Services 3 Search
Event Category: Gatherer
Event ID: 2424
Date: 02/06/2008
Time: 16:55:01
User: N/A
The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again.

Context: Application 'Search', Catalog 'index file on the search server Search'
For more information, see Help and Support Center



Upgrading Staging Environment to SP1

The Staging Environment of WebWox is a replica of the Live environment.
This SharePoint Installation includes a Server Farm of 5 servers + and IIS server as follows;
  1. IIS-Stage-WFE01 – Hosts the HomePage
  2. SP-Stage-APP01 – Runs Excel Services
  3. SP-Stage-Search01 – Runs Office Search Services
  4. SP-Stage-WFE01 – Hosts the Central Administration
  5. SP-Stage-WFECr01 – Acts as a Front End Web Crawler
  6. SP-Stage-SQL01 – Hosts the Staging Database and are subdomains used to hosting the Web Applications and Site Collections. These 2 are SSL enabled and obtains the SSL certificate from the domain controller

The following steps were implemented;

  1. Perform a backup job of the entire farm – to \srv-pencil\serverbackups$\stage.
  2. Ensure that the backup is successful (Incomplete backup cannot be used)
  3. Disconnect from farm SP-Stage-APP01, SP-Stage-WFECr01, SP-Stage-Search01.
  4. Uninstall SharePoint from all servers that have been disconnected from the farm.
  5. Reinstall SharePoint on all the servers that have been disconnected from the farm
  6. Run Configuration Wizard on WFECr01 setup a new farm – WXSPConfig
    Connect Search01, APP01 for the new farm
  7. Assign Services to these servers. – Office Search Server and Windows Search setup on SEARCH01 using (WSS_Search_SPSTSCH) as DB
  8. Point webwox-stage & mysites to WFECr01. Add the to WFECr01.
  9. Run restore job to restore the backup taken from WFE01.
  10. Select New Configuration
    Databases used for restore;
  11. Ensure that restore was successful
  12. Setup SSL on the Websites mysites-stage and magellan2-stage by assigning a new SSL certificate using the DNS names &
  13. Perform tests to ensure staging environment is functional
  14. Perform the upgrade to SP1 by installing all the files on the servers APP01, Search01, WFECr01 following the Microsoft Documentation on upgrading MOSS 2007 to SP1.
  15. Perform Testing after the farm has been upgraded.
  16. Turn on the Firewall on all servers and click Office Web Servers, Secure HTTPS and HTTP access. Add Secure MySite Connection 8083. Allow this traffic
  17. After SP1
    Go to search setting from the SSP, click Crawl Rules and Apply new Crawl Rule to and uncheck
    "Follow links on the URL without crawling the URL itself".

Office Server Search Broken

PreSP1 Search service on MOSS 2007 can be a pain sometimes, this is beacuse you get search service crashing/frozen, you sometimes get this error..
Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10034
Date: 29/05/2008
Time: 11:44:00
User: N/A
Computer: SP-SEARCH01
Could not access the Search service configuration database.

Context: Application '76d822a2-1c3c-4cc8-aa02-5c16fe104138'

The filename or extension is too long. (0x800700ce)
For more information, see Help and Support Center


Simple solution restart the search service on the Office SharePoint Search Server.
Make sure that you confirm that the service account is given permission on the SQL database and also the WSS_Content Search DB.

Moving Sites and Limiting Databases

You can move Content/Sites between databases by first determining the size of the database. You can use smigrate.exe and stsadm.exe

To ensure DBs dont grow beyond a certain size is to limit the number of sites and employ site collection quotas. By using these 2 elements togther you can ensure your content DBs dont grow beyond a pre-determined size.

Event 10016 DCOM Error

This Error has been populating the sp-stage-search for weeks


Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 30/06/2008
Time: 10:50:25
User: test\SPConfigAcct
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
to the user test\SPConfigAcct SID (S-1-5-21-1430212151-832525293-1231754661-36867). This security permission can be modified using the Component Services administrative tool.

For more information, see Help and Support Center at

Here lies the solution

View the above to resolve the problem

Installing Applications for WSS 3.0

Steps taken to install Solution/Features Web Application on SharePoint Farm.
  1. Copy the apps to a folder on the CA WFE server
  2. Open cmd and dir to C:\Program Files\Common Files\Microsoft Shared\Web Server Connections\12\Bin\
  3. Add Solution to SharePoint - use the command stsadm -o addsolution -filename \application.wsp press Enter
  4. After Successful addsolution. goto CA>Operations>Solution Management
  5. Select the application name and click, once it opens click deploy solution.
  6. Once its successful, it can now be used

User Profiles in WSS and MOSS

I have been having issues with Profiles on the Site collections not giving updated information.
The context of the problem is as follows;
A particular web part was added to a site, this webpart was expected to display the names and photos of staff in a particular group that was selected for the web part.
The web part worked but did not display so particular profiles photos. Also when you click on the user profile it takes you to a user profile display page "userdisp.aspx" which does not display updated profile.

The fix is a simple one and would require adding some settings to all the site collections.
1. Login to any Site Collection as Admin
2. Click Site Actions >Site Settings>Modify All Site Settings
3. Click Profile Site Connection under Site Collection Administration
4. Select Connect to a portal Site and add
5. Ok and exit


Server Monitoring and Maintenance Procedures

I have been thinking of writing procedures of Server Monitoring and Maintenance. I decided to put together some write-up for this. It is not an exhaustive document but it will help if you are fairly new to SharePoint Administration.


Server Monitoring and Maintenance Procedures


This document explains daily procedures that should be performed in order to monitor and manage the SharePoint 2007 Server. Moreover, daily and monthly procedures are outlined to help you maintain the SharePoint Installation.


Daily Monitoring Procedures

The following system monitoring procedures should be performed daily.


  1. Check that all relevant services are operational on all the servers in the farm using the Services Snap.
  2. Check that ample space is left in the C: Drive in order to free-up disk space for applications to run properly.
  3. Verify that the previous night's backup has run.
  4. Search for unusual entries in the Event log Snap, this task should be done every 6 hours.
  5. Check for all Timer Jobs definitions and resolve all jobs that failed or did not complete.


In the Event of an Emergency Downtime,

The following has to be restored back as quickly as possible;

  1. SQL Database
  2. Front End Server
  3. Search Server
  4. All Solutions/modifications applied


The functionality of the SharePoint different functions should be checked after every downtime.


Administration Tools

In order to seamlessly administer and manage the SharePoint 2007. Some tools are needed as follows;


  1. Microsoft Office SharePoint Server 2007 MP for MOM 2005
  2. SharePoint Administration Toolkit


These tools would help to detect any errors and problems that may arise which might not be easily detected.


Event Log Resolution Procedure

Once an error log is detected in the Event log, this should activate the quick resolution process be aware that a resolution might take the whole day and sometimes it might be a quick fix or an after close of work fix.


  1. Log this Error/Fault in the Daily Resolution KB on the SharePoint Administration Site.
  2. Diagnose and detect the problem, propose a solution to this error/fault.
  3. Perform a google search for similar problems, document the results, make sure the results obtained from the google search reflect the same problems occurring on the server.
  4. Discuss with Teksys and if necessary raise a call ticket
  5. Copy the URL from the search and add it to your entry on the Daily Faults Resolution KB.
  6. Test resolution on the test environment, then staging environment.
  7. Discuss possibility of a change with Project Manager and/or Infrastructure Team leader in order to resolve this fault.
  8. Determine length of time for resolution to take place, time it would start and any extent of downtime/effect on the entire farm.
  9. Have a Rollback plan
  10. Raise an RFC for the change.
  11. Inform the CAB about the change and time.
  12. Effect the change, perform testing and confirm the functionality of the entire farm.
  13. Update the Issues Log.

Welcome to my Blog

Thanks for visiting my SharePoint Blog.
I have been thinking of how to put together a wealth of experience I keep gaining from an extremely versatile tool - Microsoft Office SharePoint.

This blog will document my day-to-day activities in resolving some of the complex problems I face with several installations.