Difficulty installing and upgrading to MSDE SP3a

I have installed MSDE 2000A using the ini file method of supplying
settings. I supplied values for the following settings:
[Options]
ALLOWXDBCHAINING=3D0
BLANKSAPWD=3D1
COLLATION=3DLatin1_General_CI_AS
DATADIR=3DC:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Data\
DISABLENETWORKPROTOCOLS=3D1
INSTANCENAME=3D"HipMSDE" SAPWD=3D"XXXX" SECURITYMODE=3DSQL
TARGETDIR=3DC:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Binn\
Since I was unable to perform this install using the command line:
"Setup.exe /settings Setup.ini"
because it kept telling me the path was not valid, I double clicked on
Setup.exe and it took all the settings in Setup.ini anyway.
In attempting to upgrade to SP3a I attempted to supply the following
settings in an ini file.
[Options]
ALLOWXDBCHAINING=3D0
BLANKSAPWD=3D1
COLLATION=3DLatin1_General_CI_AS
DATADIR=3DC:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Data\
DISABLENETWORKPROTOCOLS=3D1
INSTANCENAME=3D"HipMSDE" SAPWD=3D"XXXX" SECURITYMODE=3DSQL
TARGETDIR=3DC:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Binn\
UPGRADE=3D1 UPGRADEUSER=3D"XXXXUpgr" UPGRADEPWD=3D"XXXXUpgr"
Using the same command line but this time for the SP3a setup file, an
installation does not occur. Trying the same double click too does not
work. Instead I get is the following instructions:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D
Windows =AE Installer. V 3.00.3790.2180
msiexec /Option <Required Parameter> [Optional Parameter]
Install Options
</package | /i> <Product.msi>
Installs or configures a product
/a <Product.msi>
Administrative install - Installs a product on the network
/j<u|m> <Product.msi> [/t <Transform List>] [/g <Language ID>]
Advertises a product - m to all users, u to current user
</uninstall | /x> <Product.msi | ProductCode>
Uninstalls the product
Display Options
/quiet
Quiet mode, no user interaction
/passive
Unattended mode - progress bar only
/q[n|b|r|f]
Sets user interface level
n - No UI
b - Basic UI
r - Reduced UI
f - Full UI (default)
/help
Help information
Restart Options
/norestart
Do not restart after the installation is complete
/promptrestart
Prompts the user for restart if necessary
/forcerestart
Always restart the computer after installation
Logging Options
/l[i|w|e|a|r|u|c|m|o|p|v|x|+|!|*] <LogFile>
i - Status messages
w - Nonfatal warnings
e - All error messages
a - Start up of actions
r - Action-specific records
u - User requests
c - Initial UI parameters
m - Out-of-memory or fatal exit information
o - Out-of-disk-space messages
p - Terminal properties
v - Verbose output
x - Extra debugging information
+ - Append to existing log file
! - Flush each line to the log
* - Log all information, except for v and x options
/log <LogFile>
Equivalent of /l* <LogFile>
Update Options
/update <Update1.msp>[;Update2.msp]
Applies update(s)
/uninstall <PatchCodeGuid>[;Update2.msp] /package <Product.msi |
ProductCode>
Remove update(s) for a product
Repair Options
/f[p|e|c|m|s|o|d|a|u|v] <Product.msi | ProductCode>
Repairs a product
p - only if file is missing
o - if file is missing or an older version is installed (default)
e - if file is missing or an equal or older version is installed
d - if file is missing or a different version is installed
c - if file is missing or checksum does not match the calculated
value
a - forces all files to be reinstalled
u - all required user-specific registry entries (default)
m - all required computer-specific registry entries (default)
s - all existing shortcuts (default)
v - runs from source and recaches local package
Setting Public Properties
[PROPERTY=3DPropertyValue]
Consult the Windows =AE Installer SDK for additional documentation on
the
command line syntax.
Copyright =A9 Microsoft Corporation. All rights reserved.
Portions of this software are based in part on the work of the
Independent JPEG Group.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D
These windows installer instructions and the wealth of SP3a
documentation only leads me to more confusion. I've spent two days
trying to meticulously decypher and make sense of it. I'm lost! Can
someone please help sort this out for me?
BTW I have successfully updated to SP3a for both of my SQL Server 2000
database installations. It's this MSDE that I am having difficulty
undersatnding
hi,
dbuchanan wrote:
> I have installed MSDE 2000A using the ini file method of supplying
> settings. I supplied values for the following settings:
> [Options]
> ALLOWXDBCHAINING=0
> BLANKSAPWD=1
> COLLATION=Latin1_General_CI_AS
> DATADIR=C:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Data\
> DISABLENETWORKPROTOCOLS=1
> INSTANCENAME="HipMSDE" SAPWD="XXXX" SECURITYMODE=SQL
> TARGETDIR=C:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Binn\
> Since I was unable to perform this install using the command line:
> "Setup.exe /settings Setup.ini"
> because it kept telling me the path was not valid, I double clicked on
> Setup.exe and it took all the settings in Setup.ini anyway.
> In attempting to upgrade to SP3a I attempted to supply the following
> settings in an ini file.
> [Options]
> ALLOWXDBCHAINING=0
> BLANKSAPWD=1
> COLLATION=Latin1_General_CI_AS
> DATADIR=C:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Data\
> DISABLENETWORKPROTOCOLS=1
> INSTANCENAME="HipMSDE" SAPWD="XXXX" SECURITYMODE=SQL
> TARGETDIR=C:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Binn\
> UPGRADE=1 UPGRADEUSER="XXXXUpgr" UPGRADEPWD="XXXXUpgr"
> Using the same command line but this time for the SP3a setup file, an
> installation does not occur. Trying the same double click too does not
> work. Instead I get is the following instructions:
>...
MSDE 2000A is already updated at sp3a level and you do not need to upgrade
it..
if you are experimenting troubles with the ini file, you can directly
provide those parameters to the setup.exe bootstrap installer in the form
c:\..\>setup.exe ALLOWXDBCHAINING=0 COLLATION="Latin1_General_CI_AS"
DATADIR="C:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Data\"
DISABLENETWORKPROTOCOLS=1 INSTANCENAME="HipMSDE" SAPWD="XXXX"
SECURITYMODE=SQL TARGETDIR="C:\Program Files\Microsoft SQL
Server\MSSQL$HipMSDE\Binn\"
all on the same line
you provide BLANKSAPWD=1 and SAPWD="XXXX" parameters, and those should be
mutual exclusive, so please try removing BLANKSAPWD=1

> UPGRADE=1 UPGRADEUSER="XXXXUpgr" UPGRADEPWD="XXXXUpgr"
are not required as you do not have to upgrade...
please always add the
/L*v "c:\MsdeLog.txt"
parameter too in order to verbose log all the installation process, that
will result in an about 2mb txt log file you can inspect, in case of
problems, for
RETURN VALUE 3
entries, that indicate problems and, about 10/20 lines before or after each
entry a more descriptive (often cryptic) explanation of the problem is
reported
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply