fix SBS 2008 sharepoint 3.0

its quite painfull.

during install, things not went well as I saw a msg asking for username/password.

then I found out the SBS console can't detect internal website.

then I started messing up WSS3.0 website. initially I can see the admin site, but can't see the companyweb http 404 error.

eventually all disappeared on me. re-run sharepoint configuration wizard getting no where. the error is an upgrade is already in place. eventually I stuffed the admin site like cannot connect to the database.
http://blogs.technet.com/sbs/archive/2009/05/06/companyweb-inaccessible-after-sharepoint-3-0-service-pack-2.aspx

this cmd is userful to get going: psconfig -cmd upgrade -inplace b2b -force

then I got my admin site back, but companyweb still blank.. or gave me a default II7 website.

now I need re-create the companyweb, http://technet.microsoft.com/en-us/library/dd560621(WS.10).aspx

here is the highlight

To clean up the existing settings


Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.



On the User Account Control page, click Continue.



Click Application Management.



In SharePoint Web Application Management, click Delete Web application.



On the Delete Web Application page, in Delete content databases, click Yes.



In Delete IIS Web sites, click Yes.



Click Delete.



Do not close the SharePoint 3.0 Central Administration tool.


In the SharePoint 3.0 Central Administration tool, click Application Management, and then, in SharePoint Web Application Management, click Create or extend Web application.




Click Create a new Web application.



In IIS Web Site, enter the following settings:



Click Create a new IIS web site, and then in Description, type SBS SharePoint.



In Port, type 987.



In Host Header, type sites.



In Path, type C:\Program Files\Windows Small Business Server\Bin\webapp\InternalWebSite.



In Security Configuration, click the following settings:



For Authentication provider, click NTLM.



For Allow Anonymous, click No.



For Use SSL, click Yes.



For Load Balanced URL, verify that the settings are as follows:



In URL, the setting should be https://sites:987. If this is the setting, do not modify it. If it is not, clear the field, and then type https://sites:987.



In Zone, the setting should be Default.


Set the binding information by doing the following:




Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.



On the User Account Control page, click Continue.



In Connections, expand the server tree, and then click Sites.



Click SBS SharePoint, and then, in Actions, click Bindings.



On the Site Bindings dialog, click Add.



In the Edit Site Binding dialog, enter the following settings:



In Type, click http.



In IP address, click All Unassigned.



In Port, type 80.



In Host name, type Companyweb.



Click OK, and then click Close.



there is also a article about sbs wss3 database security ... need manually open it to check read-only fasle.

another hint is that SBS WSS seemed tied to one administrator. if you login as another admin you may get a security permission error.

what a drama...