Installer terminated prematurely
I am installing application on AMD64 bit machine. Application needs to attach Database to existing SQL Server 2005 and stop and start the SQL Services.
During Installation at StopServices section, i get this error. Please find below details from install log file.
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=13200)
MSI (s) (50:A4) [09:45:39:311]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs,,BinaryType=0)
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTick()
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=13200)
MSI (s) (50:A4) [09:45:39:311]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs,,BinaryType=0)
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTick()
MSI (s) (50:A4) [09:45:39:311]: Executing op: ActionStart(Name=StopServices,Description=Stopping services,Template=Service: [1])
Action 9:45:39: StopServices. Stopping services
MSI (s) (50:A4) [09:45:39:327]: Executing op: ProgressTotal(Total=4,Type=1,ByteEquivalent=1300000)
MSI (s) (50:A4) [09:45:39:327]: Executing op: ServiceControl(,Name=DLOMaintenanceSvc,Action=2,,)
MSI (s) (50:A4) [09:45:39:327]: Executing op: ServiceControl(,Name=DLOAdminSvcu,Action=2,,)
MSI (s) (50:A4) [09:45:39:327]: Executing op: ServiceControl(,Name=MSSQLSERVER,Action=2,Wait=0,)
StopServices: Service: SQL Server (MSSQLSERVER)
MSI (s) (50:A4) [09:45:40:640]: Internal Exception during install operation: 0xc00000fd at 0x0000000077EF3BCC.
MSI (s) (50:A4) [09:45:40:640]: WER report disabled for non-console install.
MSI (s) (50:A4) [09:45:40:640]: Internal MSI error. Installer terminated prematurely.
Installer terminated prematurely.
Any idea why and where I should be debugging?
During Installation at StopServices section, i get this error. Please find below details from install log file.
MSI (s) (50:A4) [09:45:39:311]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs,,BinaryType=0)
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTick()
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=13200)
MSI (s) (50:A4) [09:45:39:311]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs,,BinaryType=0)
MSI (s) (50:A4) [09:45:39:311]: Executing op: ProgressTick()
MSI (s) (50:A4) [09:45:39:311]: Executing op: ActionStart(Name=StopServices,Description=Stopping services,Template=Service: [1])
Action 9:45:39: StopServices. Stopping services
MSI (s) (50:A4) [09:45:39:327]: Executing op: ProgressTotal(Total=4,Type=1,ByteEquivalent=1300000)
MSI (s) (50:A4) [09:45:39:327]: Executing op: ServiceControl(,Name=DLOMaintenanceSvc,Action=2,,)
MSI (s) (50:A4) [09:45:39:327]: Executing op: ServiceControl(,Name=DLOAdminSvcu,Action=2,,)
MSI (s) (50:A4) [09:45:39:327]: Executing op: ServiceControl(,Name=MSSQLSERVER,Action=2,Wait=0,)
StopServices: Service: SQL Server (MSSQLSERVER)
MSI (s) (50:A4) [09:45:40:640]: Internal Exception during install operation: 0xc00000fd at 0x0000000077EF3BCC.
MSI (s) (50:A4) [09:45:40:640]: WER report disabled for non-console install.
MSI (s) (50:A4) [09:45:40:640]: Internal MSI error. Installer terminated prematurely.
Any idea why and where I should be debugging?
0 Comments
[ + ] Show comments
Answers (10)
Please log in to answer
Posted by:
Inabus
15 years ago
1) Remove the start and stop service functions from your MSI
2) On a clean build install sqlserver 2005, as usual I assume
3) Stop the sql service
4) Install your MSI
5) Try and start the sql service
If this doesnt work then its your package, if it does work its your package but I would assume that you need to stop the serivce first, before installing the database and then start afterwards.
P
2) On a clean build install sqlserver 2005, as usual I assume
3) Stop the sql service
4) Install your MSI
5) Try and start the sql service
If this doesnt work then its your package, if it does work its your package but I would assume that you need to stop the serivce first, before installing the database and then start afterwards.
P
Posted by:
zipsantro
15 years ago
Posted by:
anonymous_9363
15 years ago
I'm curious to know...if all the app needs to do is to attach the database,why on earth does it need to stop and restart SQL Server? Surely it should just attach the d/b?!? In fact, isn't there a pre-built script for use with OSQL for this very purpose? Or a stored procedure? If not, try http://www.databasejournal.com/features/mssql/article.php/1548361/Automating-SQL-Server-Management-with-WMI-Part-2.htm
Posted by:
Inabus
15 years ago
Posted by:
anonymous_9363
15 years ago
Posted by:
zipsantro
15 years ago
Posted by:
zipsantro
15 years ago
While analysing, I have noticed the below log file details.
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: LocalAppDataFolder , Object: C:\Documents and Settings\mtk\Local Settings\Application Data\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: DesktopFolder , Object: C:\Documents and Settings\All Users\Desktop\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: CommonFilesFolder , Object: C:\Program Files (x86)\Common Files\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: ISCommonFilesFolder , Object: C:\Program Files (x86)\Common Files\InstallShield\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: CommonAppDataFolder , Object: C:\Documents and Settings\All Users\Application Data\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: ProgramFilesFolder , Object: C:\Program Files (x86)\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: MicrosoftSqlServer , Object: C:\Program Files (x86)\Microsoft SQL Server\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: Sql80 , Object: C:\Program Files (x86)\Microsoft SQL Server\80\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: SqlTools , Object: C:\Program Files (x86)\Microsoft SQL Server\80\Tools\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: SqlCommonBinn , Object: C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: MSSQL , Object: C:\Program Files (x86)\Microsoft SQL Server\MSSQL$DLO\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: Binn , Object: C:\Program Files (x86)\Microsoft SQL Server\MSSQL$DLO\Binn\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: SQLBINNDIR.FBF6AB5B_373C_4CD4_B277_E08D4D444E2C , Object: E:\MSSQL\MSSQL.1\MSSQL\Binn\
It seems the installer looks for 32bit dirs of MSSQL server.
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: DesktopFolder , Object: C:\Documents and Settings\All Users\Desktop\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: CommonFilesFolder , Object: C:\Program Files (x86)\Common Files\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: ISCommonFilesFolder , Object: C:\Program Files (x86)\Common Files\InstallShield\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: CommonAppDataFolder , Object: C:\Documents and Settings\All Users\Application Data\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: ProgramFilesFolder , Object: C:\Program Files (x86)\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: MicrosoftSqlServer , Object: C:\Program Files (x86)\Microsoft SQL Server\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: Sql80 , Object: C:\Program Files (x86)\Microsoft SQL Server\80\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: SqlTools , Object: C:\Program Files (x86)\Microsoft SQL Server\80\Tools\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: SqlCommonBinn , Object: C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: MSSQL , Object: C:\Program Files (x86)\Microsoft SQL Server\MSSQL$DLO\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: Binn , Object: C:\Program Files (x86)\Microsoft SQL Server\MSSQL$DLO\Binn\
MSI (c) (2C:A0) [09:44:54:937]: Dir (target): Key: SQLBINNDIR.FBF6AB5B_373C_4CD4_B277_E08D4D444E2C , Object: E:\MSSQL\MSSQL.1\MSSQL\Binn\
It seems the installer looks for 32bit dirs of MSSQL server.
Posted by:
Inabus
15 years ago
Aye, borked, but I aint packaged on x64 so am unable to help you further other than to say break it down bit by bit.
1) Does MSSQL install standalone properly?
2) Can you manually add and create the SQL database
3) When you say this is a new MSI, was it a snapshot or new MSI from scratch with source file added to the installer manually?
1) Does MSSQL install standalone properly?
2) Can you manually add and create the SQL database
3) When you say this is a new MSI, was it a snapshot or new MSI from scratch with source file added to the installer manually?
Posted by:
anonymous_9363
15 years ago
Posted by:
zipsantro
15 years ago
Thanks guys!
The issue has been resolved.
Problem Description: -
The installer tries to stop SQL Service before executing some Extended SPs and attaching the DB. In AMD 64 machines the security/group policies are applied in such a way that it won't allow logged on users to stop the service, only a service account will have the permission. Hence installer fails.
Solution Description
Attaching the DB and Extended SPs doesn't need SQL Service to be stopped (As suggested by VBScab). So, we modified that way it has implemented and removed the action to stop SQLService on installation(As suggested by Paul).
Jeeoo!
Santro
The issue has been resolved.
Problem Description: -
The installer tries to stop SQL Service before executing some Extended SPs and attaching the DB. In AMD 64 machines the security/group policies are applied in such a way that it won't allow logged on users to stop the service, only a service account will have the permission. Hence installer fails.
Solution Description
Attaching the DB and Extended SPs doesn't need SQL Service to be stopped (As suggested by VBScab). So, we modified that way it has implemented and removed the action to stop SQLService on installation(As suggested by Paul).
Jeeoo!
Santro
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.