Re: SP3 for MSDE 2000

From: Chuck (ctkenyon@marketrx.com)
Date: 01/27/03 

From: ctkenyon@marketrx.com (Chuck)
Date: 27 Jan 2003 09:03:32 -0800

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: Installing MSDE from VB.NET
    ... The same hanging behavior occurs when I run MSDE setup ... When I do that, the install hangs, and I use task manager to kill it. ... > How to use MSDE Merge Modules in VS.Net Setup project ...
    (microsoft.public.sqlserver.setup)
  • Re: MSDE 2000 Release A: Windows Authentication Mode or Mixed Mode
    ... should do to solve the error message you received: ... You should run setup from the command line as ... > install the MSDE 2003 Release A in my PC. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Checking File and Print Sharing
    ... I believe this is more of an application setup issue than SQL Server setup ... Microsoft Online Partner Support ... | I'm creating an installation program that will install a VB.NET program ... | an instance of MSDE on an unknown desktop. ...
    (microsoft.public.sqlserver.setup)
  • Re: SP3 for MSDE 2000
    ... > How do I install this over the MSDE version that comes with the .NET ... I ran the Desktop SP3 setup.exe and it installed the ... the MSI file used to install this version of MSDE has a strange ...
    (microsoft.public.sqlserver.security)
  • 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 ... > My computer also insists that there is an MSDE ... >> How do I install this over the MSDE version that comes with the .NET ...
    (microsoft.public.security)