Compartilhar via

Cannot Access CompanyWeb After Installing 948110

  • Artigo

[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: https://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> .

Comments

  • Anonymous
    January 01, 2003
    Hi All, I set out to answer the question: Is it possible to safely deploy MSSX on a Small Business Server

  • Anonymous
    January 01, 2003
    The comment has been removed

  • Anonymous
    January 01, 2003
    We have received a few reports of hotfix 948110 causing issues with SharePoint (Companyweb) on SBS 2003.

  • Anonymous
    January 01, 2003
    The Official SBS Blog : Cannot Access CompanyWeb After Installing 948110: http://blogs.technet.com/sbs

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

  • Anonymous
    July 15, 2008
    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

  • Anonymous
    July 17, 2008
    I'm encountering this issue also.  I'll advise on the repair.

  • Anonymous
    July 18, 2008
    The comment has been removed

  • Anonymous
    July 22, 2008
    anyone have the solution? because i still don't acces to sharepoint. thanks

  • Anonymous
    July 24, 2008
    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

  • Anonymous
    July 25, 2008
    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 FilesMicrosoft SQL ServerMSSQL$SHAREPOINTBinn to Binn.old
  2. Restore C:Program FilesMicrosoft SQL ServerMSSQL$SHAREPOINTBinn 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

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

  • Anonymous
    July 28, 2008
    I cannot find the error files at C:Program FilesMicrosoft SQL ServerMSSQL$SharepointLogerrorlog ... under Program Files I find "Microsoft Windows Small Business Server", and after that - no logs. And my CompanyWeb is still down. Any suggestions?

  • Anonymous
    July 28, 2008
    The comment has been removed

  • Anonymous
    July 29, 2008
    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.. 😕

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

  • Anonymous
    August 05, 2008
    Lucas, Your solution worked fine for me. Simple and easy to do without being too techie! Thanks a lot

  • Anonymous
    August 07, 2008
    Hi, I did what Lucas advised, copied the Bin folder from another working instance. That seemed to fix the problem. Companyweb is working again now. Thanks :)