Sitemap

Amicuk Programming Answers

Installing SQL-Server with WiX : fails if older version is present

-0001-11-30   Views:0

Advertisement

Hi, I have a problem with my SQLServer 2014(Express) silent installation, in case there is a older Version e.g. SQL-Server 2012(Express) installed. The log shows the following error: [02DC:0C48][2014-12-04T10:53:30]i301: Applying execute package: SQL

Hi,
I have a problem with my SQLServer 2014(Express) silent installation, in case there is a older Version e.g. SQL-Server 2012(Express) installed.
The log shows the following error:
[02DC:0C48][2014-12-04T10:53:30]i301: Applying execute package: SQLEXPR_x64_ENU.exe, action: Install, path: C:\ProgramData\Package Cache\38E0D08F06AF2F907E1AEBDCA0444B828AE356B5\SQLEXPR_x64_ENU.exe, arguments: '"C:\ProgramData\Package Cache\38E0D08F06AF2F907E1AEBDCA0444B828AE356B5\SQLEXPR_x64_ENU.exe" /ACTION=Install /INSTANCENAME=SQLExpress /FEATURES=SQL,Tools /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCSTARTUPTYPE=Automatic /SQLSYSADMINACCOUNTS=BUILTIN\Administrators /ADDCURRENTUSERASSQLADMIN=TRUE /Q /HIDECONSOLE /SkipRules=RebootRequiredCheck /IAcceptSQLServerLicenseTerms'
[02DC:0C48][2014-12-04T10:55:54]e000: Error 0x84bb0001: Process returned error: 0x84bb0001
Some facts:
- My setup works well, if I use a plain Windows 7/64 installation (VM)
- If I uninstall the older SQL-Server Version, setup works well also.
- The SQLServer installation is part of a WiX-Bootstrapping project
<util:RegistrySearch
Id="SqlInstanceKeyFound"
Root="HKLM"
Key="SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL"
Value="$(var.InstanceName)"
Result="exists"
Variable="SqlInstanceKeyFound" />
<util:RegistrySearch
Id="SqlInstanceKey"
Root="HKLM"
Key="SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL"
Value="$(var.InstanceName)"
Variable="SqlInstanceKey"
After="SqlInstanceKeyFound"
Condition="SqlInstanceKeyFound" />
<util:RegistrySearch
Id="SqlInstanceFound"
Root="HKLM"
Key="SOFTWARE\Microsoft\Microsoft SQL Server\[SqlInstanceKey]"
Result="exists"
Variable="SqlInstanceFound"
After="SqlInstanceKey"
Condition="SqlInstanceKeyFound" />
<util:RegistrySearch
Id="SqlVersion"
Root="HKLM"
Key="SOFTWARE\Microsoft\Microsoft SQL Server\[SqlInstanceKey]\Setup"
Value="Version"
Variable="SqlVersion"
After="SqlInstanceKey"
Condition="SqlInstanceFound" />
<PackageGroup Id="SQLexpress2014">
<ExePackage
DisplayName="SQL Server 2014 Express"
Cache="yes"
Compressed="yes"
PerMachine="yes"
Permanent="yes"
Vital="yes"
SourceFile="C:\temp\SQLEXPR_x64_ENU.exe"
InstallCommand="/ACTION=Install /INSTANCENAME=$(var.InstanceName) /FEATURES=SQL,Tools /TCPENABLED=1 /SQLSVCACCOUNT=&quot;NT AUTHORITY\NETWORK SERVICE&quot; /SQLSVCSTARTUPTYPE=Automatic /SQLSYSADMINACCOUNTS=BUILTIN\Administrators /ADDCURRENTUSERASSQLADMIN=TRUE /Q /HIDECONSOLE /SkipRules=RebootRequiredCheck /IAcceptSQLServerLicenseTerms"
UninstallCommand="/Action=Uninstall /INSTANCENAME=$(var.InstanceName) /FEATURES=SQL /Q /HIDECONSOLE"
DetectCondition="SqlInstanceFound">
<ExitCode Value ="3010" Behavior="forceReboot" />
</ExePackage>
</PackageGroup>
It looks that I would need to check for older versions as well !?
If so, is there a generic way to do that?
Thanks for any hints and help.
Regards
Rainer

The replay answer
Advertisement
SQLEXPR_x64_ENU.exe" /ACTION=Install /INSTANCENAME=SQLExpress
/FEATURES=....
Hello Rainer,
The installation don't fail because an "older" instance exists, it fail because an SQL Server instance with the same name already exits; SQLEXPRESS is the default name and very common, you will see a lot of machines running a SQLEXPRESS instance.
Instance names must be unique per machine, so use a different instance name for your application, e.g. "SQLRainerQueck"
Olaf Helper
[ Blog] [ Xing] [ MVP]

Go to See the other 6 answers

Installing SQL-Server with WiX : fails if older version is present

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a problem with my SQLServer 2014(Express) silent installation, in case there is a older Version e.g. SQL-Server 2012(Express) installed. The log shows the following error: [02DC:0C48][2014-12-04T10:53:30]i301: Applying execute package: SQL[More]

Unable to install SQL Server Express 2008 R2 - Errors "Failed to retrieve data for this request"

Category:DefaultRelease time:2015-10-11Views:130

As domain admin I am attempting to install "SQL Server 2008 R2 with SP2" but it keeps failing with "Failed to retrieve data for this request". The installation never actually starts, it errors before then. It displays the same error ev[More]

The unattended installation failed while installing SQL Server 2008 R2 ????

Category:DefaultRelease time:2015-10-11Views:130

Hi gurus, I got an error while installing SQL Server 2008 R2 in Windows 2008 R2 standard 64 bit operating system. LOG file* Customized installation of SQL Server 2008R2 for SAP * Detailed results:   Feature:                       Database Engine Serv[More]

Cannot Install Sql Server 2008, Gives The Error "Database Engine Services Failed"

Category:DefaultRelease time:-0001-11-30Views:130

I cannot install Sql Server 2008 R2 on Windows 8. Tried many times but failed because it gives the error "Database Engine Services Failed". Sql files cannot be corrupted because i can install the same setup on Windows 7 and i can connect to data[More]

I Am Getting Failed Notifications When Installing SQL SERVER 2008 can any one suggest me Wt can i do

Category:DefaultRelease time:-0001-11-30Views:130

Overall summary:   Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.   Exit code (Decimal):           -20686[More]

Issues installing SQL Server 2008 instance - Install fails

Category:DefaultRelease time:-0001-11-30Views:130

Hi there, I have a server windows server 2008 R2 standard. While doing an Enterprise to Standard downgrade, I have removed enterprise edition of SQL Server 2008, rebooted and while installing standard edition, I get the below error saying "You SQL se[More]

Installing SQL Server 2008 R2 via command line - setup100.exe returned exit code 0x84BC06B2

Category:DefaultRelease time:-0001-11-30Views:130

I am receiving an exit code 0x84BC06B2 when installing SQLExpress via the command line on a PC that also has SQL Server 2012 installed.  Below is the log file generated: 11/18/2014 01:02:41.631 Help display: false 11/18/2014 01:02:41.642 Checking to[More]

Error message when installing SQL Server 2014 Express

Category:DefaultRelease time:2015-10-11Views:130

When installing SQL Server 2014 Express, I get the error shown below. Why do I get this and how to correct for it? TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: An error occurred during the installation of assembly 'Microso[More]

Unable to install SQL Server 2012 Developer

Category:DefaultRelease time:2015-10-11Views:130

I have a problem with installing SQL Server 2012 (no matter which edition I choose). Installation usually runs well, but near the end shows up an error: TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup The following error has occurred: Wait on t[More]

Unable to install SQL Server 2012 Standard: Error code 0x851A0019

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am trying to install sql server 2012 standard edition on windows server 2008R2 but at the end of the installation it is giving me the following error message:  "The following error has occurred: Wait on the Database Engine recovery handle f[More]

Unable to install SQL Server 2012 on my Surface 3 computerr w/Windows 8.1 as the OS

Category:DefaultRelease time:2015-10-11Views:130

Another user, Cheer08, has replied to a thread you have subscribed to in the SQL Server Express Forum. Here are the error messages: Error 2 Error 1 Hello, This error is related to Microsoft Visual C++ 2005. Could you try to download and install Micro[More]

Hot
Hi Experts, I am getting the error TABLE_INVALID_INDEX.Can any one help for this below error. Short text                                                                                Error in ABAP/4 statement when processing an internal table.       [More]
HI everyone. Im trying to update kernel 620 to kernel 640 on our SAP R/3 Enterprise 4.7 system (Win 2003/MSSQL 2000) I did this following instructions in sap note 664679. I update kernel succesfully in our DEV and QAS system. But in our PRD system du [More]
This is getting really annoying now, I have currently three x 2TB hard drives plugged into the AirPort Extreme via a 4 Bay Enclosure. Everyday, now and then, the connection fails. Meaning it wont let me backup and says "Couldn't find disk". And [More]
I have a passport to back things up, but I'm not sure how to work the time machine and back up everything. Please help!Beachlover4ever, Please watch Apple's Time Machine Tutorial. As the previous poster mentioned the Passport needs to be formatted co [More]
Hi All, Presently I am working oracle spatial database (10gR2). I have following task: Task: Spatial data loading into oracle database 10g Release 2: Task process description: Client has given the input file as with .dgn extension. So we have to conv [More]
Hi Could any one share your ideas on the Relationship between Planned workig time -0007 and BasicPay -Ansal field. Thanks in Advance. Kumar Edited by: kumar Rag on Feb 26, 2009 12:12 PMHi Sikindar, Thx for the replay .I came across this problem while [More]
Hi Experts, We have created 3 custom fields in KOMP structure. Which is required to create condition tables, access sequence. We have successfully created condition tables with the 3 fields along with the standard fields. While creating access sequen [More]
Hi, exists a different in performance with this 2 querys? without the TRUNC in the query: declare l_id      number ; l_id_tip  number := 156 ; l_date    date := trunc(to_date('06/03/2007','dd/mm/yyyy')) ; begin   SELECT DISTINCT id   INTO l_id   FROM [More]
Hi, When I call a WS-Security web service (in WLS 8.1 SP3), it works fine until I set it to encrypt the response. Then I get java.rmi.RemoteException: SOAP Fault:javax.xml.rpc.soap.SOAPFaultExc eption: Exception during processing: weblogic.utils.Asse [More]
how to retrieve tuples based on some criteria from a table through procedure call......//how to retrieve tuples based on some criteria from a table through procedure call......//You're gaining a reputation for not being clear about asking your questi [More]