472,989 Members | 3,089 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,989 software developers and data experts.

Sql server express SP2 Bootstrapper package

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>
Apr 6 '07 #1
3 6367
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/arc...-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/agroc...77b9-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.


Apr 6 '07 #2
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]" <st*****@online.microsoft.comwrote in message
news:Uh**************@TK2MSFTNGHUB02.phx.gbl...
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/arc...-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/agroc...77b9-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.




Apr 6 '07 #3
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/arc...-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.

Apr 10 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: NetIdiot | last post by:
I have had to install and uninstall VS.NET 2005 a couple of times because of some errors. The SQL Server express refuses to install ... and hence I can't most things I want to work on. I even tried...
5
by: Chris Devol | last post by:
My dial-up connection sometimes hangs up and has to re-connect. The VB2005 installer/downloader apparently doesn't know how to resume when the connection is re-established. It just aborts! I've...
4
by: Andrew | last post by:
hi, i'm searching for a bootstrapper that check if .net framework is installed on a machine and after the install launch my vb.net app ... i dont want to installa the app on the pc but i want to...
3
by: ljh | last post by:
(sorry if this posts twice....I waited several hours and didn;t see it - so here it is again.....) Perhaps I am somewhat dense.....but, I still need to know..... What do you need to do in...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
6
by: antonyliu2002 | last post by:
I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server Express. I can define table with no problem. ...
1
by: sebastien1101 | last post by:
I have to produce a new application using now Visual Studio 2005 & Sql server 2005 express Before with VS2003 i use the msde Boostraper to deploy my database.... What i have to do with sql...
10
by: =?Utf-8?B?UHVuaXQgS2F1cg==?= | last post by:
Hi, I am developing a windows application in VS.NET 2005. The application is database driven and I need to deploy it on a client's pc. How should I go about developing such an application. I...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.