MSDE 2000 Install Problems

I have been developing an application that uses MSDE 2000 as it's database.
In the process of testing/debugging my installation, I have run into an
interesting and very frustrating problem. MSDE now completely refuses to
install anymore! I cannot get the installer to install either as part of my
installer package using the MSDEBootstrap release candidate "or" by running
the MSDE setup from the command line.
I tried attaching the verbose log from my last command-line attempt, but
this newsgroup blocks my message due to size constraints. If anyone can
provide me any insight into how to resolve this, it would be much
appreciated. The error generated by the install is the ambiguous error
1603. The portion of the log which seems to contain the location where
things are goofin up follows:
MSI (s) (2C:08): Doing action:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B
Action start 8:35:54:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B.
MSI (s) (2C:08): Creating MSIHANDLE (49) of type 790542 for thread 3592
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
TempFolder is
C:\DOCUME~1\sbrodie\LOCALS~1\Temp\{689404D2-1C94-44B3-9203-BEC5594FDA7A}\
Loading extended custom action library
C:\DOCUME~1\sbrodie\LOCALS~1\Temp\{689404D2-1C94-44B3-9203-BEC5594FDA7A}\sql
cax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
Starting custom action SetPropSQLMSDEInstalled
FindSet for ProductCode <{689404D2-1C94-44B3-9203-BEC5594FDA7A}> returned 2
Setting SQLMSDEInstalled by MsiSetProperty returned 0
Setting SQLMSDESelected by MsiSetProperty returned 0
End SetPropSQLMSDEInstalled
Action ended 8:35:55:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B. Return value
1.
MSI (s) (2C:08): Doing action:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B
Action start 8:35:55:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (2C:08): Creating MSIHANDLE (59) of type 790542 for thread 3592
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 8:35:55:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 8:35:55: INSTALL. Return value 3.
MSI (s) (2C:08): Note: 1: 2262 2: Control 3: -2147287038
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\DMSF
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = DMSF
Property(S): SqlSa...
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): INSTALLLEVEL = 3
Property(S): LIMITUI = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {689404D2-1C94-44B3-9203-BEC5594FDA7A}
Property(S): ProductLanguage = 1033
Property(S): ProductName = Microsoft SQL Server Desktop Engine
Property(S): ProductVersion = 8.00.761
Property(S): MsiHiddenProperties = SqlSa...
Property(S): ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B =
C:\Program Files\
Property(S): StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINDOWS\System32\
Property(S): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 8.00.194
Property(S): SQLMSDEInstalled = 1
Property(S): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 1603
Regards
Shane Brodie
"Shane Brodie" <sbrodie@.deorkit.com> wrote in message
news:u5BCBXJIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> I have been developing an application that uses MSDE 2000 as it's
database.
> In the process of testing/debugging my installation, I have run into an
> interesting and very frustrating problem. MSDE now completely refuses to
> install anymore! I cannot get the installer to install either as part of
my
> installer package using the MSDEBootstrap release candidate "or" by
running
> the MSDE setup from the command line.
>
You may want to try a manual removal of the SQL Server 2000 Desktop database
(MSDE), reboot then re-install.
http://www.support.microsoft.com/?id=320873
Steve
|||Thanks Steve:
Been there ... done that ... got the t-shirt. Following is a part of my
daily blog at work:
...
Frustration day. Had a bunch of problems with MSDE and the release candidate
installer used to install the database as part of a VS.Net project. For
whatever reason, the installer is refusing to install MSDE on my machine
even after performing an in-place update of Windows XP, uninstalling and
re-installing SQL Server tools and another instance of MSDE I am running and
performing an exhaustive filesystem and registry "search and destroy
mission" to remove any existing references to my database instance. BTW:
It would be really ... nice ... if Microsoft would post expected release
dates of the final release of "release candidate" software(give or take 6
months ; ) ).
Existing newsgroup postings report similar problems and the log files
generated by the Windows Installer and Event Viewer are somewhat less than
informative ...
In the meantime, I have managed to install an instance of MS SQL Server
using the official SQL Server 2000 Personal Edition CD so that I can
continue development while I fight with this issue. I am following up on the
MS newsgroups and elsewhere to see if there are permanent work-arounds/fixes
for this problem.
...
As well installation fails whether I use the generated installation from my
VS.Net solution or if I perform a command-line install of MSDE2000a.
Sorry about the double post ... Outlook Express complained on the size of
the message plus log (and I assumed that it meant it did not send ...) and
then sent it anyways.
Regards
Shane Brodie