Installation of MSDE after Microsoft BCM or Microsoft CRM

Hi,
I'm having some problems getting MSDE (SP3a) to install on machines that
already have BCM or CRM installed. The installation rolls back when it nears
the end. I have searched for an answer to this but cannot seem to find one
anywhere. If the install happens the other way round (i.e. MSDE first then
BCM which installs it's own instance) then there is no problem. Am I missing
a particular switch to make this work?
Thanks in advance for your help.
hi,
Joel wrote:
> Hi,
> I'm having some problems getting MSDE (SP3a) to install on machines
> that already have BCM or CRM installed. The installation rolls back
> when it nears the end. I have searched for an answer to this but
> cannot seem to find one anywhere. If the install happens the other
> way round (i.e. MSDE first then BCM which installs it's own instance)
> then there is no problem. Am I missing a particular switch to make
> this work?
> Thanks in advance for your help.
try adding the
/L*v "c:\MsdeLog.txt"
parameter to the setup.exe paramenter collections, in order to enable
verbose logging of the installation process...
you can then inspect the resulting text file for
RETURN VALUE 3
entries, indicating troubles, and about 10/15 lines befor each entry some
(sometime cryptic) description of the problem will be reported..
Andrea Montanari
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
The file reads as follows(part of the file around the Return Value 3):
MSI (s) (4C:9C) [08:07:51:599]: Executing op:
ActionStart(Name=InstallServices,Description=Insta lling new
services,Template=Service: [2])
MSI (s) (4C:9C) [08:07:51:619]: Executing op:
ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
MSI (s) (4C:9C) [08:07:51:659]: Executing op:
ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
MSI (s) (4C:9C) [08:07:52:080]: Executing op:
ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
-sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
MSI (s) (4C:9C) [08:07:52:521]: Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:52:541]: Executing op:
CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
Loading extended custom action library sqlcax.dll
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
MSI (s) (4C:9C) [08:07:54:273]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:54:283]: Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (4C:9C) [08:07:54:293]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:54:293]: Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
Loading extended custom action library sqlcax.dll
Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 08:07:55: InstallFinalize. Return value 3.
MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
MSI (s) (4C:9C) [08:07:55:285]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:55:285]: Executing op:
ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
SQL Server Desktop
Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
MSI (s) (4C:9C) [08:07:55:295]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:55:295]: Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
Loading extended custom action library sqlcax.dll
"Andrea Montanari" wrote:

> hi,
> Joel wrote:
> try adding the
> /L*v "c:\MsdeLog.txt"
> parameter to the setup.exe paramenter collections, in order to enable
> verbose logging of the installation process...
> you can then inspect the resulting text file for
> RETURN VALUE 3
> entries, indicating troubles, and about 10/15 lines befor each entry some
> (sometime cryptic) description of the problem will be reported..
> --
> Andrea Montanari
> http://www.asql.biz/DbaMgr.shtm
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Oh and the server service is running, I have checked that already from
previous posts.
"Joel" wrote:
[vbcol=seagreen]
> Hi Andrea,
> The file reads as follows(part of the file around the Return Value 3):
> MSI (s) (4C:9C) [08:07:51:599]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (4C:9C) [08:07:51:619]: Executing op:
> ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
> MSI (s) (4C:9C) [08:07:51:659]: Executing op:
> ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
> MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
> MSI (s) (4C:9C) [08:07:52:080]: Executing op:
> ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
> -sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
> MSI (s) (4C:9C) [08:07:52:521]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:52:541]: Executing op:
> CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
> MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> MSI (s) (4C:9C) [08:07:54:273]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:283]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallSQLAgentSecurity
> LoadLibrary failed for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
> Action ended 08:07:55: InstallFinalize. Return value 3.
> MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
>
> "Andrea Montanari" wrote:
|||I think I have found the workaround from the following KB article, BUG: MSDE
Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2
Installed:
http://support.microsoft.com/default...b;en-us;299351
This has allowed me to install successfully.
"Joel" wrote:
[vbcol=seagreen]
> Hi Andrea,
> The file reads as follows(part of the file around the Return Value 3):
> MSI (s) (4C:9C) [08:07:51:599]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (4C:9C) [08:07:51:619]: Executing op:
> ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
> MSI (s) (4C:9C) [08:07:51:659]: Executing op:
> ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
> MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
> MSI (s) (4C:9C) [08:07:52:080]: Executing op:
> ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
> -sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
> MSI (s) (4C:9C) [08:07:52:521]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:52:541]: Executing op:
> CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
> MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> MSI (s) (4C:9C) [08:07:54:273]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:283]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallSQLAgentSecurity
> LoadLibrary failed for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
> Action ended 08:07:55: InstallFinalize. Return value 3.
> MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
>
> "Andrea Montanari" wrote: