« Previous Next »

• 06-13-2009, 9:42 AM

  mbolduc Joined on 06-13-2009, 1:38 PM Posts 3

  WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact  Greetings. Trying to install features via the web platform installer.   SQL Server Express fails to install.  Error code is -2067529721.  Log below. Any suggestion on how to resolve this?  Thank you.    DownloadManager Information: 0 : Adding product SQL Server Express 2008 with Service Pack 1 (www.microsoft.com/web/webpi/2.0/WebProductList.xml?79) to cart DownloadManager Information: 0 : Product 'www.microsoft.com/web/webpi/2.0/WebProductList.xml?79' was already in cart. DownloadManager Information: 0 : Configuring SQL DownloadManager Information: 0 : Using SQL mixed mode authentication DownloadManager Information: 0 : Setting current install to 1 DownloadManager Information: 0 : Starting install sequence DownloadManager Information: 0 : Downloading file 'http://go.microsoft.com/fwlink/?LinkID=146798' to: C:\Users\Marc\AppData\Local\Temp\tmp5E4E.tmp DownloadManager Information: 0 : Moving downloaded file 'C:\Users\Marc\AppData\Local\Temp\tmp5E4E.tmp' to: C:\Users\Marc\AppData\Local\Microsoft\Web Platform Installer\installers\SQLEXPR32_x86_ENU1.exe DownloadManager Information: 0 : Starting EXE install for product 'SQL Server Express 2008 with Service Pack 1'. Commandline is: 'C:\Users\Marc\AppData\Local\Microsoft\Web Platform Installer\installers\SQLEXPR32_x86_ENU1.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCStartupType=Automatic /AddCurrentUserAsSqlAdmin /ENABLERANU=1 /hideconsole /SECURITYMODE=SQL /SAPWD="Admin"' DownloadManager Information: 0 : Waiting for process: 5096 - C:\Users\Marc\AppData\Local\Microsoft\Web Platform Installer\installers\SQLEXPR32_x86_ENU1.exe DownloadManager Information: 0 : Install exit code for product 'SQL Server Express 2008 with Service Pack 1' is -2067529721 DownloadManager Error: 0 : Install return code for product 'SQL Server Express 2008 with Service Pack 1' is Failure DownloadManager Information: 0 : Product SQL Server Express 2008 with Service Pack 1 done install completed DownloadManager Information: 0 : Increasing current install to 2 DownloadManager Information: 0 : Clearing cart

  Tags: SQL Express 2005 2008sql Express 2008SQL Express 2008 install

• 06-13-2009, 12:57 PM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28	Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact would you please tell us what else is already installed on the machine? Previous versions of SQL.. which? Visual Studio.. which?  Also, is the SQL Management Tools shortcut present on the "Programs" menu? Carmen -- SQL Server Management Studio

• 06-13-2009, 5:00 PM

  In reply to

  mbolduc Joined on 06-13-2009, 1:38 PM Posts 3

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact Hi Carmen > would you please tell us what else is already installed on the machine? OS is Vista Ultimate Packages that are installed that look relevant Microsoft .NET Framework 3.5 SP1 Microsoft Silverlight Microsoft SQL Server 2008 Management Objects Microsoft SQL Server 2008 Native Client Microsoft SQL Server Driver for PHP 1.0 Microsoft SQL Server Native Client Microsoft Visual C++ 2005 Redistributable Microsoft Web Platform Installer 2.0 Beta Microsoft Windoes PowerShell snap-in for IIS 7.0 MSXML 4.0 SP2 (KB954430) PHP 5.2.9-2 Asside from that, there are a few games, Skype, Windows live stuff, Quickcam. > Previous versions of SQL.. which? None as far as I know. > Visual Studio.. which?  Visual Studio per se is not installed.  Only "Microsoft Visual C++ 2005 Redistributable" > Also, is the SQL Management Tools shortcut present on the "Programs" menu? Nope. I have not tried removing anything an trying installing again yet. Thank you for assisting me.  ...marc

• 06-13-2009, 10:54 PM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact If I remember correctly, SQL tries to install MSXML v 6.0. Also, it only works with Powershell v1.0 -- If you are in a hurry, you can try to uninstall the versions you have and try the SQL installation again. There is also another log that might be more verbose as far as the actual error is concerned. There are mentions of it on this forum, I can find it for you. If you *can* wait until Monday, I will find out exactly what the error code means and let you know.   Carmen -- SQL Server Management Studio

• 06-14-2009, 12:41 AM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28	Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact Log location: %program files%\Microsoft SQL Server\100\Setup Bootstrap\Log\<datetime> Carmen -- SQL Server Management Studio

• 06-15-2009, 11:35 AM

  In reply to

  jcloughley Joined on 06-15-2009, 3:33 PM Posts 3

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact I received the same error number while trying to install MS SQL Server 2008 Express and it was due to .Net Framework 3.5 SP1 not being installed as a pre-requisite.  It appears that you have it installed but I didn't. I'm adding this comment to hopefully help others that may get the same error and not realize the dependency on .Net 3.5 Jim

• 06-15-2009, 11:49 AM

  In reply to

  jcloughley Joined on 06-15-2009, 3:33 PM Posts 3	Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact Oh.  You might also check for PowerShell 1.0 and MSI 4.5 are also installed.  Those are two other pre-requisites I'm aware of. Jim

• 06-15-2009, 12:09 PM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact As a general rule, you may want to go to the official microsoft.com website and look up SQL Express prerequisites before you start. WebPI is built to look up some dependencies and SQL Setup to look those and others, but the combinations that people can have on their computers are so diverse that it may be possible every so often to miss something.  I will provide a "translation" to that code a bit later Carmen -- SQL Server Management Studio

• 06-15-2009, 12:15 PM

  In reply to

  choyer Joined on 01-29-2008, 2:02 AM Posts 127

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact Hi Jim, Thanks for reporting this!  Web PI should be bringing along all the dependencies a product needs (with the exception of MySQL for some applications).  We must have our detection logic for .NET 3.5 SP1 incorrect.  Do you happen to know if Web PI tried to install .NET Framework?  You would have seen this as another product included in the list of products to be installed.  If it wasn't, do you happen to know what version of the .NET framework you had on your machine? Thanks, Crystal Web Platform Installer Program Manager IIS Program Manager

• 06-15-2009, 12:33 PM

  In reply to

  jcloughley Joined on 06-15-2009, 3:33 PM Posts 3

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact I'm not sure.  I was installing something else that in turn "silently" installs SQLServer 2008 Express.  I got that error code from the installer - not from the WebPI. I then went back and launched the MSSE installer separately and got the more meaningful message about .Net 3.5 SP1 not being installed.  Once I installed it, the install went fine. Jim

• 06-15-2009, 7:54 PM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact The error Marc reported -2067529721 means that .Net 2.0 SP2 is not installed on the machine. Microsoft lists .Net 2.0 as a prerequisite for SQL Express because it needs the CLR but doesnt install it (it's a "mini" version). .Net 2.0 SP2 comes as a "bonus" with .Net 3.5 SP1 but it is possible that after the installation someone went and uninstalled it whether purposefully or accidentally. I'd apprecaite it if you confirmed that this solved the problem :-) Carmen Carmen -- SQL Server Management Studio

• 06-15-2009, 8:07 PM

  In reply to

  mbolduc Joined on 06-13-2009, 1:38 PM Posts 3

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact Hi Carmen. SQL Express just installed successfully.  Two things I noticed.  First, the Windows update log from this morning showed that .NET 3,5 SP1 installed in the last update.  Now the list of installed programs showed that it was already there.  What I did wrong here I do not know.  Is it possible that the .Net 3,5 SP1 build via WPI is not the same 'stamp' as that of windows update?  Not likely, but possible I suppose. Second, my first attempt at installing SQLe this evening failed, but the log filed showed that ... the admin password I was using was not strong enough... ahem...OK.. fixed that... :) Thanks you and everyone on this thread for your help.   Let me know if there are any further questions. ...marc

• 06-15-2009, 8:19 PM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28	Re: WPI - SQL Server Express 2008 with Service PMarc,ack 1 fails to install Reply Contact Marc,  thanks much for letting us know that installation succeeded! Carmen -- SQL Server Management Studio

• 06-16-2009, 10:43 AM

  In reply to

  prinkal Joined on 06-16-2009, 12:41 PM Posts 2	Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact installation of SQL sever express 2008 with sp1  through platform installer failed though the powershell and .net 2 has been installed successfully in my computer... can sm1 help is there smthng we need to do with the log files, if yes please also tell me how to access the windows archive log files... pls help..

• 06-16-2009, 10:50 AM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28

  Re: WPI - SQL Server Express 2008 with Service Pack 1 fails to install Reply Contact Hi!  What is the error code reported with the installation failure? Also, you should have Powershell v1.0 and .Net 3.5 SP1 installed on your machine at this time. You can check versions in Control Panel..Add/Remove Programs (on XP) and Control Panel / Programs and Features (in Vista) Carmen -- SQL Server Management Studio