sql server msde: Hello everyone,

I posted this several days ago without response, so I thought I would try
again.

I've been trying to install MSDE2000RelA on a Win XP Pro machine without
success. The install rolls back every time. This machine formerly had Win ME
but has been upgraded to XP Home and then to XP Pro. I had the old SQL 7.0
based MSDE intalled under Win ME, but the upgrade to XP Home removed it from
the machine.

The following paste from the install log shows where the rollback apparently
begins. Can anyone suggest a work around that will enable me to get MSDE
installed? I've included several lines before and after "Return value 3".

Thanks in advance for any help.

MSI (s) (00:30) [07:50:34:958]: Executing op:
ActionStart(Name=InstallServices,Description=Installing new
services,Template=Service: [2])
MSI (s) (00:30) [07:50:34:968]: Executing op:
ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (00:30) [07:50:34:968]: Executing op:
ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQLSERVERAGENT,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
MSSQLSERVER,ServiceType=16,StartType=3,ErrorControl=1,,Dependencies=MSSQLSERVER
MSI (s) (00:30) [07:50:35:448]: Executing op:
ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLSERVER,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
-sMSSQLSERVER,ServiceType=16,StartType=2,ErrorControl=1,,,,,,)
MSI (s) (00:30) [07:50:35:869]: Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (00:30) [07:50:35:869]: Executing op:
CustomActionSchedule(Action=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Source=BinaryData,Target=InstallPerfMon,)
MSI (s) (00:CC) [07:50:35:879]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI1D.tmp, Entrypoint: InstallPerfMon
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\default\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\default\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 7:50:36: InstallFinalize. Return value 3.
MSI (s) (00:30) [07:50:36:750]: User policy value 'DisableRollback' is 0
MSI (s) (00:30) [07:50:36:750]: Machine policy value 'DisableRollback' is 0
MSI (s) (00:30) [07:50:36:800]: Executing op:
Header(Signature=1397708873,Version=300,Timestamp=844381757,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (00:30) [07:50:36:800]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (00:30) [07:50:36:800]: Executing op:
DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (00:30) [07:50:36:810]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (00:30) [07:50:36:810]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\1460bc.rbf)
MSI (s) (00:30) [07:50:36:810]: Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (00:30) [07:50:36:810]: Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Microsoft
SQL Server Desktop
Engine,PackageName=SqlRun01.msi,Language=1033,Version=134218489,Assignment=1,ObsoleteArg=0,,,PackageCode={D29DCF7A-8199-4373-BA0D-2F3635EC940C},,,InstanceType=0,LUASetting=0)
MSI (s) (00:30) [07:50:36:820]: Executing op:
ActionStart(Name=InstallServices,Description=Installing new
services,Template=Service: [2])
MSI (s) (00:30) [07:50:36:820]: Executing op:
ServiceControl(,Name=MSSQLSERVER,Action=8,,)
MSI (s) (00:30) [07:50:36:820]: Executing op:
ServiceControl(,Name=SQLSERVERAGENT,Action=8,,)
MSI (s) (00:30) [07:50:36:850]: Executing op:
ActionStart(Name=RegisterTypeLibraries,Description=Registering type
libraries,Template=LibID: [1])
MSI (s) (00:30) [07:50:36:850]: Executing op:
TypeLibraryUnregister(,,FilePath=C:\WINDOWS\system32\atl.dll,LibID={44EC0535-400F-11D0-9DCD-00A0C90391D3},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (00:30) [07:50:36:850]: CMsiServices::ProcessTypeLibrary runs in
local context, not impersonated.
MSI (s) (00:30) [07:50:36:880]: ProcessTypeLibraryCore returns: 0. (0 means
OK)
MSI (s) (00:30) [07:50:36:880]: Executing op:
TypeLibraryUnregister(,,FilePath=C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\dtspump.DLL,LibID={10010200-740B-11D0-AE7B-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (00:30) [07:50:36:880]: CMsiServices::ProcessTypeLibrary runs in
local context, not impersonated.
MSI (s) (00:30) [07:50:36:900]: ProcessTypeLibraryCore returns: 0. (0 means
OK)
MSI (s) (00:30) [07:50:36:900]: Executing op:
TypeLibraryUnregister(,,FilePath=C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\dtspkg.DLL,LibID={10010001-EB1C-11CF-AE6E-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (00:30) [07:50:36:900]: CMsiServices::ProcessTypeLibrary runs in
local context, not impersonated.
MSI (s) (00:30) [07:50:36:970]: ProcessTypeLibraryCore returns: 0. (0 means
OK)
MSI (s) (00:30) [07:50:36:970]: Executing op:

Hi Andrea,
If I ever get the MSDE installed, I'll be using your DBAMgr2K as the
interface, but so far no luck!
After reading a lot of posts with installation problems, I found the
refererence to the clean uninstall procedure and followed it--no luck: same
rollback, same problem (something to do with the installation of PerfMon
values). This included deleting the registry keys and subkeys for "Microsoft
SQL Server" and "MSSQLSERVER", running msizap.exe, and deleting the SQL
Server folders under Program Files . The only thing I noticed is that msizap
does not return any confirmation of success. It just prints out a help list
of switches.

Just to be sure, though, I just went through the whole thing again with the
same results! I"m completely stumped.


[quoted text, click to view]