jordabi


Can anyone direct me to where I can download a redistributable (setup) for SQL Server Express w/Sp2 that is for both 32 and 64 but systems The only on I can find on the MS website is 'en_sql_server_2005_express_edition_sp2_x32.exe' and appears to be for 32 bit systems only. Will this install on a 64 bit system

Also, if anyone has any tips on integrating this into an InstallShield InstallScript project, they would be welcome. I am assuming I can just launch from within my install since it is not MSI based, but have not tried yet.

I will need to either install a new instance or upgrade an existing instance depending on the presence of that instance. Any easy ideas welcome.




Re: Redistributing SQL Server Express

Arnie Rowland


As far as I am aware, SQL Server Express in only available in a 32bit version -that will run on a 64bit OS using WOW.

You can verify that here.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1688823&SiteID=1

And check the redistribution requirements here:

SQL Server 2005 Express Redistribution
http://www.microsoft.com/sql/editions/express/redistregister.mspx

For automated installs, you may find these sources useful:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://www.devx.com/dbzone/Article/31648







Re: Redistributing SQL Server Express

jordabi

Thanks for the help, but I guess i need someone tell me where to download the sql server experess sp2 setup program that accepts the commandline args such as UPGRADE. AllI I can seem to find is 'en_sql_server_2005_express_edition_sp2_x32.exe' and it seems to be a self-extracting exe that does not accept command line args. I need to be able to run this from an installshield project and upgade an existing MSDE instance.




Re: Redistributing SQL Server Express

Arnie Rowland

You apply the command line arguments to the installer AFTER you extract the various files.

You will have to abort the autorun Installer, and then you should be able to follow the suggestions in the links previously provided.