Page 1 of 1
Error installing SQL express 2005 on 64-bit system.
Posted: Tue Feb 02, 2010 11:48 am
by sangle
I have a 32 bit installer package containing a 32-bit app and 32-bit SQL express 2005.This installs and works fine on a 32-bit system.
However when trying to install on a 64-bit system (2008 server or windows 7) I get the following error message.
"SQL Express 2005 could not be installed. Please use windows update to manually install this update on your system"
The installation works fine on 64 bit if I exclude the SQL Express 2005 part of the installation.
What do I need to do to fix this. Any advise much appreciated.
Update on 64 bit SQL express 2005 installation issue
Posted: Wed Feb 03, 2010 5:00 pm
by sangle
After looking at the scripts one more time,I noticed that the
"SQL Express 2005 could not be installed. Please use windows update to manually install this update on your system"
is a geenric error that is thrown in the setupsqlexpr script if the return code is something other than 0 or 3010. So I modified that message to say
"SQL Express 2005 could not be installed. Error Code= $SQLEXISTS$"
where $SQLEXISTS$ is the error code returned. According to the help file this error code should be one of the standard list of Windows Installer error codes.
http://support.microsoft.com/kb/229683
However after I rebuilt and ran the installation on a 64 bit box the error displayed as expected
"SQL Express 2005 could not be installed. Error Code=70047"
I am unable to find what error 70047 stands for. Please help.
Re: Error installing SQL express 2005 on 64-bit system.
Posted: Mon Nov 28, 2011 10:42 am
by broux
I have the same problem on a windows 7 x64.
here is the script that I use:
Code: Select all
~InstallAware Clipboard Data~
~Comment~
~{20607A09-5D42-4167-816C-5B5706767A85}~
~~
~Write Registry~
~{E966EFE4-B1DB-45DC-847D-88C8054E99F6}~
~0~
~2~
~SOFTWARE\Trace Software\$TITLE$\Install~
~SQLServer2005_Result~
~$SQLSERVER_INSTALL_RESULT$~
~TRUE~
~FALSE~
~SQL Server Express~
~{295DC007-3F88-4CD8-8FAF-6D222A45B1B6}~
~";2005;SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=""pwd_test"" INSTANCENAME=""TR_INSTANCENAME"" ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity",SQLSERVER_INSTALL_RESULT~
~mSQLExpress.dll\mSQLExpressExec.dll~
~Set Variable~
~{0633C443-71CE-4F3A-806D-2247CE6213FB}~
~SQLSERVER_INSTALL_RESULT$MYAH$MYAH$FALSE~
~FALSE~
Error code: 70047
Maybe a component is missing?
Re: Error installing SQL express 2005 on 64-bit system.
Posted: Mon Nov 28, 2011 2:52 pm
by giaviv
That is definitely possible. Are you able to test this on a different machine?
Re: Error installing SQL express 2005 on 64-bit system.
Posted: Tue Dec 06, 2011 6:04 pm
by giaviv
In addition, it will be good to run the SQL Server setup outside of InstallAware, in full GUI mode, so that in the SQL Server setup GUI, the error will be natively raised, possibly together with more information on diagnosing and resolving the issue that is causing the problem.