Microsoft KB Archive/899118

= An error message is logged to the Sps_ _Spsadmin.log file in SharePoint Portal Server 2003, no data is displayed on the Site Usage Report page, and e-mail notifications are not sent in Windows SharePoint Services =

Article ID: 899118

Article Last Modified on 6/2/2005

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003
 * Microsoft Windows SharePoint Services

-





SYMPTOMS
You experience one or more of the following symptoms in Microsoft Office Portal Server 2003 or in Microsoft Windows SharePoint Services:  When you view the Sps_ _Spsadmin.log file, you see an error message that is similar to the following:





Note The Sps_ _Spsadmin.log file is located in the following folder:



Additionally, you experience the following behavior when you use the Microsoft SQL Server 2000 backup and restore tools in SQL Server Enterprise Manager to back up and to restore the databases that are used by SharePoint Portal Server 2003 and by Windows SharePoint Services. When you restore a portal site by using the Create a Portal Site for  page of SharePoint Portal Server Central Administration, the operation is not successfully completed. You cannot connect to the configuration database.




 * You configure usage analysis processing for Windows SharePoint Services Web sites. When you connect to the Site Usage Report page of a Web site to view the usage data for that Web site, no data is displayed.
 * You configure the Alerts feature in Windows SharePoint Services to send e-mail notifications to notify users when content in a Web site changes. However, when an item changes, e-mail notifications are not sent to users who created an alert for that item.



CAUSE
This issue occurs if the SharePoint administrators group is incorrectly configured. That is, this issue occurs if the domain group account that is configured as the SharePoint administrators group on the Set SharePoint Administration Group page of Windows SharePoint Services Central Administration does not contain the following user accounts as members:
 * The Microsoft Windows user account that is configured as the configuration database administration account.
 * The Windows user account that is configured as the default content access account.
 * The Windows user account that the SharePoint Timer Service is configured to log on as.



RESOLUTION
To resolve this issue, make sure that the following Windows user accounts are members of the domain group account that is configured as the SharePoint administrators group:
 * The Windows user account that is configured as the configuration database administration account.
 * The Windows user account that is configured as the default content access account.
 * The Windows user account that the SharePoint Timer Service is configured to log on as.

Notes:
 * To determine the domain group account that is configured as the SharePoint administrators group, connect to the Set SharePoint Administration Group page of Windows SharePoint Services Central Administration. To do this, start Windows SharePoint Services Central Administration, and then click Set SharePoint administration group under Security Configuration.
 * To determine the Windows user account that is configured as the configuration database administration account and the Windows user account that is configured as the default content access account, connect to Configure Server Farm Account Settings page of SharePoint Portal Server Central Administration. To do this, start SharePoint Portal Server Central Administration, and then click Configure Server Farm Account Settings under Server Configuration.
 * To determine the Windows user account that the SharePoint Timer Service is configured to log on as, click Start, click Run, type control admintools in the Open box, and then click OK. Double-click Services, double-click SharePoint Timer Service, and then click the Log On tab.



MORE INFORMATION
For more information about the SharePoint administrators group, see the &quot;Managing the SharePoint Administrators Group&quot; topic in the &quot;Server Farm Security&quot; section of the &quot;Security&quot; chapter of the Microsoft Office SharePoint Portal Server 2003 Administrator's Guide.

For more information about the configuration database administration account and the default content access account, see the &quot;Configuring Server Farm Account Settings&quot; topic. This topic is in the &quot;Managing Access Accounts for Search&quot; topic of the &quot;Managing Search Settings for the Server Farm&quot; topic in the Manage Search Settings&quot; section of the &quot;Administration&quot; chapter of the Microsoft Office SharePoint Portal Server 2003 Administrator's Guide. Additionally, see the &quot;Changing Access Accounts and Passwords&quot; topic in the &quot;Portal and Site Security&quot; section of the &quot;Security&quot; chapter of the Microsoft Office SharePoint Portal Server 2003 Administrator's Guide.

For more information about usage analysis, see the &quot;Configuring Usage Analysis&quot; topic in the &quot;Configuring the Server Farm&quot; section of the &quot;Configuration&quot; chapter of the Microsoft Office SharePoint Portal Server 2003 Administrator's Guide.

The Microsoft Office SharePoint Portal Server 2003 Administrator's Guide (Administrator's Help.chm) is located in the Docs folder in the root folder of the SharePoint Portal Server 2003 CD.

Additional query words: sps wss config owstimer.exe

Keywords: kberrmsg kbtshoot kbconfig KB899118

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.