experiencing database and sharepoint issues in new/clean install

anonymous_at_discussions.microsoft.com
Date: 03/13/04


Date: Fri, 12 Mar 2004 17:49:33 -0800

Thanks to Eric Vogel for #1 I renamed the GUID key to
_GUID and the service started right up.

The fix is to edit the registry and delete the GUID Key in
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MICROSOFT SQL
SERVER/SHAREPOINT/SQLSERVERAGENT

Then start the SQLAGENT$SHAREPOINT in the Services, and
SharePoint and Backup Exec will work. Do note, in Backup
Exec, you may have to start the services for Backup Exec
at the login screen or in Services.

Author: Eric C. Vogel
Source: dBforums - SQLAgent is not allowed to run
Posted: 1/28/2004
Updated: 1/28/2004

>-----Original Message-----
>Hello all. I've done a couple of searches and don't see
>anything on topic.
>
>Item #1) Event Viewer Shows an Application Log error:
>Source: SQLAgent$SHAREPOINT
>Event ID: 324
>Description: SQLAgent is not allowed to run
>
>Item #2) Event Viewer Shows an Application Log error:
>Source: Windows SharePoint Services 2.0
>Event ID: 1000
>Description: #50070: Unable to connect to the database
>STS_Config on CRACKERBOX\SharePoint. Check the database
>connection information and make sure that the database
>server is running.
>
>This setup is a clean install of Server 2003 SBS w/ SQL
>2000 & SP3a along with ISA Server ... basically what came
>in the 'premium' package.
>
>MS Baseline Security Analyzer V. 1.2 tells me that
>SBSMONITORING is missing a critical security patch
covered
>by KB815495. HFNetChkPro 4.2.0.1 also identified
>SBSMONITORING (I think that this is the non-SQL Server
DB)
>as missing the same patch.
>
>I download that patch and it won't apply to the
>SBSMONITORING database. I use windows authentication and
>when the patch goes to apply, I get the following error:
>"Hotfix is unable to start the service login for
>verification."
>
>I also tried to apply this same patch to SHAREPOINT and
>receive an error at the end, referencing the error log,
>which reveals:
>
>=== Version check on sqlservr.exe 8.0.880 shows different
>major build of sqlservr.exe than hotfix build number
>8.00.818
>
>
>=== NOT RUNNING SCRIPTS
>The build number of SQLSERVR.EXE and HotFix package did
>not match. This happens
>when SQLSERVR.EXE was not replaced because the version
was
>higher than the Hotfix build.
>In these cases Hotfix will not run any scripts and return
>error code ERROR_BAD_ENVIRONMENT
>
>Error message: Error running SQL script. Please view the
>log file for details.
>INSTALL FAILURE: Hotfix failed to apply the patches on
>instance SHAREPOINT, the error code returned was: 10
><EndFunc Name='DoSQLHotFix' Return='10' GetLastError='0'>
>
>Lots of data here, I hope it is helpful ... if there are
>questions, please let 'em rip. I really want to get this
>up and running!
>.
>



Relevant Pages

  • experiencing database and sharepoint issues in new/clean install
    ... Item #1) Event Viewer Shows an Application Log error: ... SBSMONITORING is missing a critical security patch covered ... major build of sqlservr.exe than hotfix build number ...
    (microsoft.public.windows.server.sbs)
  • RE: MS02-042 Patch on win2k pro kills capability to map to defaul t sh ares
    ... Given that the hotfix is claiming to be an XP one I would ... >Server (SP3 + patch), no problems found. ... >>showed that the error begin occurring immediately after installing the ...
    (Focus-Microsoft)
  • Re: Update for ISA 2004 KB916106 killed access to external web sites
    ... I'm a little ticked that the ISA folks blew me off when I reported it the first time. ... doesn't automatically restart, the W3 service, and on SBS it doesn't automatically restart some of the Exchange services. ... You'd be doing us all a service if you'd reinstall the patch and see if your web access is restored once you manualy restart the W3 service. ... Incidentally, before this patch was released, it was a hotfix, and the hotfix had the same problem as the patch--didn't automatically restart the W3 and Exchange services, which I reported at the time. ...
    (microsoft.public.windows.server.sbs)
  • Re: Update for ISA 2004 KB916106 killed access to external web sites
    ... There was a separate hotfix available for the iTunes issue that didn't have ... automatically restart some of the Exchange services. ... The patch does make certain web sites available that aren't available to ...
    (microsoft.public.windows.server.sbs)
  • Re: KB885250 Network Share Problems
    ... am looking for other ideas that may fix this problem. ... >>I removed the patch and everything works as expected. ... > Microsoft has developed a hotfix for one known problem caused by the KB885250 ... Only apply it to systems that are experiencing this ...
    (microsoft.public.windowsxp.network_web)