This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Pre Sales - VB.net/SQL Server 2008 Express
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 21, 2009
09:23 AM
Pre Sales - VB.net/SQL Server 2008 Express
Hi,
We have a vb.net application that uses SQL Server 2008 Express. We would like to create an installation package that will install on both XP & Vista platforms, and for people who do not already have SQL Server 2008 Express.
Is this possible using InstallShield, and if so, is it easy?
Also, how large will the final installation file be, as I suspect we would need to inlcude the .net frameworks as well of course SQL Server 2008 Express?
I look forward to your responses.
Many thanks,
We have a vb.net application that uses SQL Server 2008 Express. We would like to create an installation package that will install on both XP & Vista platforms, and for people who do not already have SQL Server 2008 Express.
Is this possible using InstallShield, and if so, is it easy?
Also, how large will the final installation file be, as I suspect we would need to inlcude the .net frameworks as well of course SQL Server 2008 Express?
I look forward to your responses.
Many thanks,
(25) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 22, 2009
11:33 AM
You simply need to add the Microsoft SQL Server 2008 Express setup prerequisite to your project by selecting the checkbox in the Redistributables view. Microsoft SQL Server 2008 Express requires the Microsoft .Net Framework 3.5 SP1 and Windows Installer 4.5. You may also want to include those prerequisites in your project.
InstallShield provides the Download From The Web option for the setup prerequisites. If you choose this option, only several K bytes of the text files will be included in your setup, and the actual redistributables will be downloaded at run-time. Please refer to the Setup Prerequisites help topic for more information.
InstallShield provides the Download From The Web option for the setup prerequisites. If you choose this option, only several K bytes of the text files will be included in your setup, and the actual redistributables will be downloaded at run-time. Please refer to the Setup Prerequisites help topic for more information.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 22, 2009
12:18 PM
Brilliant, I will try that, thanks!
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 22, 2009
02:12 PM
Ok, I have selected SQL Server 2008 Express but I can not find anywhere where you create the SQL instance (database name & password).
Can anyone quickly advise where I edit this?
Thanks,
Can anyone quickly advise where I edit this?
Thanks,
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 22, 2009
02:52 PM
Since InstallShield Express edition does not provide the Setup Prerequisite Editor, you need to modify the .prq file using a text editor. You will need to add the "cmdline" attribute to the "execute" node in order to specify the command line options of SQLEXPR32.EXE.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 23, 2009
04:14 AM
I must be going mad but where do I find the .prq file?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 23, 2009
09:21 AM
The .prq files are located under the C:\Program Files\InstallShield\2009 Express\SetupPrerequisites folder.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 23, 2009
11:22 AM
Great, found it, so what line do I enter to create an instance called 'SQLDB'
Thanks,
Thanks,
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 23, 2009
11:44 AM
You need to update the "execute" node as follows:
Please refer to the How to: Install SQL Server 2008 from the Command Prompt help topic for more information about the command line options of Microsoft SQL Server 2008 setup.
cmdline="/INSTANCENAME=SQLDB" requiresmsiengine="1">
Please refer to the How to: Install SQL Server 2008 from the Command Prompt help topic for more information about the command line options of Microsoft SQL Server 2008 setup.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 23, 2009
01:40 PM
Thanks for that, our installation was looking successful until we got the error "Installation requires .net 2.0 SP2"
In our redistributables we are using .net 3.5, I thought .net 2.0 was all included in with 3.5, is it not?
Thanks,
In our redistributables we are using .net 3.5, I thought .net 2.0 was all included in with 3.5, is it not?
Thanks,
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 23, 2009
09:35 PM
We are looking into it. I will post the information as soon as we figure it out.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 26, 2009
10:57 AM
Do you know how long this will take, its just my trial version is coming to an end?
Thanks,
Thanks,
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 28, 2009
04:01 AM
I'm afraid that did not work.
After copying that file over as instructed, I was able to select .net 2.0 SP2.
However, when running the installation file, it did not install, there was no error, it just did not appear on the list of pre-installs at the beginning of the installation and simply atempted to install .net 3.5 again. Chjecking the Control Panel/Programmes & Features, there was no .net 2.0 uinstalled.
Also, I attempted to manually install .net 2.0 SP2 but I then got the error saying that I needed .Net 2.0 SP1.
This .net 3.5 installation is becomming a real issue here, is there no .net package that will install all the required componants for .net 3.5?
Just to summerise, we need to distribute SQL Server 2008 Express with the necessary .net componants for it to work on non-vista and vista pc's.
Thanks,
After copying that file over as instructed, I was able to select .net 2.0 SP2.
However, when running the installation file, it did not install, there was no error, it just did not appear on the list of pre-installs at the beginning of the installation and simply atempted to install .net 3.5 again. Chjecking the Control Panel/Programmes & Features, there was no .net 2.0 uinstalled.
Also, I attempted to manually install .net 2.0 SP2 but I then got the error saying that I needed .Net 2.0 SP1.
This .net 3.5 installation is becomming a real issue here, is there no .net package that will install all the required componants for .net 3.5?
Just to summerise, we need to distribute SQL Server 2008 Express with the necessary .net componants for it to work on non-vista and vista pc's.
Thanks,
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 28, 2009
03:27 PM
Looks like that is working, and its helped to almost install SQL Server 2008 Express, nearly there!
Just when its almost complete installation, the SQL Installation Centre appears. I presume this is something to do with the .prq file.
I am using the following:
I just need to install the SQL Engine, automatically, how do I do that?
I have read http://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature but I can't seem to get this working
Thanks,
Just when its almost complete installation, the SQL Installation Centre appears. I presume this is something to do with the .prq file.
I am using the following:
I just need to install the SQL Engine, automatically, how do I do that?
I have read http://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature but I can't seem to get this working
Thanks,
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 30, 2009
12:51 PM
..could anyone help with this as this is the only thing that is preventing a complete and successful installation?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 30, 2009
12:56 PM
Did you try the /Q switch?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 30, 2009
01:23 PM
I just tried:
but it then said "The installation of SQL Server 2008 appears to have failed, etc?
but it then said "The installation of SQL Server 2008 appears to have failed, etc?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 30, 2009
01:29 PM
You may need to update the prerequisite condition for your custom instance as follows:
SQLDB\MSSQLServer\CurrentVersion"..... >
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 30, 2009
01:40 PM
No, that didn't work either.
Please see below for a copy of my .prq file for SQL Server 2008 Express, what have I done wrong?
Please see below for a copy of my .prq file for SQL Server 2008 Express, what have I done wrong?
![](/skins/images/3B39CE851FDD5528C393F146EB70A2D0/responsive_peak/images/icon_anonymous_message.png)