I got the message "Windows SharePoint Services Web Application Required on Farm, not running Upgrading", and here is the fix that worked.

Recently a SharePoint 2007 server farm I had been working with for some time stopped giving any of my users access. I check IIS and all the premissions were as they should be for all the Web Servers, but any account that could access it the night before stopped working.

Looking at the services in Farm I noticed this error

Windows SharePoint Services Web Application Required on Farm, not running Upgrading

Turns out the solution is a simple bit of command line, but not STSADMIN but psconfig. I wasted some time trying to find the STSADMIN fix.

Well the solution was rather simple,:

• I just open the CMD command line editor in Windows Server.
• I used the CD command line to get to the BIN file C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN on my machine.
• Typed the command psconfig -cmd upgrade -force

This then runs for a few minutes and afterwards problem was solved.

How long does it take to start with SharePoint

I got an interesting question today about how long it will take a firm to start working with SharePoint. The answer is that you can start a Proof of Concept very quickly. A stand alone installation of SharePoint on a Virtual PC 2007 Virtual Image can be made in about a day. Once it is created you can start developing out of the features from the very start of a requirements workshop.

I will always start a project with a SharePoint virtual image. In this way you can show the stakeholders how the site can function and get them to start thinking about using the out of the box features rather than develop time consuming solutions.

As you refine the requirements you can have a SharePoint farm for UAT and Live built at the same time. You will almost always want to deploy SharePoint with 2 Web Front End, an Application Server and a Active-Passive Database cluster. This is a minimal redundent secured solution. Because of the number of servers involved virtual VMWare ESX should be used for most servers.

You can develop using Virtual PC as the farm is created and tested. It should never take more than 3 weeks to create, test and fully harden a SharePoint farm back end. If someone takes 3 months to just install it out of the box there is something wrong.

Then when the UAT environment is built you can use stsadm.exe to make a backup and restore to move the work you have done to the UAT or Live environments.