Showing posts with label rolls. Show all posts
Showing posts with label rolls. Show all posts

Friday, March 9, 2012

MSDE installation rolls back automatically

When i try to install MSDE 1.0 .. it runs the install .. and thenautomatically uninstalls again...

I turned on the Verbose logging.. and found out the InstallSQLAgentSecurity is failing...

How can I get past this error? and what is causing it to fail? I am running the install as a local administrator on windows 2003.

ThanksAny help would be appreciated..|||There should be some other messages in the MSI log. Also, is there anything in the Windows event logs?

Don|||the event log only says that MSDE failed to install... the SQLSERVER Security agent is the first error in the log .... I will check the log again.. and post all the errors that find in it.. i can also post the file online.. if it will help...|||I can't say for sure that it'll help, but it might provide some clues.

Don

MSDE installation rollback

Hi,
I am trying to install msde as part of the installation with Live
Communications server. The installation rolls back with the following
shorten version of the log file. Any suggestions you could give me
will be helpful.
....
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (MACHINENAME,LocalSystem,87).
Action ended 11:44:27: InstallFinalize. Return value 3.
MSI (s) (38:60): User policy value 'DisableRollback' is 0
MSI (s) (38:60): Machine policy value 'DisableRollback' is 0
MSI (s) (38:60): Executing op:
Header(Signature=1397708873,Version=200,Timestamp= 827547001,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (38:60): Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (38:60): Executing op: DialogInfo(Type=1,Argument=Microsoft
SQL Server Desktop Engine)
MSI (s) (38:60): Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing
backup files,CleanupTemplate=File: [1])
MSI (s) (38:60): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Microsoft
SQL Server Desktop Engine,PackageName=sqlrun01.msi,Language=1033,Vers ion=134218489,Assignment=1,ObsoleteArg=0,,,Package Code={D29DCF7A-8199-4
373-BA0D-2F3635EC940C},,,InstanceType=0)
MSI (s) (38:60): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (38:CC): Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSIAED.tmp, Entrypoint: UnInstSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\ADMINI~1.LEG\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~1.LEG\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
MSI (s) (38:60): Executing op:
ActionStart(Name=InstallSQLAdHlp.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
ActionStart(Name=InstallServices,Description=Insta lling new
services,Template=Service: [2])
MSI (s) (38:60): Executing op:
ServiceControl(,Name=MSSQL$RTC,Action=8,,)
MSI (s) (38:60): Executing op:
ServiceControl(,Name=SQLAgent$RTC,Action=8,,)
MSI (s) (38:60): Executing op:
ActionStart(Name=RegisterTypeLibraries,Description =Registering type
libraries,Template=LibID: [1])
MSI (s) (38:60): 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) (38:60): Note: 1: 1402 2:
UNKNOWN\TypeLib\{10010200-740B-11D0-AE7B-00AA004A34D5}\0.0\0\win32 3:
2
MSI (s) (38:60): CMsiServices::ProcessTypeLibrary runs in local
context, not impersonated.
MSI (s) (38:60): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (38:60): 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) (38:60): Note: 1: 1402 2:
UNKNOWN\TypeLib\{10010001-EB1C-11CF-AE6E-00AA004A34D5}\0.0\0\win32 3:
2
MSI (s) (38:60): CMsiServices::ProcessTypeLibrary runs in local
context, not impersonated.
MSI (s) (38:60): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (38:60): Executing op:
TypeLibraryUnregister(,,FilePath=C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQLDMO.dll,LibID={10010001-E260-11CF-AE68-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (38:60): Note: 1: 1402 2:
UNKNOWN\TypeLib\{10010001-E260-11CF-AE68-00AA004A34D5}\0.0\0\win32 3:
2
MSI (s) (38:60): CMsiServices::ProcessTypeLibrary runs in local
context, not impersonated.
MSI (s) (38:60): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (38:60): Executing op:
ActionStart(Name=WriteEnvironmentStrings,Descripti on=Updating
environment strings,Template=Name: [1], Value: [2], Action [3])
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=System\CurrentControlSet\Control\Se ssion
Manager\Environment,,)
MSI (s) (38:60): Executing op:
RegAddValue(Name=PATH,Value=#%C:\Program Files\Support
Tools\;%SystemRoot%\system32;%SystemRoot%;%SystemR oot%\System32\Wbem,)
MSI (s) (38:60): Executing op:
ActionStart(Name=DisableSqlAgent.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
ActionStart(Name=RollbackDisableSqlAgent.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
CustomActionRollback(Action=RollbackDisableSqlAgen t.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=UndoDisableSqlAgent, )
MSI (s) (38:F0): Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSIAEE.tmp, Entrypoint: UndoDisableSqlAgent
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\ADMINI~1.LEG\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~1.LEG\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UndoDisableSqlAgent()
Starting custom action UpdateDisableSqlAgent()
Ending custom action UpdateDisableSqlAgent()
Ending custom action UndoDisableSqlAgent()
MSI (s) (38:60): Executing op:
ActionStart(Name=DisableNetAccess.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,,)
MSI (s) (38:60): Executing op:
ActionStart(Name=WriteRegistryValues,Description=W riting system
registry values,Template=Key: [1], Name: [2], Value: [3])
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\E ventLog\Application\RTC,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=TypesSupported,Value=#255,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=EventMessageFile,Value=C:\PROG RA~1\MICROS~3\MSSQL$~1\Binn\RESOUR~1\1033\sqlevn70 .rll,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=CategoryMessageFile,Value=C:\P ROGRA~1\MICROS~3\MSSQL$~1\Binn\RESOUR~1\1033\sqlev n70.rll,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=CategoryCount,Value=#8,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\EventLog\Application\RTC
3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\E ventLog\Application\SQLCTR$RTC,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=TypesSupported,Value=#7,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=EventMessageFile,Value=C:\PROG RA~1\MICROS~3\MSSQL$~1\Binn\RESOUR~1\1033\sqlevn70 .rll,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\EventLog\Application\SQLCTR$RTC
3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\CurrentVersion,,BinaryType= 0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Language,Value=#1033,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\Tracking,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name={E07FDDA4-5A21-11d2-9DAD-00C04F79D434},,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name={6DC86044-0C71-11d3-9E18-00C04F79D434},,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\SQLServerSCP,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\M SSQL$RTC\Linkage,,BinaryType=0)
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Export,Value=
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$RTC\Linkage
3: 2
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$RTC\Linkage
3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SQLPath,Value=C:\Program Files\Microsoft SQL
Server\80\Tools\,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup\CurrentVersion,,Binary Type=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=CurrentVersion,Value=8.00.194, )
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup\CurrentVersion 3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\SuperSocketNetLib\Tcp,,Bina ryType=0)
MSI (s) (38:60): Executing op: RegRemoveValue(Name=TcpPort,Value=0,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=TcpDynamicPorts,Value=0,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=TcpHideFlag,Value=#0,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\SuperSocketNetLib\Tcp 3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\Parameters,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SQLArg2,Value=-lC:\Program Files\Microsoft SQL
Server\MSSQL$RTC\Data\mastlog.ldf,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SQLArg1,Value=-eC:\Program Files\Microsoft SQL
Server\MSSQL$RTC\LOG\ERRORLOG,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SQLArg0,Value=-dC:\Program Files\Microsoft SQL
Server\MSSQL$RTC\Data\master.mdf,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\Parameters 3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=Software\Microsoft\MSSQLServer\Clie nt,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SharedMemoryOn,Value=#1,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\SuperSocketNetLib\Np,,Binar yType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=PipeName,Value=\\.\pipe\MSSQL$ RTC\sql\query,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\SuperSocketNetLib\Np 3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server,,BinaryType=0)
MSI (s) (38:60): Executing op: RegRemoveValue(Name=SsrpActiveServer,,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=InstalledInstances,Value=
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\Setup,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SQLPath,Value=C:\Program Files\Microsoft SQL
Server\MSSQL$RTC\,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SQLDataRoot,Value=C:\Program Files\Microsoft SQL
Server\MSSQL$RTC\,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=ProductCode,Value={E09B48B5-E141-427A-AB0C-D3605127224A},)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=FirstStart,Value=#1,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=FeatureName,Value=SqlRun,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\RTC\Setup
3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=Software\Microsoft\MSSQLServer\Clie nt\ConnectTo,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=DSQUERY,Value=DBNETLIB,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\ Client\ConnectTo 3:
2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\MSSQLServer\Clie nt\SuperSocketNetLib\Tcp,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=DefaultPort,Value=#1433,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\SuperSocketNetLib\Tcp
3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Tapeloadwaittime,Value=#429496 7295,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=SetHostName,Value=#0,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Map$,,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Map#,Value=-,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Map_,Value=\,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=LoginMode,Value=#0,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=ListenOn,Value=SSMSSH70
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=DefaultLogin,Value=guest,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=AuditLevel,Value=#0,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\Service Manager,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Services,Value=MSDTC
MSI (s) (38:60): Executing op: RegAddValue(Name=Services,Value=
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Services,Value=
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Remote,Value=#1,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Default,Value=RTC,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=Action
Verify,Value=#0,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\Service Manager 3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\CurrentVersion,,BinaryType= 0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=CSDVersion,Value=8.00.761,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=CSDVersionNumber,Value=#768,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=SerialNumber,,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegRemoveValue(Name=RegisteredOwner,,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=CurrentVersion,Value=8.00.194, )
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\RTC\MSSQLServer\CurrentVersion 3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\M SSQL$RTC\Performance,,BinaryType=0)
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Collect,Value=CollectSQLPerfor manceData,)
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$RTC\Performance
3: 2
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Close,Value=CloseSQLPerformanc eData,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Open,Value=OpenSQLPerformanceD ata,)
MSI (s) (38:60): Executing op: RegCreateKey()
MSI (s) (38:60): Executing op:
RegRemoveValue(Name=Library,Value=C:\PROGRA~1\MICR OS~3\MSSQL$~1\Binn\sqlctr80.dll,)
MSI (s) (38:60): Executing op: RegRemoveKey()
MSI (s) (38:60): Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$RTC\Performance
3: 2
MSI (s) (38:60): Executing op:
RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\MSSQLServer\Clie nt\SuperSocketNetLib,,
....
....
Property(C): ACTION = INSTALL
=== Logging stopped: 10/19/2004 11:44:41 ===
MSI (c) (94:84): Note: 1: 1708
MSI (c) (94:84): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
MSI (c) (94:84): Grabbed execution mutex.
MSI (c) (94:84): Cleaning up uninstalled install packages, if any
exist
MSI (c) (94:84): MainEngineThread is returning 1603
=== Verbose logging stopped: 10/19/2004 11:44:41 ===
hi,
"bigp" <bigpotatousa@.gmail.com> ha scritto nel messaggio
news:583919ed.0410191348.5e88411e@.posting.google.c om
> Hi,
> I am trying to install msde as part of the installation with Live
> Communications server. The installation rolls back with the following
> shorten version of the log file. Any suggestions you could give me
> will be helpful.
please have a look at
http://www.google.it/groups?as_q=Ins... um=100&hl=it
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Tried the resolutions from those posting, but there's no luck. Are
there any other workarounds to this problem?
Thanks,
Bigp
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2tmu76F204o8tU1@.uni-berlin.de>...
> hi,
> "bigp" <bigpotatousa@.gmail.com> ha scritto nel messaggio
> news:583919ed.0410191348.5e88411e@.posting.google.c om
> please have a look at
> http://www.google.it/groups?as_q=Ins... um=100&hl=it

Wednesday, March 7, 2012

MSDE Installation Error on Win9x

I am installing MSDE on win 9x machines and am having a problem. The installation aborts and the installshield unattend.iss script rolls back the installation. It seems the failure is in the cnfgsvr.exe program (based on the sqlstp.log file).

the command line that I use is:
msdex86 -s -a -f1 "c:\unattend.iss"

The log files sqlstp.log and cnfgsvr.out are included below.

I have seen some postings similar to this, but never a resolution. Any help would be appreciated...

Here are the log files...

Sqlstp.log file
~~~~~~~~~~~~~~~~~~~sqlstp.log~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
13:53:56 Begin Setup
13:53:56 7.00.623
13:53:56 Mode=Silent
13:53:56 ModeType=NORMAL
13:53:57 ValueFTS returned: 0
13:53:57 ValuePID returned: 0
13:53:57 ValueLic returned: 0
13:53:57 GetDefinitionEx returned: 0, Extended: 0x0
13:53:57 System: Windows 95
13:53:57 SQL Server ProductType: MSDE [0x4]
13:53:57 Begin Action: SetupInitialize
13:53:57 End Action SetupInitialize
13:53:57 Fixed install: 0
13:53:57 Begin Action: CheckRequirements
13:53:57 Platform ID: 0xf0000
13:53:57 Version: 4.0.67109975
13:53:57 DCOM95 has been detected.
13:53:57 File Version - C:\WINDOWS\SYSTEM\shdocvw.dll: 5.50.4134.600
13:53:57 ComputerName: JMCGUIRE1
13:53:57 User Name: cbauerle
13:53:57 Domain: JMCGUIRE1
13:53:57 OS Language: 0x409
13:53:57 End Action CheckRequirements
13:53:57 Begin Action: Detection
13:53:57 End Action Detection
13:53:57 Begin Action: ODBCLocked
13:53:57 C:\WINDOWS\TEMP\_ISTMP0.DIR\odbcinst.exe -IsLocked -Silent 1 -SourceDir C:\WINDOWS\TEMP\PFT234~1\X86\ODBC -LogFile C:\WINDOWS\sqlodbci.log
13:53:58 Process Exit Code: (-1)
13:53:58 End Action ODBCLocked
13:53:58 This combination of Package and Operating System allows a full product install.
13:53:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
13:53:58 CommonFilesDir=C:\Program Files\Common Files
13:53:58 Windows Directory=C:\WINDOWS\
13:53:58 Begin Action: ShowDialogs
13:53:58 Begin Action: DialogShowSdWelcome
13:53:58 End Action DialogShowSdWelcome
13:53:58 Begin Action: DialogShowSdLicense
13:53:58 End Action DialogShowSdLicense
13:53:58 Begin Action: DialogShowSdRegisterUserEx
13:53:58 End Action DialogShowSdRegisterUserEx
13:53:58 Begin Action: DialogShowSdSetupType
13:53:58 [SetupTypeSQL]
13:53:58 Result=302
13:53:58 szDir=C:\MSSQL7
13:53:58 final szDir=C:\MSSQL7
13:53:58 szDataDir=C:\MSSQL7
13:53:58 final szDataDir=C:\MSSQL7
13:53:58 End Action DialogShowSdSetupType
13:53:58 Begin Action: DialogShowSdComponentMult
13:53:58 End Action DialogShowSdComponentMult
13:53:58 Begin Action: DlgCpSortUnicode
13:53:58 Result=1
13:53:58 [DlgCpSortUnicode]
13:53:58 SortId=52
13:53:58 LCID=1033
13:53:58 CompStyle=196609
13:53:58 End Action DlgCpSortUnicode
13:53:58 Begin Action: DlgNetwork
13:53:58 Result=1
13:53:58 [DlgServerNetwork]
13:53:58 NetworkLibs=4095
13:53:58 TCPPort=1433
13:53:58 TCPPrxy=
13:53:58 NMPPipeName=\\.\pipe\sql\query
13:53:58 End Action DlgNetwork
13:53:58 Begin Action: DlgServices
13:53:58 [DlgServices]
13:53:58 Result=1
13:53:58 Local-Domain=3855
13:53:58 AutoStart=61455
13:53:58 End Action DlgServices
13:53:58 Begin Action: DialogShowSdStartCopy
13:53:58 End Action DialogShowSdStartCopy
13:53:58 Begin Action: DlgCPLLicense
13:53:58 End Action DlgCPLLicense
13:53:58 End Action ShowDialogs
13:53:58 Begin Action ProcessBeforeDataMove:
13:53:58 DeinstallStart returned (C:\MSSQL7): 0
13:53:58 End Action ProcessBeforeDataMove:
13:53:58 Begin Action ProcessComponentSelection:
13:53:58 End Action ProcessComponentSelection
13:53:58 Begin Action LogSelectedComponents:
13:53:58 SQLProg
13:53:58 SQLProg\SQLServr
13:53:58 SQLProg\SQLServr\Help
13:53:58 SQLProg\SQLServr\SCMDev
13:53:58 SQLProg\SQLServr\SCMDev\SCMh
13:53:58 SQLProg\SQLServr\SCMDev\SCMX86Lb
13:53:58 SQLProg\SQLServr\SCMDev\SCMALb
13:53:59 SQLProg\ReplSupp
13:53:59 SQLProg\ReplSupp\ReplSys
13:53:59 SQLProg\ReplSupp\ReplSys1
13:53:59 SQLProg\ReplSupp\RepComm
13:53:59 SQLProg\Dat
13:53:59 SQLProg\BaseSys
13:53:59 SQLProg\BaseBinn
13:53:59 Core
13:53:59 CoreSys
13:53:59 ODBC
13:53:59 OLEDB
13:53:59 CoreMisc
13:53:59 Jet
13:53:59 NetCore
13:53:59 CoreInst
13:53:59 Core1033
13:53:59 CoreIntl
13:53:59 CrMi1033
13:53:59 CrMiIntl
13:53:59 SysCore
13:53:59 VOLEDB
13:53:59 VODBC
13:53:59 CrRepCom
13:53:59 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
13:53:59 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
13:53:59 End Action LogSelectedComponents
13:54:00 SQL program folder: C:\MSSQL7
13:54:00 SQL data folder: C:\MSSQL7
13:54:00 Windows system folder: C:\WINDOWS\SYSTEM\
13:54:00 Prog req: 15751, Data req: 20447, Sys req: 4433
13:54:00 Prog avail: 792068, Data avail: 792068, Sys avail: 792068
13:54:00 Prog req vs. avail, 40631, 792068
13:54:00 Data req vs. avail, 20447, 792068
13:54:00 Sys req vs. avail, 24880, 792068
13:54:00 DisplaySystemPreReq
13:54:00 Begin Action MoveFileData:
13:54:32 End Action MoveFileData
13:54:32 Begin Action ProcessAfterDataMove:
13:54:32 DeinstallSetReference (C:\MSSQL7\sqlservr.exe) returned: 0
13:54:32 End Action ProcessAfterDataMove
13:54:32 Begin Action InstallPkgs:
13:54:32 Setup is installing Microsoft Data Access Components (MDAC) ...
13:54:32 C:\WINDOWS\TEMP\pft2344~TMP\x86\Other\mdac_typ.exe /q:a /c:"setup.exe /qtn"
13:55:44 Process Exit Code: (3010)
13:55:44 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
13:55:44 C:\WINDOWS\TEMP\pft2344~TMP\x86\Other\dtcsetup.exe /q:a /r:n
13:56:04 Process Exit Code: (0)
13:56:04 End Action InstallPkgs
13:56:04 Begin Action BuildServer:
13:56:04 SetNewPath returned: 3010
13:56:04 Path successfully updated.
13:56:04 C:\MSSQL7\binn\cnfgsvr.exe -Silent 1 -NoSampleDB 1 -SQLPath "C:\MSSQL7\" -SQLDataPath "C:\MSSQL7\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 732 -User sa -Pwd
13:58:14 Process Exit Code: (-1)
13:58:14 Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information.
13:58:14 Action CleanUpInstall:
13:58:14 C:\WINDOWS\TEMP\_ISTMP0.DIR\scm.exe -Silent 1 -Action 4 -Service SQLServerAgent
13:58:14 Process Exit Code: (0)
13:58:14 Installation Failed.
~~~~~~~~~~~~~~~end sqlstp.log~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

cnfgsvr.out file
~~~~~~~~~~~~~~~~~~~cnfgsvr.out~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
Starting Service ...

Connecting to Server ...

driver={sql server};server=JMCGUIRE1;UID=sa;PWD=;database=mast er

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=JMCGUIRE1;UID=sa;PWD=;database=mast er

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=.;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).

SQL Server configuration failed.
~~~~~~~~~~~~~~~end cnfgsvr.out~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~I am able to easily reproduce the error with the following steps:

1. Install WIN95b
2. Install IE5.5
3. Install MDAC 2.6SP1
4. Install MSDE

MSDE does not install on a win95 machine that has MDAC installed.

If I install MSDE, then MDAC it is OK.

Any thoughts??

MSDE Install rolls back - not same as other posts

Windows Server 2003 with SP1.
I'm trying to install MSDE Release A (no previous installations of MSDE
exist on this server). Just before the "Please wait while Windows configures
Microsoft SQL Server Desktop Engine" finishes, the 'Cancel' button disappears
and the installation rolls back. No error message.
I ran setup through a command line with the logging parameter: setup.exe
/L*v "c:\msdelog.log" and found a 'Return Value 3' (the surrounding contents
shown below):
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (PEREZ2006,LocalSystem,87).
Action ended 13:05:25: InstallFinalize. Return value 3.
In addition, the following event appears in the Application Event Viewer:
Event Type:Information
Event Source:MsiInstaller
Event Category:None
Event ID:11708
Date:10/2/2006
Time:1:37:27 PM
User:PEREZDESIGN\Administrator
Computer:PEREZ2006
Description:
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 45 30 39 42 34 38 42 {E09B48B
0008: 35 2d 45 31 34 31 2d 34 5-E141-4
0010: 32 37 41 2d 41 42 30 43 27A-AB0C
0018: 2d 44 33 36 30 35 31 32 -D360512
0020: 37 32 32 34 41 7d 7224A}
I have confirmed that the antivirus is disabled, file & printer sharing is
enabled, and the Server service is running. I am logged in as a domain Admin.
Any help is greatly appreciated!
aguilab@.networkinnovations.us
Brian Aguila
hi Brian,
Brian Aguila wrote:
>..
> I ran setup through a command line with the logging parameter:
> setup.exe /L*v "c:\msdelog.log" and found a 'Return Value 3' (the
> surrounding contents shown below):
> --
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (PEREZ2006,LocalSystem,87).
> Action ended 13:05:25: InstallFinalize. Return value 3.
> ...
> I have confirmed that the antivirus is disabled, file & printer
> sharing is enabled, and the Server service is running. I am logged
> in as a domain Admin.
are you perhaps installing MSDE in Terminal Server Application mode?
http://support.microsoft.com/default...b;en-us;317268
http://support.microsoft.com/default...b;EN-US;238162
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
|||No, ma'am, this server is not running in terminal services application mode.
"Andrea Montanari" wrote:

> hi Brian,
> Brian Aguila wrote:
> are you perhaps installing MSDE in Terminal Server Application mode?
> http://support.microsoft.com/default...b;en-us;317268
> http://support.microsoft.com/default...b;EN-US;238162
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||hi Brian,
Brian Aguila wrote:
> No, ma'am,
sir ;D

> this server is not running in terminal services
> application mode.
try having a look at
http://www.experts-exchange.com/Data..._21114173.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

Saturday, February 25, 2012

MSDE Install Failure

On a Win2Ksp3 server I am trying to install MSDE. However everytome the
installation nears the end and then rolls back. All I get in the log is:
Event Type:Information
Event Source:MsiInstaller
Event Category:None
Event ID:11708
Date:04/05/2004
Time:22:30:20
User:N/A
Computer:ORASERVER1
Description:
Product: Microsoft SQL Server Desktop Engine -- Installation operation
failed.
This came about after uninstalling BackupExec9.0 and attemtping a install of
BackupExec9.1 which also fails because it cannot install MSDE. Any ideas, I
cannot find much in Knowledgebase.
TIA
> This came about after uninstalling BackupExec9.0 and attemtping a
> install of BackupExec9.1 which also fails because it cannot install
> MSDE. Any ideas, I cannot find much in Knowledgebase.
> TIA
I read somebody's post on here today about how this went away if they
installed SP4.
WTH
|||was happening to me on a particular machine.
enabling file sharing service fixed it.
check msde dependencies to see if you have them all on your machine ?
Ranjeet.
<David> wrote in message news:OkREFBiMEHA.3556@.TK2MSFTNGP09.phx.gbl...
> On a Win2Ksp3 server I am trying to install MSDE. However everytome the
> installation nears the end and then rolls back. All I get in the log is:
> Event Type: Information
> Event Source: MsiInstaller
> Event Category: None
> Event ID: 11708
> Date: 04/05/2004
> Time: 22:30:20
> User: N/A
> Computer: ORASERVER1
> Description:
> Product: Microsoft SQL Server Desktop Engine -- Installation operation
> failed.
> This came about after uninstalling BackupExec9.0 and attemtping a install
of
> BackupExec9.1 which also fails because it cannot install MSDE. Any ideas,
I
> cannot find much in Knowledgebase.
> TIA
|||What is the 'file sharing service'?
and what dependencies exist?
I have upgraded to SP4 and it has mde no difference.

MSDE Install Failure

I am trying to install MSDE2 on Win2k server with SP4, as with many other
posts when I try and install it just rolls back. The error log generated
lists
Starting custom action NoRebootReplace
TempFolder Property is C:\WINNT\TEMP\
Source Dir Property is C:\WINNT\TEMP\SqlSetup\Temp
NoRebootConnectRepl returned: 3
Action ended 16:53:55: InstallFinalize. Return value 3.
Action ended 16:53:55: INSTALL. Return value 3.
Does anyone know why this would be?
Many Thanks
hi Phil,
"Phil Milburn" <phil.milburn@.cmiplc.co.uk> ha scritto nel messaggio
news:OqaSZ%238pEHA.2604@.TK2MSFTNGP10.phx.gbl
> I am trying to install MSDE2 on Win2k server with SP4, as with many
> other posts when I try and install it just rolls back. The error log
> generated lists
> Starting custom action NoRebootReplace
> TempFolder Property is C:\WINNT\TEMP\
> Source Dir Property is C:\WINNT\TEMP\SqlSetup\Temp
> NoRebootConnectRepl returned: 3
> Action ended 16:53:55: InstallFinalize. Return value 3.
> Action ended 16:53:55: INSTALL. Return value 3.
> Does anyone know why this would be?
> Many Thanks
are you installing on Terminal Server using Application Server Mode?
please add about 10/20 rows before and after the retun value 3 line
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply