Re: Upgrading MSDE

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

From: Mark Broadbent (no-spam-please_at_no-spam-please.com)
Date: 02/23/04


Date: Mon, 23 Feb 2004 09:47:10 -0000

See this link to see how to find what version/s you have running...

HOW TO: Identify Your SQL Server Service Pack Version and Edition
<http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B321185>

please see this just incase you have installed another sql instance...

Working with Named and Multiple Instances of SQL Server 2000
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in
_runsetup_2xmb.asp>

"Johnny" <anonymous@discussions.microsoft.com> wrote in message
news:1471b01c3f8f0$bb5dec00$a401280a@phx.gbl...
> Here's the situation.
> Last weekend I installed SBS2K3 Premium Edition, also
> installed SQL 2000 from the Premium Technologies cd +
> SP3a to the default instance.
>
> Last night (after reading the instructions for installing
> SQL) it said to upgrade the MSDE instance that was
> installed during the SBS2K3 server install (I never did
> this last weekend) So I followed the instructions to do
> so, up to the last screen where it was going to start
> copying the files for the upgrade. Everything was running
> smooth (All screens defaulted the way they were supposed
> to)
>
> Before I clicked "Continue" to upgrade the instance ~ I
> decided it was probably best to backup my default
> instance that was installed the weekend prior (just in
> case). So I backed out of all the screens for the
> upgrade, then finally "cancling" out of the upgrade all
> together. Then I backed up my SQL database and went back
> into the upgrade process for the MSDE.
>
> It is now, that it doesn't give me the option to upgrade
> the instance anymore. It did the first time, but not
> anymore.
>
> My only options are to:
>
> 1) Add new options
> 2) Remove options
>
> How can I tell if the MSDE has been upgraded to the level
> it should be at. And what level should that be?
> TIA
> -J.



Relevant Pages

  • Re: SQL Server Std over SBS 2003 std
    ... What Henry is referring to is that SBS2003 Premium comes with SQL2000 ... Sorry if I sound dumb but SQL is a whole new topic for me. ... You could just install SQL Server std on the SBS Box (that is what an ... You could also upgrade to SBS 3002 R2 Premium with SQL Server 2005 ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Upgrade to SQL Server Halts at Setup is Preparing to Copy Files
    ... associated SQL Agents/dependant services and then start the upgrade or 2) ... Once the other instances are stopped see if the setup continues.. ... > We already have SQL Server installed on our server prior to this upgrade, ...
    (microsoft.public.windows.server.sbs)
  • Re: Update MSDE2000 to SQL2000 on same server
    ... Yes you do an upgrade from MSDE to SQL 2000 Enterprise. ... a full database backup of all databases. ... Step 2 Click SQL Server 2000 Components. ...
    (microsoft.public.sqlserver.setup)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
  • RE: connect to remote sql server in business Intelligence Developm
    ... I installed visual studio 2005 and sql ... our sql server 2000 to sql server 2005 and I noticed I need BI development ... MSSQL$SQLEXPRESS and it seems installing sql server standard edition doesn't ...
    (microsoft.public.vsnet.general)