Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:4

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 go to a school with a 4-day timetable; that is to say, classes repeat in the same order every 4 days. Is there any way to get events in Calendar to repeat every 4 business days?I just tested and here is what I get...Read other 7 answers [More]
I have started to create a Family website using iWeb and want to be able to allow family members to upload and download pictures to their own albums on the site.  It looks like a MobileMe Gallery would provide that type of functionality, but I do not [More]
OS: CentOS 5.8 64-bit DB: Oracle XE 11gR1 64-bit Gateway: Oracle Gateway for ODBC 64-bit Database and gateway reside on same Linux Server. Connecting to remote Sybase SQL Anywhere 10 server on WindowsXP. Using SQL Anywhere 11 odbc driver and unixODBC [More]
I have a user that is trying to view a PDF using Acrobat X and has random characters display instead of text.  Other users with Acrobat X are able to view the document fine as well as other users who have previous version of Reader.  I have tried run [More]
I'm battling with an issue that I cannot figure out. I have a DVD menu built in Photoshop.  The menu items are simple text items with a duplicate (=1) for the highlighted part when someone mouses or uses remote to select.  The (=1) hightlight is a it [More]
Hi, I must have 1 email address from my email-domain (intern and external) that always send the mails to the external smtp-server. example: mail domain is novellrocks.com email address create is [email protected] So when we send internal our external [More]
Does anyone know how to produce the equivalent of an Enumeration with the new Collection classes like ArrayList and HashMap? My situation is that I've got a collection (ArrayList) inside of my class, and I'd like clients to be able to see what's in t [More]
Hi SAP Experts, I am facing this problem. When an external system is calling my SAP RFC/Web Service, the external system(which is not SAP) is not getting the correct value. But when I test the RFC in SAP GUI It is working correctly. When I test betwe [More]
This may sound stupid but how do I contact support so that I can reset my security questions and have my account unlocked so I can purchase again? I tried the links provider for in the account page. 1. go to the www.apple.com/support 2. clicked on iT [More]
A friend of mine with an iPhone4 and iOS5 reported to me he could not find (had lost) some contacts in the address book. When i used the spotlight-page (swipe in the homescreen so you get to see the screen to the left of the homescreen) COULD find th [More]