Sql server express SP2 Bootstrapper package

[Steve]

Hi All

I downloaded Sql server 2005 express SP2 and attempted to modify the
Bootstrapper package files as I did with SP1

When i try to install SQL server as part of my VS 2005 deployment app I get
an error at the end of the SQL server install phase 'Invalid endpoint'.
(Note SQL server express gets installed OK)

If I run SQL server express SP2 setup directly it I don't get the error

There must be something wrong in the .xml bootstrapper files

Any ideas?

Steve

Product.xml
...................................................................
<?xml version="1.0" encoding="utf-8"?>
<Product xmlns="http://schemas.microsoft.com/developer/2004/01/bootstrapper"
ProductCode="Microsoft.Sql.Server.Express.SP2">
<RelatedProducts>
<DependsOnProduct Code="Microsoft.Net.Framework.2.0" />
<DependsOnProduct Code="Microsoft.Windows.Installer.3.1" />
</RelatedProducts>
<PackageFiles>
<PackageFile Name="SqlExpressSP2Chk.exe" />
</PackageFiles>
<InstallChecks>
<ExternalCheck Property="SQLExpressSP2Installed"
PackageFile="SqlExpressSP2Chk.exe" />
</InstallChecks>
</Product>

Package.xml................................

<?xml version="1.0" encoding="utf-8" ?>
<Package
xmlns="http://schemas.microsoft.com/developer/2004/01/bootstrapper"
Name="DisplayName"
Culture="Culture"
LicenseAgreement="eula.txt"
<PackageFiles CopyAllPackageFiles="false">
<PackageFile Name="sqlexpr32.exe" HomeSite="SqlExprExe32"

<PackageFile Name="eula.txt"/>
</PackageFiles>
<InstallChecks>
<RegistryCheck Key="HKLM\Software\Osmonttemp" Value="installsqlserver"
Property="Installsqlserver" />
</InstallChecks>
<Commands Reboot="Defer">
<Command PackageFile="sqlexpr32.exe"
Arguments='-q /norebootchk /qn reboot=ReallySuppress
ADDLOCAL=ALL SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 INSTANCENAME=OsmontTech
SECURITYMODE=SQL SAPWD=nissan DISABLENETWORKPROTOCOLS=0'
EstimatedInstalledBytes="208494592"
EstimatedTempBytes="208494592"
EstimatedInstallSeconds="1050">
<InstallConditions>
<BypassIf Property="SQLExpressInstalled"
Compare="ValueEqualTo" Value="0"/>
<BypassIf Property="Installsqlserver" Compare="ValueEqualTo"
Value="False"/>
<BypassIf Property="VersionNT"
Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>
<FailIf Property="AdminUser" Compare="ValueEqualTo"
Value="false" String="AdminRequired"/>
<FailIf Property="Version9x" Compare="ValueExists"
String="InvalidPlatform"/>
<FailIf Property="VersionNT" Compare="VersionLessThan"
Value="5.0.4" String="InvalidPlatform2K"/>
<FailIf Property="ProcessorArchitecture"
Compare="ValueNotEqualTo" Value="Intel"
String="InvalidPlatformArchitecture"/>
</InstallConditions>
<ExitCodes>
<ExitCode Value="0" Result="Success"/>
<ExitCode Value="1641" Result="SuccessReboot"/>
<ExitCode Value="3010" Result="SuccessReboot"/>
<ExitCode Value="50037" Result="Fail"
String="MissingMSXml"/>
<ExitCode Value="50251" Result="Fail"
String="MissingMSXml"/>
<ExitCode Value="50198" Result="Fail"
String="InsufficientHardware"/>
<ExitCode Value="50236" Result="Fail"
String="InsufficientHardware"/>
<ExitCode Value="50222" Result="Fail"
String="InvalidPlatformOSServicePacks"/>
<ExitCode Value="70003" Result="Fail"
String="InvalidPlatformOSServicePacks"/>
<ExitCode Value="50247" Result="Fail"
String="InvalidPaltformIE"/>
<ExitCode Value="50248" Result="Fail"
String="InvalidPaltformIE"/>
<ExitCode Value="70004" Result="Fail"
String="AnotherInstanceRunning"/>
<ExitCode Value="70032" Result="Fail"
String="BetaComponentsFailure"/>
<ExitCode Value="70033" Result="Fail"
String="InvalidPlatformArchitecture"/>
<DefaultExitCode Result="Fail"
FormatMessageFromSystem="true" String="GeneralFailure" />
</ExitCodes>
</Command>
<Command PackageFile="sqlexpr32.exe"
Arguments='-q /norebootchk /qn reboot=ReallySuppress
ADDLOCAL=ALL SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 INSTANCENAME=OsmontTech
SECURITYMODE=SQL SAPWD=nissan DISABLENETWORKPROTOCOLS=0'
EstimatedInstalledBytes="225000000"
EstimatedInstallSeconds="420">
<InstallConditions>
<BypassIf Property="SQLExpressInstalled"
Compare="ValueEqualTo" Value="0"/>
<BypassIf Property="Installsqlserver" Compare="ValueEqualTo"
Value="False"/>
<BypassIf Property="VersionNT" Compare="VersionLessThan"
Value="5.1"/>
<FailIf Property="AdminUser" Compare="ValueEqualTo"
Value="false" String="AdminRequired"/>
<FailIf Property="Version9x" Compare="ValueExists"
String="InvalidPlatformXP"/>
<FailIf Property="VersionNT" Compare="VersionLessThan"
Value="5.1.2" String="InvalidPlatformXP"/>
<FailIf Property="ProcessorArchitecture"
Compare="ValueNotEqualTo" Value="Intel"
String="InvalidPlatformArchitecture"/>
</InstallConditions>
<ExitCodes>
<ExitCode Value="0" Result="Success"/>
<ExitCode Value="1641" Result="SuccessReboot"/>
<ExitCode Value="3010" Result="SuccessReboot"/>
<ExitCode Value="50037" Result="Fail"
String="MissingMSXml"/>
<ExitCode Value="50251" Result="Fail"
String="MissingMSXml"/>
<ExitCode Value="50198" Result="Fail"
String="InsufficientHardware"/>
<ExitCode Value="50236" Result="Fail"
String="InsufficientHardware"/>
<ExitCode Value="50222" Result="Fail"
String="InvalidPlatformOSServicePacks"/>
<ExitCode Value="70003" Result="Fail"
String="InvalidPlatformOSServicePacks"/>
<ExitCode Value="50247" Result="Fail"
String="InvalidPaltformIE"/>
<ExitCode Value="50248" Result="Fail"
String="InvalidPaltformIE"/>
<ExitCode Value="70004" Result="Fail"
String="AnotherInstanceRunning"/>
<ExitCode Value="70032" Result="Fail"
String="BetaComponentsFailure"/>
<ExitCode Value="70033" Result="Fail"
String="InvalidPlatformArchitecture"/>
<DefaultExitCode Result="Fail"
FormatMessageFromSystem="true" String="GeneralFailure" />
</ExitCodes>
</Command>
</Commands>

<Strings>
<String Name="DisplayName">SQL Server 2005 Express Edition
SP2</String>
<String Name="Culture">en</String>
<String Name="AdminRequired">You do not have the permissions
required to install SQL Server 2005 Express Edition. Please contact your
administrator.</String>
<String Name="GeneralFailure">An error occurred attempting to
install SQL Server 2005 Express Edition.</String>
<String Name="InvalidPlatform">Windows 2000 or later is required to
install SQL Server 2005 Express Edition.</String>
<String Name="InvalidPlatform2K">Windows 2000 Service Pack 4 or
later is required to install SQL Server 2005 Express Edition.</String>
<String Name="InvalidPlatformXP">Windows XP Service Pack 2 or later
is required to install SQL Server 2005 Express Edition.</String>
<String Name="MissingMSXml">SQL Server 2005 Express Edition requires
MSXML. Please ensure MSXML is installed properly.</String>
<String Name="InsufficientHardward">The current system does not meet
the minimum hardware requirements for SQL Server 2005 Express Edition.
Contact your application vendor.</String>
<String Name="InvalidPlatformOSServicePacks">The current operating
system does not meet Service Pack level requirements for SQL Server 2005
Express Edition. Install the most recent Service Pack from the Microsoft
download center at http://www.microsoft.com/downloads before continuing
setup.</String>
<String Name="InvalidPaltformIE">This version of SQL Server 2005
Express Edition requires Internet Explorer version 6.0 with SP1 or later. To
proceed, install or upgrade to a required version of Internet Explorer and
then run setup again.</String>
<String Name="AnotherInstanceRunning">Another instance of setup is
already running. The running instance must complete before this setup can
proceed.</String>
<String Name="BetaComponentsFailure">A beta version of the .NET
Framework 2.0 or SQL Server was detected on the computer. Uninstall any
previous beta versions of SQL Server Yukon components, SQL Server Support
Files, or .NET Framework 2.0 before continuing.</String>
<String Name="InvalidPlatformArchitecture">This version of SQL
Server 2005 Express Edition is not supported for the current processor
architecture.</String>
<String Name="ErrorDiskFull">There is not enough space on the
destination disk for SQL Server 2005 Express Edition.</String>
<String Name="MissingNDP">The required version of the .NET Framework
is not installed. Contact your application vendor.</String>
<String
Name="SqlExpr32Exe">http://go.microsoft.com/fwlink/?LinkId=65212&amp;clcid=0x409</String>
</Strings>
</Package>

 

[Steven Cheng[MSFT]]

Hi Steve,

How are you doing recently?

As for the SQL Express SP2 release, so far the SQL team does be working on
create a new bootstrapper package for it(also mentioned in the following
weblog article):

#SQL Server 2005 SP2 has been released
http://blogs.msdn.com/sqlexpress/archive/2007/02/20/sql-server-2005-sp2-has-
been-released.aspx

Currently, I've found that some community member has also created a custom
bootsrapper solution for the SP2 release, here is a web article you can
have a look:

#Bootstrapper for SQL Server 2005 Express Edition Service Pack 2
http://blogs.rbaconsulting.com/agrocholski/PermaLink,guid,d5b577b9-120f-43f7
-b0f3-2adc80f393f5.aspx

Also, I'll help you ask some other engineers to see whether the official
bootstrapper package will come soon.

Hope this helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Steve]

Hi Steven

I have been well, hope all is well with you

Thanks for the prompt reply as usual

I have already tried the bootstrapper from rbaconsulting and it gives me the
error message mentioned

I guess I will have to wait till MS releases the official one

Regards
Steve

 

[Steven Cheng[MSFT]]

Thanks for your reply Steve,

I have forwarded this request to internal database discussion group. Also,
I would suggest you try posting in the SQLExpress MSDN weblog so that the
SQL Express team guys can hear more on this:

http://blogs.msdn.com/sqlexpress/archive/2007/02/20/sql-server-2005-sp2-has-
been-released.aspx

Anyway, if you have any further questions or anything else we can help,
please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.