Cannot Access CompanyWeb After Installing 948110

Cannot Access CompanyWeb After Installing 948110

  • Comments 18
  • Likes

[Today's post comes to us courtesy of Damian Leibaschoff and Justin Crosby]

SharePoint users who upgraded from SQL Server 2000 Desktop Engine (WMSDE) to any other edition of SQL Server 2000 (for example, SQL Server 2000 Standard Edition) may be incorrectly offered a WMSDE update for 948110. This problem can occur if the SQL Server 2000 edition is not patched correctly with SQL Server 2000 Service Pack 4 after the upgrade from WMSDE. The WMSDE update may cause SharePoint to stop working.  The issue we are discussion does not apply to SBS 2003 R2 users that migrated to SQL 2005 Workgroup Edition.

The symptoms the you will notice is that the service instance (e.g. mssql$Sharepoint) will start and then immediately stop.

In the C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Log\errorlog file you will see the following:

2008-07-09 09:38:33.30 spid2     Skipping startup of clean database id 4
2008-07-09 09:38:33.30 spid2     Skipping startup of clean database id 6
2008-07-09 09:38:33.30 spid2     Starting up database 'STS_Config'.
2008-07-09 09:38:33.38 spid5     Clearing tempdb database.
2008-07-09 09:38:33.41 spid5     Starting up database 'tempdb'.
2008-07-09 09:38:33.44 spid2     Recovery complete.
2008-07-09 09:38:34.35 spid2     Database 'master' has invalid schema.  <==Notice the invalid schema. 

The Windows Update detection logic is being fixed and this update should not be offered incorrectly to non-qualifying products, this change is still pending and should happen at any time now.

If you are not sure if you have SharePoint was upgraded to SQL 2000, you need to check the ERRORLOG files prior to the update being installed and review the versions reported there. The log files are usually found in C:\Program Files\Microsoft SQL Server\MSSQL$SharePoint\Log\, if you cannot find an ERRORLOG.n file that is older than the time of when the update was installed, try to get an older ERRORLOG from backup or shadow copy.

The CURRENT ERRORLOG will say:

2008-07-09 09:38:32.94 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)

While the older ERRORLOGs should say:

2008-06-17 09:53:09.12 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
May  3 2005 23:18:38 
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

If this is your case, then you must properly update the instance back to SQL 2000 standard to regain functionality:

  1. Perform the upgrade again to SQL Server 2000.
    Note You must use the same media that was previously used to perform the upgrade to SQL Server 2000.
    Please refer to the Premium Installation Step that shipped with your version of SBS 2003.  This can be found in the root of the Premium Technologies CD.
  2. Restart the server instance. The server instance should start as the upgraded version.
  3. Apply SQL Server 2000 Service Pack 4.
    Note Make sure that you apply the SQL Server 2000 Service Pack 4 and not the MSDE SP4 or WMSDE SP4 updates.
    For more information about how to obtain SQL Server 2000 Service Pack 4, visit the following Microsoft Web page: http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en
  4. Manually apply sp4_serv_uni.sql from the Install folder. To do this, type the following command at a command prompt:

    osql -n -b -d master -Slpc:%computername%\SHAREPOINT -i "%programfiles%\Microsoft SQL Server\MSSQL$SHAREPOINT\Install\sp4_serv_uni.sql" -o "%programfiles%\Microsoft SQL Server\MSSQL$SHAREPOINT\Install\sp4_serv_uni.out" -E

    Note These steps assume that the WMSDE installation folder is in the default location. If you are using a custom installation, you must adjust the path accordingly in the command.  Also note that this is a single command that has been wrapped for readability.

You do not need to re-apply the security update on this scenario. If you have already rolled back the BINN folder, you will be presented with the option to install the update again. Until the MU detection logic is fixed, make sure you are using Microsoft Update and not Windows Update and select the SQL update (not the Windows update that references WMSDE) (The bottom one on this screenshot)

clip_image002

Note: You may also receive the errors described above if your MSDB database is damaged, this will also cause the upgrade failure. The reason is that the setup needs to apply scripts that use MSDB stored procedures.  This is an uncommon scenario, most servers will not experience this scenario. This is not a problem with the security update per se, rather a latent problem in the instance itself. Any version of SQL can be affected by this behavior. If you are experiencing this scenario please contact support for further options <Link to CSS Support site> .

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
Comments
  • We have received a few reports of hotfix 948110 causing issues with SharePoint (Companyweb) on SBS 2003.

  • The Official SBS Blog : Cannot Access CompanyWeb After Installing 948110: http://blogs.technet.com/sbs

  • I am running SBS std edition. My  ERRORLOG says

    I'm using the desktop Engine. So from what I can tell this problem will not hit me and it's ok to go and apply 948110.

    Thanks.....brian

  • For those of you that remember the SBS 2003 beta, you also remember that smack dab in the middle of it

  • If you have been seeing any of the two issues below with your SBS 2003, then please follow the link to

  • I'm encountering this issue also.  I'll advise on the repair.

  • My issue seems to be a variation of this one.

    The original is the Desktop Engine, however the upgrade is attempted:

    2008-06-15 12:26:56.65 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

    May  3 2005 23:18:38

    Copyright (c) 1988-2003 Microsoft Corporation

    Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service Pack 2)

    now:

    2008-07-18 04:15:44.68 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

    May  3 2005 23:18:38

    Copyright (c) 1988-2003 Microsoft Corporation

    Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Update Tries to install kb948110 with this error:

    Update Name: Security Update for Windows Server 2003 (KB948110)

    Update Type: Security Updates

    Error Date: 7/17/2008 6:41:54 PM

    Error Description: Installation Failure: Windows failed to install the following update with error 0x80070643: Security Update for Windows Server 2003 (KB948110).

    The fix is still on queue.

    I installed SQL Server 2005 Express Edition on the server, but didn't upgrade any of the SBS instances to use SQL Server 2005.

    SHAREPOINT

    WSUS

    SBSMONITORING

    all use SQL Server at revision: 8.0.2039

    When I installed the fix manually, a text box appears with the message:

    This machine does not have a product that matches this installation package.

    The package was installed.  IIS went down.  I uninstalled the package and rebooted the machine.  We're up now.  However, the upgrade is still pending.

  • anyone have the solution?

    because i still don't acces to sharepoint.

    thanks

  • Experiencing the same problem with company web, like Spencer, the before and after are the Desktop Engine. There was never an attempt to upgrade to a newer version of SQL. The update tried to install, but it never does. The update just keeps re-appearing. Any pointers are appreciated.

    Thanks

  • Hi all,

    I had this same issue after installing the update on SBS2003 server. The thought of re-installing SQL did not appeal to me. I fixed it by doing the following:

    1) Rename C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Binn to Binn.old

    2) Restore C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Binn from a backup. We dont back up program files so I used the Binn foder from another SQL instance.

    3) Start the MSSQL$SHAREPOINT services.

    Hope this helps someone else

    Hope this helps someone else

  • how about telling us which SBS2003 CD to insert and which executable to run to do this "upgrade to SQL Server 2000"?

  • I cannot find the error files at C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Log\errorlog ... under Program Files I find "Microsoft Windows Small Business Server", and after that - no logs. And my CompanyWeb is still down. Any suggestions?

  • Damn! I fall into this buggy hotfix! My best solution: migrate sharepoint from sql2000 to sqlserver 2005 express. Problem solved!

  • I am also getting this problem, but not sure on which fix route to take...

    the errlog shows new

    2008-07-29 11:48:34.98 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)

    when I start sql manager it shows sql server 2005.. I am not a sql person, just been chucked in at the deepend.

    So if sql manager is showing 2005 & log is showing 2000, do I try this fix?  will i just make things worse..

    :confused:

  • I followed Alberto's solution to solve this problem - migrating to sqlserver2005 express (which is a free upgrade).