RE: Sharepoint, monitoring and the company web

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi Crina Li,

I'd first like to thank you for your prompt and detailed response. It was
very informative, straight to the point and just what I need as a newbie.
Thanx.

Have scheduled the editing of the registry and reboot for the weekend in
order to resolve the 1000 error.

I am however having a problem removing SBS Monitoring. I cannot run the
add/remove wizard for SBS. The wizard begins then I receive the error about
SQL SP3 being installed and then can go no further.

Any Ideas!

"Crina Li (MSFT)" wrote:

> Regarding the error 1000, this problem could be caused by the SharePoint
> Timer Service failed to contact the SharePoint database while the SBS is
> rebooting. In SBS 2003, the SharePoint Timer Services is used to send
> notifications and performs scheduled tasks of WSS. It needs to access the
> SharePoint database when starting.
>
> To work around this issue, add the DependOnService registry entry to the
> following registry subkey on the server, and then set the DependOnService
> registry entry to MSSQL$SHAREPOINT:
>
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SPTimer
>
> To do this, follow these steps.
>
> Warning: If you use Registry Editor incorrectly, you may cause serious
> problems that may require you to reinstall your operating system. Microsoft
> cannot guarantee that you can solve problems that result from using
> Registry Editor incorrectly. Use Registry Editor at your own risk.
>
> 1. Click "Start", and then click "Run".
> 2. In the "Open" box, type "regedit" (without the quotation marks), and
> then click "OK".
> 3. Locate, and then click the following registry subkey:
>
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SPTimer
>
> 4. On the "Edit" menu, point to "New", and then click "String Value".
> 5. Type "DependOnService" (without the quotation marks), and then press
> ENTER
> 6. On the "Edit" menu, click "Modify".
> 7. In the "Value data" box, type "MSSQL$SHAREPOINT" (without the quotation
> marks), and then click "OK".
> 8. Quit Registry Editor.
>
> For more detailed information, see:
>
> 840685 An event ID 1000 error message is logged to the application event log
> http://support.microsoft.com/?id=840685
>
> Regarding the problem of monitoring, you may try the following:
>
> I. Uninstall Monitoring
>
> 1. Click Start, click Control Panel, and then click Add or Remove
> Programs.
> 2. Select Windows Small Business Server 2003 and then click
> Change/Remove. The Setup Wizard appears.
> 3. Click Next to start the wizard.
> 4. On the Windows Configuration page, click Next.
> 5. On the Component Selection page, in the Action column, change
> Server Tools to Maintenance, change Monitoring component to Remove, and
> then click Next.
> 6. On the Component Summary page, click Next.
> 7. Click Finish.
>
> II. Uninstall Microsoft SQL Server Desktop Engine (SBSMONITORING)
>
> In Add or Remove Programs, select Microsoft SQL Server Desktop Engine
> (SBSMONITORING) and then click Remove. A dialog box appears. To confirm
> that you want to remove, click Yes.
>
> III. Rename the folder
>
> Start Windows Explorer, and then locate and rename the following folder:
>
> C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING
>
> to C:\Program Files\Microsoft SQL Server\Old.MSSQL$SBSMONITORING
>
> IV. Use Registry Editor to delete the following registry key:
>
> HKEY_LOCAL_MACHINE\Software\Microsoft\SmallBusinessServer\Monitoring
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SBSMonitoring
>
> V. Install the Monitoring component
>
> 1. In Add or Remove Programs, select Windows Small Business Server
> 2003 and then click Change/Remove. The Setup Wizard appears.
> 2. Click Next.
> 3. On the Windows Configuration page, click Next.
> 4. On the Component Selection page, in the Action column, change
> Server Tools to Maintenance, change Monitoring component to Install, and
> then click Next.
> 5. On the Logon Information page, click Next.
> 6. On the Component Summary page, click Next.
> 7. Click Finish.
>
> After above steps, please try to reconfigure your monitoring and reporting
> in the Server Management.
>
> In addtion, I provide the following articles for your reference:
>
> 829113 How to restore a Windows SharePoint Services CompanyWeb database
> after the intranet component and SQL Server or MSDE 2000 have been removed
> on Windows Small Business Server
> http://support.microsoft.com/?id=829113
>
> 829114 How to remove and how to install the Windows Small Business Server
> 2003 SharePoint Services Companyweb Web site
> http://support.microsoft.com/?id=829114
>
> Hope the information help and I look forward to your reply.
>
> Best regards,
>
> Crina Li (MSFT)
>
> Microsoft CSS Online Newsgroup Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
>
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --------------------
> | Thread-Topic: Sharepoint, monitoring and the company web
> || From: "=?Utf-8?B?U3VzYW4xMjM0NTY=?="
> <Susan123456@xxxxxxxxxxxxxxxxxxxxxxxxx>
> | Subject: Sharepoint, monitoring and the company web
> | Date: Wed, 10 Aug 2005 14:26:03 -0700
> | | Newsgroups: microsoft.public.windows.server.sbs
> | |
> | Would like to set up monitoring via performance and usage logs on an SBS
> | standard 2003 server.
> |
> | Each time I attempt to run the wizard an error message suggests
> reinstalling
> | the server tools b4 running the wizard again.
> |
> | I have tried installing the server tools however I receive a message
> | suggesting the installation of SQL server sp3. ( MSDE sql is installed).
> |
> | If I run the sql sp3a an error message appears saying sql is not
> installed.
> |
> | Accessing the company web provides the error - cannot connect to the
> | configuration database.
> |
> | The error logs show event ID 1000 with the message - #50070: Unable to
> | connect to the database STS_Config on dellserver\SharePoint. Check the
> | database connection information and make sure that the database server is
> | running.
> |
> | Any Ideas ? New to SBS, Sql and sharepoint
> |
> | Susan
> |
>
>
.



Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: Sharepoint, monitoring and the company web
    ... let me clarify that SharePoint (Companyweb) uses the ... while the Monitoring features use the ... following registry subkey on the server, ... select Microsoft SQL Server Desktop Engine ...
    (microsoft.public.windows.server.sbs)
  • RE: Extended Server Usage Report
    ... Click Monitoring and Reporting. ... SQL database will be reset. ... Step 3: Reinstall SBS Monitoring component ... Select Windows Small Business Server 2003 and then click Change/Remove. ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup settings for server registrations in SQL Server Enterprise
    ... >From what I know the information is stored in registry. ... Anyway if you use Enterprise Manager on multiple clients you may take a look ... "Storing SQL Server 7.0 Server Registrations on a Centralized System" ...
    (microsoft.public.sqlserver.clients)
  • RE: Why no report? Server Management, Monitoring and Reporting
    ... Click Monitoring and Reporting. ... SQL database will be reset. ... Select Windows Small Business Server 2003 and then click Change/Remove. ...
    (microsoft.public.windows.server.sbs)