Re: Problems with SQL MSDE after SBS SP1 upgrade!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Charles,

Thx for the tip, will try that, so if I understand this correctly this
will only happen if I have installed the KB 829358 update prior to
upgrading to SP1 ?
f it
If so... if I do have that update installed, will I get rid of this
issue automatically by uninstalling that patch prior to doing the
upgrade??

thx / fahlis

>HI Fahlis,
>
>Welcome to SBS newsgroup.
>
>Issue description:
>============
>
>I understand that you encountered some problem that in system tray the SQL
>services management shows no services after upgrading to SBS SP1.
>
>Analyzing and suggestion:
>=============
>
>Generally speaking, if you have applied SBS SP1, you may have also applied
>KB 829358, if so it might be an accident problem, you can just follow the
>steps below to clear this issue:
>
>1. Click Start, click All Programs, click to open the Startup folder
>2. Right click on Service Manager, then click Delete
>
>To remove the icon fromSystray:
>1. Right click the icon in Systray
>2. Click Exit
>
>This only occur on the Standard version of SBS 2003 with only MSDE
>installed, if you are using the SQL server 2000 it will not occur, I am
>sorry for any inconvenience in this issue.
>
>More info:
>===========
>829358 Critical update for SQL Server 2000 Desktop Engine (Windows) on
>Windows Server 2003 are available for download on the Windows Update site
>http://support.microsoft.com/?id=829358
>
>I appreciate your understanding on this issue, please feel free to let me
>know, if you have any further concerns about this issue. I am glad to help
>you.
>
>
>
>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: fahlis <fahlis@xxxxxxxxxxxxx>
>| Newsgroups: microsoft.public.windows.server.sbs
>| Subject: Problems with SQL MSDE after SBS SP1 upgrade!
>| Message-ID: <dke9h1t57ohl9n953jffe6gbftoh76ciou@xxxxxxx>
>| X-Newsreader: Forte Agent 2.0/32.646
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=ISO-8859-1
>| Content-Transfer-Encoding: 8bit
>| Lines: 17
>| X-Complaints-To: abuse@xxxxxxxxxxxxxxxx
>| X-Abuse-Info: Please be sure to forward a copy of ALL headers
>| X-Abuse-Info: Otherwise we will be unable to process your complaint
>properly.
>| NNTP-Posting-Date: Tue, 30 Aug 2005 16:03:58 EDT
>| Date: Tue, 30 Aug 2005 22:03:43 +0200
>| Path:
>TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
>ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!atl-c08.usenetse
>rver.com!news.usenetserver.com!pc01.usenetserver.com!fe70.usenetserver.com.P
>OSTED!3d2ea010!not-for-mail
>| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:149286
>| X-Tomcat-NG: microsoft.public.windows.server.sbs
>|
>| Hi,
>|
>| I´ve recently done an upgrade to SP1 on a STD SBS 2003 server
>| (Swedish), I followed the guide over at smallbizserver.net, now after
>| the upgrade I see that the SQL Service Manager in the tray shows "no
>| service", prior to the upgrade I know that both the sharepoint &
>| Monitoring was seen in there...anyone who can tell me what I could
>| have done wrong, and how to fix it?
>| The thing is that both Sharepoint / Monitoring is working as it is
>| anyway.
>|
>| I have also done 2 upgrades on Premium version and those worked like
>| charm.
>|
>| Any input very welcome.
>|
>| thx / fahlis
>|
>|


.



Relevant Pages

  • RE: Problems with SQL MSDE after SBS SP1 upgrade!
    ... Welcome to SBS newsgroup. ... I understand that you encountered some problem that in system tray the SQL ... Microsoft CSS Online Newsgroup Support ... Problems with SQL MSDE after SBS SP1 upgrade! ...
    (microsoft.public.windows.server.sbs)
  • RE: Migration to SQL 2005 for Workgroups
    ... First I just want to list the detailed upgrade steps for your reference, ... sharepoint will use SQL 2005 instance indeed. ... different mechanism from Microsoft NTBackup to backup Server. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Migration to SQL 2005 for Workgroups
    ... I ran that command but it doesn't say Sql 2000, ... First I just want to list the detailed upgrade steps for your reference, ... different mechanism from Microsoft NTBackup to backup Server. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2000
    ... SBS 2003 upgrades are posted in the SBS 2003 newsgroup. ... newsgroup who do *not* have SBS 2003 and thus no interest in how to upgrade ... For how to backup and restore the SQL database, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Need some advice
    ... R2 is SUCH an easy upgrade compared to SBS sp1. ... The client needs to have SQL 2005 installed to support MS Great Plains and they also want to put on the latest version of MS CRM. ... They have a spare IBM x235 server with 2GB of ram which we could use but currently no operating system. ... It has been suggested that we could simply upgrade SQL 2005 but we would need to buy new CALS or something. ...
    (microsoft.public.windows.server.sbs)