Error installing package in silent mode
Whenever I try to package and run Idera SQL Diagnostic Manger 9.1 (x64) with WISE, I get the following error:
My command string is SQLDiagnosticManager-x64_c.exe /S /v"/qb". I have tried running it with /QN, extracing the MSI with /QB and /QN. The only time when it doesn't fail is when I run the EXE (or extracted MSI) interactively. I've also tried as system and user context, and normal/administrator rights. The same thing happens via CMD prompt. I also have .NET Framework 4.0 installed.
The following is an excerpt from the MSI log:
MSI (s) (78:38) [13:02:59:051]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIEF4A.tmp, Entrypoint: ISSQLServerInstall1: Processing the SQL connection 'SQLdm'...1: Determining if there is at least one SQL script scheduled to execute under the connection...1: The SQL script 'SQLdmDatabaseInstall.sql' is scheduled to execute. Note that the final decision will be made later if you have a schema version specified for this script. Script Execution=RunOnInstall, Action=Install, Component State=Install, Schema=1: Attempting to establish the SQL connection... Server: , Database:1: ADO Error: Number: -2147467259 Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Source: Microsoft OLE DB Provider for SQL Server SQL State: 08001 Native Error: 17MSI (s) (78!0C) [13:03:34:916]: Product: Idera SQL diagnostic manager (x64) -- Error 27502.Could not connect to Microsoft SQL Server ''. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (17)MSI (c) (DC:34) [13:03:32:248]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell DlgError 27502.Could not connect to Microsoft SQL Server ''. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (17)CustomAction ISSQLServerInstall returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Answer Chosen by the Author
Here is the correct MSI packaging instructions to install the Console only (and PowerShell snapins):
- Received IderaSQLdmInstallationKit-x64.zip.
- Extracted to IderaSQLdmInstallationKit-x64.exe
- Extracts to UNPACKED FILES.
- Browse to \X64\ and run SQLDiagnosticManager-x64_c.exe (Console Only).
- Do not install complete install.
- Browse to Users TEMP folder location to find extracted MSI (Installation MSI)
- CREATE MST
- Add PROPERTY - ADDLOCAL=Console,PowerShell_Snapin
Answered 07/06/2015 by: creck
Please log in to comment
log in to commentPlease