SQL 2014 redistributable

[NewsArchive]

Hi Friedrich,

I'm looking at bundling sql2014 express into an install however my
reading has come across a statement from Microsoft support:

"SQL Server 2014 itself does not have redistributables. But you can use
SQL Server 2014 Express as a redistributable to install on your
machine. Since you can't select SQL Server Express 2014 from
Prerequisites dialog, I suggest you install SQL Server 2014 Express
editions manually on target machines."

So is the approach to do a silent install from the setupbuilder install
and might there be an example???

regards,
Mike

[NewsArchive]

Hi Mike,

> So is the approach to do a silent install from the setupbuilder
> install

We are using the SQL Server 2014 Express redistributable from the
SetupBuilder installer without any problem in some Consulting projects. We
have developed a redistributable package for the clients and SQL 2014 is
deployed in silent mode.

Friedrich

[NewsArchive]

Friedrich,

> We are using the SQL Server 2014 Express redistributable from the
> SetupBuilder installer

Mine has 2005 and 2008(32/64) listed in Core PreRequisites. What's
necessary to get 2014 listed?

--
Lee White

RPM Report Viewer.: http://www.cwaddons.com/products/rpm/
RPM Review........: http://www.clarionmag.com/cmag/v11/v11n06rpm.html
Report Faxing.....: http://www.cwaddons.com/products/afe/
---Enroll Today---: http://CWaddons.com

Creative Reporting: http://www.CreativeReporting.com

Product Release & Update Notices
http://twitter.com/DeveloperPLUS

Windows 8 brings us "The Oval, Bumper Car, Roller Coaster of Wait!"

[NewsArchive]

Lee,

>> We are using the SQL Server 2014 Express redistributable from the
>> SetupBuilder installer
>
> Mine has 2005 and 2008(32/64) listed in Core PreRequisites. What's
> necessary to get 2014 listed?

All the new SQL Server Express redistributables are hefty downloads (from
~150MB to 1GB; depends on the required runtimes) and are typically very
complex to deploy. And for the new SQL Server Express 2014 you even have to
register to receive the download links (some weeks later M$ decided to also
make a download link available to the public).

http://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx

As a result, we can't make SQL Server Express 201x runtime redistributables
available as free Core PreRequisites :-(

Friedrich

[NewsArchive]

Friedrich,

> As a result, we can't make SQL Server Express 201x runtime redistributables
> available as free Core PreRequisites :-(

I still can't grasp the ridiculous nature of their reasoning, if you
can actually call it reasoning... which I do not!

--
Lee White

RPM Report Viewer.: http://www.cwaddons.com/products/rpm/
RPM Review........: http://www.clarionmag.com/cmag/v11/v11n06rpm.html
Report Faxing.....: http://www.cwaddons.com/products/afe/
---Enroll Today---: http://CWaddons.com

Creative Reporting: http://www.CreativeReporting.com

Product Release & Update Notices
http://twitter.com/DeveloperPLUS

Windows 8 brings us "The Oval, Bumper Car, Roller Coaster of Wait!"

[NewsArchive]

Lee,

Four weeks ago, we had to develop the deployment logic for a simple SQL
Server Express 2014 system. In the past, it was so easy to deploy and the
installation process was fast. But with 2014, it took three full days to
write the installation logic. The MS redistributables add a hefty 300MB to
the setup.exe. One installation test took up to 30 minutes (per OS; we had
to test it on Windows 7 SP1, Windows 8.0 and Windows 8.1). This was a
nightmare.

Friedrich

[NewsArchive]

Friedrich,

> Four weeks ago, we had to develop the deployment logic for a simple SQL
> Server Express 2014 system. In the past, it was so easy to deploy and the
> installation process was fast. But with 2014, it took three full days to
> write the installation logic. The MS redistributables add a hefty 300MB to
> the setup.exe. One installation test took up to 30 minutes (per OS; we had
> to test it on Windows 7 SP1, Windows 8.0 and Windows 8.1). This was a
> nightmare.

Better living through modern computing?!<g>

--
Lee White

RPM Report Viewer.: http://www.cwaddons.com/products/rpm/
RPM Review........: http://www.clarionmag.com/cmag/v11/v11n06rpm.html
Report Faxing.....: http://www.cwaddons.com/products/afe/
---Enroll Today---: http://CWaddons.com

Creative Reporting: http://www.CreativeReporting.com

Product Release & Update Notices
http://twitter.com/DeveloperPLUS

Windows 8 brings us "The Oval, Bumper Car, Roller Coaster of Wait!"

[NewsArchive]

Lee,

>
> Better living through modern computing?!<g>
>

LOL! I HATE COMPUTERS!

Friedrich

[NewsArchive]

Hi Friedrich,

I think I might go back to 2008 for this as I'm confused enough with it.

What I'm trying to do is:

An install that loads our application and SQL db. This will run for 30
days and then cease.
The user will then elect to purchase which then requires us to install
all of the system remotely. This is because the paid system requires a
multitude of tweaks and connections to operate and this is dependant on
the clients configurations, users, servers and the type of service they
require.

What I'm looking at (I think) is a simple install as a demo program.
1. install sql (I think just the engine??)
2. create a specific user
3. create a specific db for the user.
4. populate the database with data or attach a pre prepared db.

I'm missing the following from the core prerequisites in SB
.Net framework 3.5 SP1
Windows installer 4.5
and I was wondering if there is a SQL 2008 R2 SP2 Express redistributable?

I'm using the rt_sql2008expr_x86.sbi and rt_sql2008expr_x64.sbi sent to
me earlier and have used that with our app installation.

I have the application install working fine - I'm really having issues
with the SQL bit. It's been either no install at all or totally
overwrite any other installation on the pc.

Any advice greatly appreciated.

regards,
Mike

[NewsArchive]

Wait until they get to computerizing internal medicine. That will be a
real pain the ass!

--

Russ Eggen
RADFusion International, LLC

[NewsArchive]

Friedrich Linder,

> LOL! I HATE COMPUTERS!
> ... free from viruses and malware because avast! Antivirus protection is active.

Is it? Still active that is?!<g>

--
Lee White

RPM Report Viewer.: http://www.cwaddons.com/products/rpm/
RPM Review........: http://www.clarionmag.com/cmag/v11/v11n06rpm.html
Report Faxing.....: http://www.cwaddons.com/products/afe/
---Enroll Today---: http://CWaddons.com

Creative Reporting: http://www.CreativeReporting.com

Product Release & Update Notices
http://twitter.com/DeveloperPLUS

Windows 8 brings us "The Oval, Bumper Car, Roller Coaster of Wait!"

[NewsArchive]

Lee,

>> LOL! I HATE COMPUTERS!
>> ... free from viruses and malware because avast! Antivirus protection is
>> active.
>
> Is it? Still active that is?!<g>

Oh boy, what a nightmare <g>.

I have avast auto-update disabled (and only receive virus definitions)
because all the new avast versions slowed down my system to the point that I
could barely get any work done. Yesterday, avast decided to update my
computer without my permission. Suddenly, my machine slowed down,
downloaded 100+ MB, installed something completely behind the scenes and
displayed a reboot message. Hmmmm. New avast installed? WTF? Thank you,
avast! This is ridiculous.

After that, this stupid new avast "protection system" moved tons of emails
into my Spam folder (support requests, orders, etc.). Who authorized the
avast guys to update my system, do a reboot and move emails into my Spam
folder? Avast, do you know a place where the Sun never shines???

"This program is not responding" messages over and over again, more than
five system crashes today, machine as fast as my good old 80286. avast, are
you serious???

Next step: uninstall avast and bye... I'll see you in Hell.

Friedrich

[NewsArchive]

Michael,

I'll answer ASAP. Have to "rollback" my system <g>

Friedrich

[NewsArchive]

Thanks Friedrich,

I thought I had these but they have gone.
cheers,
Mike

[NewsArchive]

Hi Michael,

> I'm missing the following from the core prerequisites in SB

There are more than 10,000+ different runtimes and redistributables
available for Windows. All require a very specific deployment logic if you
would like to redistribute them with your application. As a starting point,
SB comes with some original redistributables and a pre-built deployment
logic (.sbi include scrips) in form of Core PreRequisites.

> .Net framework 3.5 SP1
> Windows installer 4.5
> and I was wondering if there is a SQL 2008 R2 SP2 Express redistributable?

Because .NET Framework 3.5 is a hefty 240 MB redistributable, it is not
available as a Core PreRequisite in SB.

http://www.lindersoft.com/forums/showthread.php?p=62193#post62193

This is the download link if you would like to deploy it along with your
application:

http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe

But of course, you have to develop your own deployment logic for it (e.g.
detect an already installed version, make sure the target operating system
is supported, check if all dependency components are available, etc.). Not
a trivial task. You really have to know what you are doing and you have to
read the redist documentation very carefully (supported OS and
requirements)!

The Windows installer 4.5 redistributables are available here:

http://www.microsoft.com/en-us/download/details.aspx?id=8483

Same story. Not easy to handle.

The SQL 2008 R2 SP2 Express redistributables are available here:

http://www.microsoft.com/en-us/download/details.aspx?id=30438

It depends on the required redistributable, but the overhead might be 1 GB
and more.

BTW, this week our Consulting successfully finished a project for a SQL 2012
Express project. Customer decided to use the "small" (133 MB) redist and
the installer automatically installs SQL Express 2012 and the application
files, configures the SQL Server settings (including stopping and restarting
SQL services), creates the databases, runs SQL scripts, etc. It took more
than two weeks to plan and develop the deployment scenario.

Distributing a redistributable is really the smallest problem today :-( The
deployment logic which handles all the processes automatically and
completely behind the scenes is what makes a project work.

Friedrich

[NewsArchive]

BTW, a demo deployment logic for .NET Framework 3.5 is available. Use it at
your own risk <g>

To redistribute .NET 3.5, you have to download the original .NET 3.5
redistributable from the MS site and use the following .NET 3.5 include
script (unofficial and not supported by Lindersoft):

http://www.lindersoft.com/projects/rt_dotnetframework35.zip

1. Download runtime from (redirection): http://www.lindersoft.com/NET35.htm

2. Add "rt_dotnetframework35.sbi" to your project

3. Define the location of the downloaded MS redistributable (dotnetfx35.exe)

4. Compile and run :-)

Friedrich

[NewsArchive]

Thanks Friedrich,

I understand the difficulties you've pointed out and have already done a
lot of the logic for it. Unfortunately I have a client who believes
that they need a "Demo" which will install to any box.

They don't care about the technical problems or seemingly about the size
of the install file (They want this to be a download!). I've told them
it would be a very big package and they are actually happy about that
although their prospective clients certainly won't be.

Thanks for the links and advice, I'm hoping to finish this off today
and move on to other projects.

regards,
Michael