SQL Server 2005 Express support in SB6.5

[NewsArchive]

Hi Freidrich,

I have a whole bunch of questions about SQL 2005 Express support as I am
looking into integrating it into my installer. Sorry about this... If it
will be too much hassle we may dump SQL 2005 Express in favour of something
less complex to pre-install and configure like Firebird, so for now anything
unsupported is not yet a feature request!

Are there any plans to update the redist file to SP2?

Are there any plans to offer support for SQL 2005 Management Studio Express,
or 2005 Express Edition with Advanced Services?

To integrate this, I gather I need to tick the relevant core prerequisites
under the Setup Requirements page in SB6.5 (e.g. Windows Installer 3.1, Dot
Net 2.0, SQL Express 2005. Is there anything else I need to do? I have
already downloaded the redists that I need

Can I control the order the prerequisites will install, so on a well out of
date system with none of them installed, Windows Installer will go in first,
then Dot Net 2.0, then SQL 2005 Express? I assume any other order would stop
them from installing properly according to the Microsoft release notes

What if a reboot is necessary between installing different prerequisites?

Am I right in assuming the prerequisite downloads will be compiled into my
final setup.exe so it will bloat a fair bit?

Is there any way for me to control which prerequisites are installed or
supply command line parameters to them or something based on the choice of
setup type chosen by the user, so I can install SQL Express on a 'server'
install but not on a 'client' install? Or maybe install just the client
tools component of SQL Express on a 'client' install?

And the final question: to get networking working on SQL 2005 Express I will
need to open a port in the Windows firewall. Do you have any plans for an
automated way to do this?

Regards,

__________________________________
Jeff Botwood
Product Development Manager
Data Design Services Ltd

Web: http://www.accuramis.com

[NewsArchive]

By default SQL 2005 Express does not allow for remote connections. You will
have to run the configuration manager to change the default settings in
order for the server to accept connections from outside of the local
machine, which will also require you to modify the firewall port settings
for whichever firewall may be in use.

--

Ben E. Brady
Want MASSIVELY OUTRAGEOUS web disk space and bandwidth?
300 GB disk space and 3000 GB transfer per month,
http://www.servage.net/?coupon=CUST13495

www.clariondeveloper.com
www.singularvisionsoftware.com

The information contained in the message above, as expressed by the author,
is copyright 2006 by Ben E. Brady, All rights strictly reserved worldwide.
The information contained in the message above may not be posted on any
other information forum or web site without the express written permission
of the author. All opinions expressed in the message are those of the author
and are not necessarily shared by other members of the newsgroup and may or
may not be in agreement with SoftVelocity, the host of this newsgroup.

[NewsArchive]

I am hoping I can use command line parameters to install it like this in the
first place, or perhaps run a script after install to set it...

Jeff Botwood

[NewsArchive]

Yes, you can add it to the command line as a switch.
I have myself updated the SQLExpress to SP2 within my Setupbuilder redist folder, so
you can download latter one direct fom MS and use that as your engine installer.

John Griffiths

[NewsArchive]

Hi Jeff,

> I have a whole bunch of questions about SQL 2005 Express support as I am
> looking into integrating it into my installer. Sorry about this... If it
> will be too much hassle we may dump SQL 2005 Express in favour of
> something less complex to pre-install and configure like Firebird, so for
> now anything unsupported is not yet a feature request!
>
> Are there any plans to update the redist file to SP2?

Yes, we have plans do upgrade the redistributables to SP2.

> Are there any plans to offer support for SQL 2005 Management Studio
> Express, or 2005 Express Edition with Advanced Services?

Because this is a hefty 234 MB, no. But we have plans to provide an include
script without the redistributable.

> To integrate this, I gather I need to tick the relevant core prerequisites
> under the Setup Requirements page in SB6.5 (e.g. Windows Installer 3.1,
> Dot Net 2.0, SQL Express 2005. Is there anything else I need to do? I have
> already downloaded the redists that I need

Yes, you can tick the relevant core prerequisites.

> Can I control the order the prerequisites will install, so on a well out
> of date system with none of them installed, Windows Installer will go in
> first, then Dot Net 2.0, then SQL 2005 Express? I assume any other order
> would stop them from installing properly according to the Microsoft
> release
> notes

Yes, in the script editor. Just move the include script up/down.

>
> What if a reboot is necessary between installing different prerequisites?
>

The include scripts support the "resume and continue" feature.

> Am I right in assuming the prerequisite downloads will be compiled into my
> final setup.exe so it will bloat a fair bit?

Yes.

> Is there any way for me to control which prerequisites are installed or
> supply command line parameters to them or something based on the choice of
> setup type chosen by the user, so I can install SQL Express on a 'server'
> install but not on a 'client' install? Or maybe install just the client
> tools component of SQL Express on a 'client' install?

Yes (from the Script Editor).

> And the final question: to get networking working on SQL 2005 Express I
> will need to open a port in the Windows firewall. Do you have any plans
> for an automated way to do this?

I think (not 100% sure) that Vista and Windows Server 2008 do not support
this any longer. I have to check this again but for now the answer is there
are no plans. If you know how to do this just let me know and I'll see
what we can do.

Does this help?

Friedrich

Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

"point. click. ship" - that's SetupBuilder 6
Create Windows Vista ready installations in minutes

-- Official Comodo Code Signing and SSL Certificate Partner

[NewsArchive]

Hi Jeff,

BTW, the "standard" Core PreRequisites are there to quickly deploy various
3rd party runtimes. SetupBuilder makes use of the original Microsoft
redistributables.

If you need more control, you can modify the include scripts and/or add your
own solutions. For example, you don't want the extra overhead? No problem.
Let SetupBuilder detect which Core PreRequisites are missing and (if
required) download and install them from your web site.

Friedrich

--
Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

"point. click. ship" - that's SetupBuilder 6
Create Windows Vista ready installations in minutes

-- Official Comodo Code Signing and SSL Certificate Partner

[NewsArchive]

Hi Friedrich

> For example, you don't want the extra overhead? No problem. Let
> SetupBuilder detect which Core PreRequisites are missing and (if required)
> download and install them from your web site.

How is this done in SB6.5?

Regards
Paul Walker

[NewsArchive]

Hi Paul,

There is no general answer to this gestion. It depends on the Core
PreRequisites.

As an example, let us assume the software requires the .NET Framework 2.
You don't ship this with your installation package, but offer a download
from your web site. Then you only need:

Set Variable %DOTNET% to FUNCTION:Get System Information(.NET Status) of
"$NET_FRAMEWORK_20$"

! If .NET Framework Version 2.0 is not installed
If %DOTNET% Not Equals "1" Then
! Download and Install .NET 2 here
End

You can do this with all runtimes, with your own software components, etc.

Friedrich

--
Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

"point. click. ship" - that's SetupBuilder 6
Create Windows Vista ready installations in minutes

-- Official Comodo Code Signing and SSL Certificate Partner

[NewsArchive]

Aha now I found the include scripts for these I have a much better idea of
how everything is working. Looks like you've already covered everything I
could think of (of course)...

The firewall thing is only a minor issue. I'm sure I can do the XP firewall
by editing the registry. Haven't even started to look at proper Vista stuff
yet (we are a little behind in that area)...

Cheers,

Jeff

[NewsArchive]

The Windows firewall will be the least of your worries... nobody really uses
it. If they are running a software based firewall they will be using
something a bit more robust and may even be locked down by a network domain
administrator. Hardware based firewalls will also be an issue, particularly
if your software is going to be used in an environment where you have the
potential for remote user access.

--

Ben E. Brady
Want MASSIVELY OUTRAGEOUS web disk space and bandwidth?
300 GB disk space and 3000 GB transfer per month,
http://www.servage.net/?coupon=CUST13495

www.clariondeveloper.com
www.singularvisionsoftware.com

The information contained in the message above, as expressed by the author,
is copyright 2006 by Ben E. Brady, All rights strictly reserved worldwide.
The information contained in the message above may not be posted on any
other information forum or web site without the express written permission
of the author. All opinions expressed in the message are those of the author
and are not necessarily shared by other members of the newsgroup and may or
may not be in agreement with SoftVelocity, the host of this newsgroup.