The official blog for Windows Server Essentials and Small Business Server support and product group communications.
We have received a few reports of hotfix 948110 causing issues with SharePoint (Companyweb) on SBS 2003. At this time please hold off on installing this patch on your SBS 2003 server. Installing this hotfix may prevent the SharePoint WMSDE instance from starting. We are currently investigating the issue and will update this blog post as soon as possible.
If you have already installed this hotfix AND the MSSQL$SHAREPOINT service is not starting you can perform the following steps to fix this service.
This should fix CompanyWeb. If you go to Windows Update you will once again be offered update 948110, do not install this update for the time being.
We have determined that this issue only occurs on Small Business Server 2003 Server in which CompanyWeb was upgraded to SQL 2000 from WMSDE and was neverupdated to SQL SP4. If your CompanyWeb site is still using WMSDE (the default) you can go ahead and apply this update. If your CompanyWeb has been migrated to SQL 2005 this issue also does not apply to you and you can apply this update. If you have been affected by this issue or you have updated to SQL 2000 please review this: http://blogs.technet.com/sbs/archive/2008/07/11/cannot-access-company-web-after-installing-948110.aspx.
I gave up on trying to recover my companyweb and sharepoint and just got the server reinstalled.
But... After all my atempts I can't get the sharepoint databases to work.
I really need help.
Im trying to get my head round this problem
(& failing spectaculary)... Our company web is b0rked, all symptoms point to 948110.
Got the invalid schema on master db error
Got the errorlog bit
2008-07-29 22:47:50.70 server Microsoft SQL Server 2000 - 8.00.2050 (Intel X86)
Mar 7 2008 21:29:56
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service Pack 2)
server is running sql 2005 workgroup edition.
but looking at errorlog,it says that it is running sql 2000
can company web be running on 2000 & other DBs on 2005?is this the same problem,
If I re-install 2005, will the problem be fixed?
So many questions..
I followed a recommendation that was given here
http://blogs.technet.com/sbs/archive/2008/07/11/cannot-access-company-web-after-installing-948110.aspx in one of the commments
Alberto recommend the free upgrade to sql2005express, this got the mycompany website back up..
hope it works for everyone.