Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:5

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
I recently had to install windows on my macbook air, so installed windows 7 using boot camp.. The installation went great and that entire day i was workin on windows on my macbook.. Althogth the next day my macbook air refused to work when i turned i [More]
I have an I phone 4s and I have many contacts in my phone.  However, when my phone rings or I receive a message.  The phone does not show the name of the caller.  It only shows the phone number that is calling.  I am sure this is a setting problem, b [More]
hi I am new to jsp. I would like to retrive the data from database using like command. But my query dosen't work well. Can you help me in this topic. String name = request.getParameter("username"); int i = st.executeQuery("select * from emp [More]
I have reset the ipod twice, connected to my computer and Itunes, synced the device, yet it remains stuck in disk mode.Hold down the center button along with the menu button and then your ipod will turn of After that step has been completed and your [More]
Dear Sir, Kindly guide us about the steps to be followed , for knowing that which USER_EXIT are being called during the MB31 transaction . Also request you to kindly guide us about the steps to be followed in debugging of transaction MB31 . We assure [More]
Hi, I have installed Windows Server 2012 r2 Essentials and successfully connected 5 computers Windows 8.1 Pro to my domain (Test). After that, i removed one of the computer (Test5) from the domain using Essentials Dashboard under Devices --> Remove c [More]
Hello Friends,       I am wokring on the mapping and got stuck at a point. it is an IDoc to Idoc mapping. Only the fields that i am using are mentioned  other fields are to be assumed as per the standard IDOC. This is the source structure: IDOC EDI_D [More]
Hello I got an photoshop subscription card at US and now i'm trying to install it at my computer in Brasil. How can I change my Country information in order to suceed? TksHello, You would need to create a new Adobe ID to reflect the country change si [More]
Hi Friends, could you please guide me i want to know the chages for 4.5b to 6.0 version where can i get the details, it is very important please help me. Waiting for your information. Regards, SreeHi, http://erp.fmpmedia.com/Default.aspx?alias=erp.fm [More]
I upgraded to Mountain Lion and found the Share option in Safari but can't find the Facebook sharing option. Also, the iCould icon is emtpy. Is this not activated yet?1) Facebook Sharing option will be released this fall we don't know when yet! 2) iC [More]