Re: Service pack MSDE problem

From: SQL Server Development Team [MSFT] (sqldev@microsoft.com)
Date: 01/30/03 

From: "SQL Server Development Team [MSFT]" <sqldev@microsoft.com>
Date: Thu, 30 Jan 2003 10:53:41 -0800

Hi Pupo,

You may be running the SP install on computer that does not have a default
instance and did not specify an instance name. Hence setup tried to find the
default instance and fails with the "Instance name invalid" error message.
Also, there could be a typo if you did specify an instance using the
INSTANCENAME= command.

To find the instances you are running:

Right click on My Computer.

Select Manage

Double click on Services and Applications

Double click Services.

Default instances of either SQL Server 2000 or MSDE 2000 will be listed as a
service named MSSQLSERVER. Named instances will be listed as services named
MSSQL$instancename.

Here is some more information also:

Where is the documentation for installing Service Pack 3 on an instance of
MSDE 2000?
The installation is documented in the service pack readme file. Most of the
information related to installing Service Pack 3 on MSDE 2000 is in section
3.7. The English version of the readme is available on this Web page:

http://www.microsoft.com/sql/downloads/2000/SP3readme.htm

The readme files for other languages are in the service pack download.

Af.ter downloading and extracting the Service Pack 3 files, the readme is
available as the file SP3Readme.htm at the root of the extracted files.

How do I upgrade an existing instance of MSDE 2000 to SP3?
Execute the file setup.exe in the MSDE folder extracted from the Service
Pack 3 download. Do not attempt to start setup by clicking on or otherwise
invoking the .msi files in the /msi subfolder or the .msm files in the /msm
subfolder.

A typical syntax for executing setup is:

setup.exe /upgradesp sqlrun instancename=<> securitymode=sql upgradeuser=<>
upgradepwd=<> /l*v <log file>

  1.. Use instancename only if named instance, if default remove this
parameter.
  2.. Use upgradeuser and upgradepwd if your sapwd is set to not null, or if
you want to use another admin on your machine, otherwise you can replace
this with blanksapwd=1
  3.. Create a log file so that you can easily evaluate if upgrade was
successful or see if there are errors
Sometimes you must also use the /upgradesp switch to specify which of the 16
.msi files for MSDE were used to install the instance of MSDE 2000. This
Microsoft Knowledge Base Article tells you how to determine which .msi file
to specify:

http://support.microsoft.com/default.aspx?scid=kb;en-us;311762

Thanks,
Dave Nettleton 

--
SQL Server Development Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Pupo" <123star@libero.it> wrote in message
news:e6nVRXFyCHA.2296@TK2MSFTNGP10...
> Hi
> I installed SQL SP3 with no problem, now i try to install SQL2KDeskSP3.exe
> and when i start setup after few seconds appears a prompt with "The
istance
> name specified is invalid", i controlled with microsoft documents and i
have
> desktop engine installed.
> Can help me to resolve this problem?
> Thank Pupo
>
>

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: 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.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)
  • 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)