Re: Cannot update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Which way to solve this problem is recommended?

modify registry?
install SP4?

thx

""Charles Yang [MSFT]"" <v-chayan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:Rgzy69ioFHA.2700@xxxxxxxxxxxxxxxxxxxxxxxx
> Thanks for your post.
>
> The instance of SQL Server that is being installed by Windows
> SharePoint Services (WSS) on SBS 2003 is called Microsoft SQL Server
> 2000 Desktop Engine (Windows) or WMSDE and that is the instance you
> have on your SBS 2003 Server called SHAREPOINT. SQL Server Agent
> feature is not available/ supported on a WMSDE instance. This has
> been documented in the following KB article:
>
> 823467 BUG: You cannot start the SQL Server Agent Service for an
> instance of SQL Server or the SQL Server 2000 Desktop Engine that has
> the same instance name as a previously uninstalled instance of the
> SQL Server 2000 Desktop Engine (Windows)
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;823467
>
>
> "The SQL Server 2000 Desktop Engine (Windows) does not support the
> SQL Server Agent feature."
>
> That is the reason you were unable to start the SQL Agent Service on
> the SHAREPOINT instance. You may try the workaround in the KB article
> 823467 to delete the GUID value under the following registry:
>
> [HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MICROSOFT SQL
> SERVER/SHAREPOINT/SQLSERVERAGENT]
>
> But the way is not supported.
>
> SQL Server Desktop Engine (Windows) is a new SKU (edition) of SQL
> Server 2000 which can be installed/ consumed ONLY by Windows Server
> 2003 operating system components. Remote connections/administration
> of this instance is also not supported. This is by design. As I''ve
> mentioned already, the WMSDE instance is used by a Windows component
> and it is a different SKU from MSDE. We''ve filed a Design Change
> Request (DCR) requesting for informative message to be returned when
> you attempt to start the Agent Service on a WMSDE instance. If you
> would like to use the SQL Agent Service, you could upgrade to a full
> version of SQL Server 2000. The supported scenario has been
> documented in our WSS admin guide (about migrating from WMSDE to SQL
> Server) which is located at:
>
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-
> a6a4-3e33fa13d230&DisplayLang=en
>
>
> We recommend you install SQL SP4, it include a lot of new hotfix for SQL
> services.
>
> If anything is unclear, please feel free to let me know.
>
>
>
> Best regards,
>
> Charles Yang (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.
>
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --------------------
> | From: "Katie" <katie_wo@yahoo>
> | References: <#Ilfz7YoFHA.1468@xxxxxxxxxxxxxxxxxxxx>
> <2mXGVsgoFHA.3672@xxxxxxxxxxxxxxxxxxxxx>
> | Subject: Re: Cannot update
> | Date: Tue, 16 Aug 2005 14:15:55 +0800
> | Lines: 770
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.3790.326
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326
> | Message-ID: <#tge#nioFHA.1088@xxxxxxxxxxxxxxxxxxxx>
> | Newsgroups: microsoft.public.windows.server.sbs
> | NNTP-Posting-Host: 210.3.19.82
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:144750
> | X-Tomcat-NG: microsoft.public.windows.server.sbs
> |
> | Yes, i m using SBS Standard without SQL server. However, the aforesaid
> | update was included in windows update list in which there is a globe
like
> | icon appears.
> | Therefore, I was forced to install such.
> |
> | For you suggestion, i think the worst case i will need to install SQL
SP4.
> | Now, i provide you more info first.
> |
> |
> | ""Charles Yang [MSFT]"" <v-chayan@xxxxxxxxxxxxxxxxxxxx> wrote in message
> | news:2mXGVsgoFHA.3672@xxxxxxxxxxxxxxxxxxxxxxxx
> | > HI Katie,
> | >
> | > Welcome to SBS newsgroup.
> | >
> | > Issue description:
> | >
> | > ===========
> | >
> | > I understand that you could not install KB8250358 on your SBS 2003,
and
> | > your
> | > SQLAgent$SBSMONITORING did not start.
> | >
> | > Analyzing and suggestions:
> | >
> | > ============
> | >
> | > From your description, it seems your SBS is the standard version and
you
> | > did not installed SQL server on your SBS 2003.
> | >
> | > As I know, you did not need to apply this hotfix individually; we
> | recommend
> | > you install SQL SP4, as the hotfix is also including in SP4. For your
> | > convenience, you could install SQL SP4 at the following locations:
> | >
> | > 888800 A list of the bugs that are fixed in SQL Server 2000 Analysis
> | > Services
> | > http://support.microsoft.com/?id=888800
> | >
> | > For the SQL services issue, please refer to my following sections, it
> did
> | > not relate to updates you want to install:
> | >
> | > 1. Check your event view to paste detailed error event, this will help
> us
> | > isolate the issue more clearly.
> | > 2. Is there any problem in your shareopint and monitoring components
on
> | SBS.
> | >
> | > We appreciate your time to perform tests. We will be here waiting for
> your
> | > updates.
> | >
> | >
> | >
> | > Best regards,
> | >
> | > Charles Yang (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.
> | >
> | >
> | > =====================================================
> | > When responding to posts, please "Reply to Group" via your newsreader
so
> | > that others may learn and benefit from your issue.
> | > =====================================================
> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> | rights.
> | >
> | > --------------------
> | > | From: "Katie" <katie_wo@yahoo>
> | > | Subject: Cannot update
> | > | Date: Mon, 15 Aug 2005 19:46:07 +0800
> | > | Lines: 38
> | > | MIME-Version: 1.0
> | > | Content-Type: multipart/alternative;
> | > | boundary="----=_NextPart_000_0030_01C5A1D1.FACB9550"
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.3790.326
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326
> | > | Message-ID: <#Ilfz7YoFHA.1468@xxxxxxxxxxxxxxxxxxxx>
> | > | Newsgroups:
> | > microsoft.public.windowsupdate,microsoft.public.windows.server.sbs
> | > | NNTP-Posting-Host: 210.3.19.82
> | > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.windows.server.sbs:144403
> | > microsoft.public.windowsupdate:71436
> | > | X-Tomcat-NG: microsoft.public.windows.server.sbs
> | > |
> | > | I cannot run the SQL Desktop Engine "KB820358" update. it will
> disappear
> | > during installation. i tried to d/l a single file and install it but
> still
> | > fail (also disappear).
> | > | Likewise, i cannot start the service SQLAgent$SBSMONITORING. Any
idea?
> | > | Thanks.
> | > |
> | >
> |
> |
> |
>


.



Relevant Pages

  • Critical Alert Update - W32.Slammer
    ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)
  • RE: Cannot Apply Update KB829358
    ... Critical Update for SQL Server 2000 Desktop Engine on Windows ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | mentioned critical update is available for install. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot update
    ... not install the updates you referred to. ... highly recommend way for the later one is to install SQL server, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)