Re: SP3 for MSDE 2000

From: Bill Sanderson (Bill_Sanderson@msn.com.plugh.org)
Date: 01/27/03 

From: "Bill Sanderson" <Bill_Sanderson@msn.com.plugh.org>
Date: Mon, 27 Jan 2003 12:33:18 -0500

At the risk of misguiding you totally, does this KB article help:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;311762

"Chuck" <ctkenyon@marketrx.com> wrote in message
news:735f1a80.0301270903.13fb275e@posting.google.com...
> I'm having some of the same trouble, had a 3rd party tool that
> installed a named instance of MSDE.
>
> When I ran setup from the gui, it just quit complaining about strong
> security, then it just created a new default instance w/ the SP3
> versioning, but left the original unchanged. Anyone know the proper
> command-line syntax for upgrading the named instance to SP3, as well
> removing the new instance that was just created?
>
> Are the setup.exe command line parameters available on the web? The
> readme file described a section of the SQL Online Books that didn't
> appear to exist.
>
>
> "Ted Howard" <ted(underscore)yantis@yahoo.com> wrote in message
> news:<efeAtodxCHA.1288@TK2MSFTNGP11>...
> > I've got the same sort of thing here.
> >
> > I've been confused about just running the SP3 Setup or running it as an
> > "upgrade" - every SP I've ever seen *is* an upgrade, but running without
> > specifying "upgrade" creates a new database? I'm no SQL Server master,
> > obviously, but it seems unnecessarily confusing.
> >
> > My computer also insists (osql -L and SqlMangr) that there is an MSDE
> > installation on my machine using a previous network name for my machine
> > (had
> > to change my machine name for ATT cable setup). Besides the fact that
> > the
> > old database is listed, nothing can connect to it since it doesn't
> > exist.
> > So, maybe the SP3 is being applied somehow to this non-existent
> > database?
> >
> > --
> > -Ted
> > Want to hire a C# or C++ programmer/former WildTangent employee/BSEE
> > from
> > Rice/Fulbright Scholar?
> > ted(underscore)yantis@yahoo.com
> >
> >
> > "FL" <frleong_NOSPAM@hotmail.com> wrote in message
> > news:3E34A379.BF6F37B1@hotmail.com...
> > > Hi,
> > >
> > > How do I install this over the MSDE version that comes with the .NET
> > > Framework SDK? I ran the Desktop SP3 setup.exe and it installed the
> > > SP3
> > > on a default instance. I want it to apply to the NETSDK instance. I
> > > tried using the parameters /upgradesp SQLRUN INSTANCE=NetSDK. Setup
> > > grilled the HDD for some time and then it quits. Dumping the binn
> > > directory of the instance revealed that nothing was changed. Select
> > > @@version proves the same (8.0.384, SP1). What should I do?
> > >
> > > FYI, the MSI file used to install this version of MSDE has a strange
> > > name called SQL2000.MSI in the Samples folder and not those
> > > SQLRUN*.MSI.
> > >
> > > Thanks!
> > >
> > > Francisco
> > >
> > > "Jerry Bryant [MSFT]" wrote:
> > > >
> > > > We are working to get all language versions posted. The main SP3
> > > > page
> > will
> > > > be updated as soon as all are languages are available. Until then,
> > > > you
> > can
> > > > get the following languages from their direct download locations:
> > > >
> > > > English:
> > > >
> > http://download.microsoft.com/download/e/9/4/e943e32d-1e1c-4700-abd9-4b3df9c
> > 9c495/SQL2KDeskSP3.exe
> > > >
> > > > German:
> > > >
> > http://download.microsoft.com/download/8/3/3/833e18b7-59b9-4750-a4d5-f341d8b
> > 988a8/GER_SQL2KDeskSP3.exe
> > > >
> > > > French:
> > > >
> > http://download.microsoft.com/download/1/a/4/1a43a4dc-26c6-4a36-a347-95f1f38
> > aee39/FRN_SQL2KDeskSP3.exe
> > > >
> > > > Spanish:
> > > >
> > http://download.microsoft.com/download/3/0/b/30b3d5c2-0750-4f95-b4eb-e228c98
> > cab87/ESN_SQL2KDeskSP3.exe
> > > >
> > > > Italian:
> > > >
> > http://download.microsoft.com/download/a/1/6/a1624ad6-48fb-48a3-8e47-b654bea
> > a7c16/ITA_SQL2KDeskSP3.exe
> > > >
> > > > Korean:
> > > >
> > http://download.microsoft.com/download/e/c/8/ec8dc3c2-053a-403b-9fb6-6c13fd3
> > 1cf65/KOR_SQL2KDeskSP3.exe
> > > >

Relevant Pages

  • Re: Recommended Approach for deploying SQL Server Express with shrink wrap software
    ... or you can provide your own setup gui and provide all required ... installation is performed by the masses, ... Server Express is to allow merge replication subscriptions over the ... I keep a database structure ...
    (microsoft.public.sqlserver.msde)
  • Re: MDAC install fails?
    ... Check the MDAC versions present following the instructions in this KB ... You may need to restore the key after SP3 installation completes. ... Try executing the MDAC setup manually, then redoing the SP3 setup. ...
    (microsoft.public.sqlserver.security)
  • Re: Save As Text Question
    ... A2003 on both my desktop and laptop. ... As an experiment I installed SP3 and the SP3 hotfix ... So now I have a situation where it runs fine on one installation of ... from some database corruption problems, ...
    (comp.databases.ms-access)
  • RE: SQL Server 2005 SP3 fails on cluster environmnet
    ... I had the same issue by reinstalling the SP3. ... By default the setup creates the Temp_MS_AgentSigningCertificate_database ... on specified default database location, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SP3 for MSDE 2000
    ... > When I ran setup from the gui, it just quit complaining about strong ... then it just created a new default instance w/ the SP3 ... >> installation on my machine using a previous network name for my machine ... >> old database is listed, nothing can connect to it since it doesn't ...
    (microsoft.public.security)