Where is .NET 2.0 and SQL 2005?

[Vaslin]

I just started using the trial version of 11.5 and I'm looking in the redistributables for .NET 2.0 Framework and the SQL 2005 install.

2.0: http://www.macrovision.com/products/flexnet_installshield/installshield/features/dotNET_2dot0_Framework_Support.html
SQL: http://www.macrovision.com/products/flexnet_installshield/installshield/features/Microsoft_SQL_Server_2005_Support.html

Where do I find these options?

Thanks!

[MichaelU]

The .NET installation support is selected in the Release Wizard (or Release Grid), and if you need any of the redistributables for it you can download them with the Redistributable Downloader from the Tools menu.

I don't believe we have a redistributable for installing Microsoft's SQL Server 2005 - that's a paid product right? The support for creating and updating databases at install is with the rest of the SQL support under the Installation Designer tab, Servers node.

[Vaslin]

Thanks for your response.

The Microsoft's SQL Server Express 2005 is not a paid product and I should have been clearer on that.

The feature that I'm looking for is on the second link that I sent.


Version 2005 of the SQL Distributed Management Objects (SQL-DMO) is included with FLEXnet InstallShield; this enables you to connect to SQL Server 2005 through the Database Import Wizard in FLEXnet InstallShield even if you do not have SQL Server 2005 installed on your machine. In addition, the Database Import Wizard includes support for the new XML data type introduced in Microsoft SQL Server 2005.

[Qingsong]

Hi, Michael,

There is no .NET 2.0 framework redistributable in the list of the Redistributable Downloader from the Tools menu.

There is no SQL Express 2005 pre-requisite, which should be the same as SQL 2000 MSDE, either.

".NET 2.0 support" only shows in the Release Wizard, but you have to choose "Download from internet" option.

I do not see any new featuers available for SQL 2005.

I am getting error message which installing a .NET NT Service, using native InstallUtil.exe support from IS IDE. I can run "InstallUtil.exe myservice.exe" from command line successfully, but failed with the NT service components.

I have not see what I am looking for yet with this new release.

Qingsong

[hidenori]

The SQL Server 2005 Express redistributable is not included in InstallShield 11.5. In this release, the SQL Server 2005 support has been added to the Database Import Wizard and SQL Scripts view.

[Chandima]

There is no .NET 2.0 framework redistributable in the list of the Redistributable Downloader from the Tools menu.
Please try again. I was able to successfully download the redistributable through the Redist Downloader. See attached.

[Qingsong]

Hi,

I checked today. It is available now. Thanks.

What's the plan for SQL Express 2005 pre-requisite support? Can we just create one by ourself? I tried mine and it is working well. But I prefer using the InstallShield official one.

Best regards,

Qingsong

[Chandima]

We haven't planned for a SQL Express 2005 Pre-requisite or Merge Module. I created Issue #IOC-000043863 to track this as a Feature Request. I doubt we will get to it before our next release though :(.

For now, using your own pre-requisite should be fine. Since pre-requisites work outside of Windows Installer they are much more reliable and cleaner. For best results, test your pre-requisite (runtime) on all platforms. This is easy if you have VMWare or Virtual PC. If not, at least try running it on one 9X platform (I would try 98) and on a XP and 2K. Good Luck!

[Stefan Krueger]

Hello Qingsong,

if you have a working (ideally fully tested) prerequisite for SQL Express 2005 and you are willing to share it with the community, I'd be glad to post it on InstallSite.org. Please mail me at skrueger(at)installsite(dot)org

[michaelk]

Please do, as I would find this very useful.

Mike.

[Stefan Krueger]

It's available now at http://www.installsite.org/pages/en/msi/isd.htm#PrqSQL2005Exp. Thanks to Qingsong Zhang!

[nitsev]

This is the answer I got when asking where support for installing SQL Server 2005 Express and a prerequisite for the same:

"I have discussed this issue with one of our Senior Engineer, who confirmed that this is not an InstallShield Issue, as we don’t provide any redistributable for SQL Server Express 2000. I would suggest you to contact the product vendor for the same."

Funny that they provide install objects for MSDE don't you think? ALL redistributables are non-installshield products so that makes it "not an InstallShield issue". These guys are funny.

[mikenac]

Well, the MSDE object wasn't very useful anyhow. I still had to make my own.....

[Chocsa]

Thanks guys esp Qingsong,
very helpful however I did find the problem regarding useage of it. i.e. we have a virgin machine and when sql server 2005 installs, it requires Win 3.1 installer and .Net 2.0 framework to be installed prior to installing setup.
We created a pre req for Win 3.1, which worked except that after reboot you could not see the next pre req? Anyone know why this is? Also, How did you get around the .Net 2.0 requirement. Thinking about trying Sql Server 2005 express to be run within our setup (arggh). Anyone tried this?

thanks in adv,
Dan

[rbreidenstein]

when i download the .net 2.0 redist from the tools menu it doesn't show up in the redist list. where is it placing this file?


Rick

[Qingsong]

Hi,

Regarding Dan's question, I have a package which runs Windows Installer 3.1, IIS component addition, .NET Framework 2.0, SQL Server 2005 Express in a sequence as pre-requisite.

Several notes:
1. for Windows installer 3.1 engine, make sure you define "Deply MSI engine Reboot" to "Yes", "Suppress Launcher Warning" to "Yes" as well.

2. For .NET Fx 2.0, make sure you are using the command option " /q:a /c:\"install /qb\""

You have to install .NET Fx 2.0 before installation SQL Serer 2005 Express.

This package has passed our QA extensive test with different configurations. It can be done. :-),

Please post if you have any specific issues.

Regards,

Qingsong

[Dhiren]

Does pre-requisites works with Developer 7 ?

[MichaelU]

The prerequisite capabilities were added in InstallShield X (10.0), and is thus unavailable in Developer 7 or 8, or DevStudio 9.

[Dhiren]

Thanks for the reply

I am in process of including MSSQL Server 2005 Express Edition in our existing Setup and finding issues with the same.

Installation of the MSSQL Server 2005 Express edition needs to be silent.

Here is what the problem I am facing:

I am setting up below propeties runtime

MsiGetProperty(hMSI, "SETUPEXEDIR", szCustomeDLLPath,nvSize);
szCustomeDLLPath = szCustomeDLLPath ^ "SQLEXPR.EXE";
MsiSetProperty(hMSI,"SQL2005_DISK",szCustomeDLLPath);

szCommandLine = '/qn INSTANCENAME=' + 'MYINST' + ' SAPWD=' + 'TST' +
' DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL' +
' ADDLOCAL=ALL';
MsiSetProperty(hMSI,"SQL2005_CMDPARAM",szCommandLine);

I have defined a custom action:

Type:Launch an executable
Location: Stored in the Property table
Source: SQL2005_DISK
Target: [SQL2005_CMDPARAM]

And calling this CA in below Sequence

Installation -> Execute -> ISSelfRegisterFinalize -> NEWCA

After Extracting files, its not doing anything -- I meant it doesnt do anything just goes to Setup complete dialog with no errors. How to get this working?

And how do I supress file extraction dlg ?

Thanks in advanced,
Dhiren

[Chocsa]

Quinsong,
thanks for that, I saw the checkbox in the Prereq editor and enabled it. It works a treat. One caveat was the conditon you defined. It was for a defaut install and of course we used a named instance. The workaround is to change the registry check to

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\?your instance name?\MSSQLServer\CurrentVersion

and leave the rest of the condition as is.

Again thanks for this and I hope you had a good break
Dan

[JordanIrwin]

The prerequisite is running during my installation. It installs both windows installer and .NET 2.0 like it's supposed to (when the checkbox is selected). But, during the SQL Server Express installation the following occurs:

1) Extraction of files
2) Setup dialog stating it will install SQL Server Express Support Files
3) Checks my system configuration files
Then....
4) Error Message "The installation of SQLExprPrerequisite appears to have failed. Do you want to continue the installation?"

I have not changed any of the default settings for this prerequisite (other than checking the "Requires windows installer engine and/or .NET framework" checkbox)

Any ideas?

Thanks,

[JordanIrwin]

My problem was the windows machine I tested on did not have the latest updates that are required for SQL Server Express. The error I was receiving in no way eluded to this problem though. When I ran SQLEXPRESS.EXE by itself, the proper error message was received. Once I updated the machine, the pre-req. worked fine. Just a heads up if anyone else experiences this.

[jazeboy]

Hi I've chosen to download the .NET 2.0 redistributable in version 11.5 which I've just upgraded to but I can't find it in objects list to pre-install?

Am I doing something wrong?

[Stefan Krueger]

jazeboy which project type are you using? In MSi projects you include the .net framework using the release wizard.

[jazeboy]

Hi Stefan,

Thanks for the reply. I've been struggling to get my head around what project exactly I should be using.

In a nut shell what I'm trying to do is rollout an SQL server 2005 express install for our end users and automate the check and install of all the required pre-requisites for win2k, winxp or win2003 ie. ie6sp1, .net2.0, MDAC2.8, windows installer 3.1, xp sp2 or win2k sp4 or win2003 sp1 before installing SQL server 2005 express.

(After this I'll then create a separate install of our software - which looks like it should be fairly easy as its just an extract and replace files type install. If I can work it out maybe I can combine this into the above later if thats possible?)

Is an MSI project the right project to use? Is what I’m trying to do feasible? Is it worth the effort do you think, I was hoping that it would be just a matter of checkboxes but it doesn’t sound like its going to be that easy.

[Stefan Krueger]

Prerequisites are basically a matter of check boxes, and the release wizard isn't too complicated, too. Yes I would go for MSI.

[ozziemarquez]

Hello,

I am a new member. I would like to know if anyone has been successful at installing SQL Server 2005 Express and its prerequisites from IS 10.5? I have read this thread and it seems like some have tried it, but it's not clear what the results were. Should I be able to use Qingsong's script that is posted on IsnatllSite.org?

Thanks in advance for any suggestions.

Ozzie

[Dhiren]

We are using Developer 7.04 and integrating SQL 2005 Express edition.

1. "SQL 2005 Express" Setup files are zipped.
2. Once Files are copy, a custom action un-zip the "SQL 2005 Express" Setup files and sets the path to SQL2005_DISK and cmd parameter
SQL2005_DISK holds '/qn INSTANCENAME=' +szSQLInstName+' SAPWD=' + szSAPWS +' DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL ADDLOCAL=ALL'
3. CA is created to launch the SQL 2005 Express
Type: launch an executable
Location: Stored in the property table
Source: SQL2005_DISK
Target: SQL2005_CMDPARAM
4. This CA is called in User interface, after ExecuteAction.
5. This works fine from a dummy Setup but not from my main setup.
6. CA gives error:

Error 1721. There isa problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor.

Any idea?

Thanks

[Dathay]

Error 1721. There isa problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor.

Any idea?


Does the target system meet the minimum requirements for SQL Express 2005?
1:Windows Installer 3.0.

Note: If you are running Windows Server 2003 Service Pack 1 (SP1) or Windows XP SP2, you already have Windows Installer 3.0.

2: Microsoft .NET Framework 2.0. You need to have the right version for your OS (32bit vs 64bit)

--David

[jazeboy]

can anyone tell me how to set the pre-req condition to install
win 2k sp4 if required
win xp sp2 if required

I'll use the condition to check the windows version and I can enter the build but what do I enter for the CSD? This is the service pack number but how can I say if less than win 2k service pack 4? I'll put build 5002195 but how can I say less than service pack 4?

Should I be checking a windows file date/version instead or a registry key? I can't seem to find the answer to this out anywhere. Thanks again.

[jazeboy]

Also was wondering if the command line for sql server 2005 install pre-req:
qb ADDLOCAL=ALL SECURITYMODE=SQL SAPWD="" SQLAUTOSTART=1

does this install default instance? I need to make sure it does this. Thanks.

[Christopher Painter]

Yes, that will install the default instance. Note: The default instance name is no longer mssql but is SQLExpress

[Christopher Painter]

I would not rely on MSI 3.0 or 3.1(v1). Make sure your users are upgraded to MSI 3.1(v2) MSIEXEC ver 3.1.4000.2435

[jazeboy]

if the v2 release (WindowsInstaller-KB893803-v2-x86.exe) is better to use should I then not use the build wizard include windows installer? That automatically includes the non-v2 (WindowsInstaller-KB893803-x86.exe) or should i replaces and rename the file it uses?

it must be hard for IS to keep up with these changes.... I'll just manually do a pre-req for it instead??

[Christopher Painter]

You pretty much nailed it. I'd go the prereq approach.

[jazeboy]

qorried my last post got lost in the mix does anyone have any ideas? i'd prob need to make it build 2195....?? Is there a registry key I can check??


can anyone tell me how to set the pre-req condition to install
win 2k sp4 if required
win xp sp2 if required

I'll use the condition to check the windows version and I can enter the build but what do I enter for the CSD? This is the service pack number but how can I say if less than win 2k service pack 4? I'll put build 5002195 but how can I say less than service pack 4?

Should I be checking a windows file date/version instead or a registry key? I can't seem to find the answer to this out anywhere. Thanks again.

[Stefan Krueger]

I'm not sure I completely understand you but you probably want a launch condition like this:
(VersionNT=500 And ServicePackLevel>=4) Or (VersionNT=501 And ServicePackLevel>=2) Or VersionNT>=502

[Dhiren]

If SQL Server 2005 CTP is installed on a machine then SQL 2005 Express Edition Setup raises message to un-install beta .net framework 2.0 and beta version of the SQL Server...

How do we check the beta versions?

[MichaelU]

Aaron Stebner's recent post (http://blogs.msdn.com/astebner/archive/2006/02/15/532946.aspx) offers one way; an alternate way if you know the version numbers it to look under the NET Framework\NDP key. We don't offer any builtin checks for either method.

[jazeboy]

Q1 anyone know how to make the .net 2.0 command line force install? It currently asks to install yes or no.

using: /q:a /c:\"install /qb\

I've been trying to change it to qn, n etc to no avail.

Q2 on a similar note, i've made a pre-req of ie6 sp1 does anyone know a command line to install ie 6 sp1 without any prompts?

Thanks :-)

[Stefan Krueger]

In your release settings did you switch the .NEt Option Dialog to no?

[jazeboy]

In your release settings did you switch the .NEt Option Dialog to no?

I've left the "show full user interface when installing .net framework" box unticked and still always asks

[Stefan Krueger]

No, I'm talking about the option in the attached screenshot (Basic MSI project)

[jazeboy]

thanks stefan that sorted it :-)

[jazeboy]

hi, I'm still a little confused how I can make win xp sp 2 pre-req work.

I've attached screenshot of the pre-req conditions I'm not sure if this is right regarding build and csd version?

Help much appreciated Thanks.

[jazeboy]

as I have it set from previous post It will install xp sp2 but will do it regardless of whether sp2 is installed or not?? Am I way off track here?

[Stefan Krueger]

I'm not sure if it understands the <2 syntax. And I think it's not a good idea to install an OS update (SP2 for XP) with your setup. I would leave this to the user.

[MichaelU]

CSD Version (on Windows XP) corresponds to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion CSDVersion value, and the prerequisite engine performs a string comparison and requires equality.

But please, these questions have nothing to do with the base thread, so all these questions do is confuse later users who come here. If you have a new question, start a new thread.

[Chocsa]

Anyone tried using the localised versions of SqlServer Express? We are successfully using the Chinese, Japanese, French and Spanish versions however the German version is causing problems. The problem is to do with our request to change the server log on from nt-authority\networkservice to nt-authority\system. We found the german equivalent that is required to do this i.e
NT-AUTORITÄT\SYSTEM
however it still fails in its validation of this account.
Here is our command line parameters:
/qb ADDLOCAL=ALL SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1 INSTANCENAME="XXXXXX" SQLACCOUNT=NT-AUTORITÄT\SYSTEM SQLBROWSERACCOUNT=NT-AUTORITÄT\SYSTEM

We tried manually entering this on a german machine via the command line and it worked. I guess that passing localised parameters via prerequisite editor is not localisable...anyone have any ideas?

thanks in adv,
Dan

[Chocsa]

Well found a workaround for the problem. Created an exe that launched the setup with the command line parameters. The exe was called by the pre req rather than SQLEXPR_GER.EXE of course. Here is a snippet of the VS 2005 code that implemented this:

try
{
string sqlparams = "/qb ADDLOCAL=ALL SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1 INSTANCENAME=\"VARIAN\" SQLACCOUNT=\"NT-AUTORITÄT\\SYSTEM\" SQLBROWSERACCOUNT=\"NT-AUTORITÄT\\SYSTEM\" ";

System.Diagnostics.Process process = new System.Diagnostics.Process();
process.StartInfo.UseShellExecute = false;
process.StartInfo.RedirectStandardOutput = true;
process.StartInfo.RedirectStandardError = true;
process.StartInfo.CreateNoWindow = true;
process.StartInfo.FileName = "SQLEXPR_GER.EXE";
process.StartInfo.Arguments = sqlparams;
process.Start();

output = process.StandardOutput.ReadToEnd();
error = process.StandardError.ReadToEnd();
process.WaitForExit();
}
catch (Exception ex)
{
error = ex.Message;
}
}

Dan

[f_h1360]

hi
i have one program with sqlserver 2000 and vb6 ,i want to use from installshield 10.5 for make setup .in installshield10.5 ,i ticked redistributed sql server.but i dont know how i introduce my tables in sqlserver2000.
please help me