none
SQL Server Express Installation with Inno Setup

    Question

  • Hi,

    I use Inno Setup for my applications and I need to install SQL Server Express 2008 with an application. Here are my questions:

    1) MS recommends that I distribute the downloaded file and extract the files during install. Question... If I do that, how do I make sure to DELETE these files after installation?

    2) If I want to do a quiet install, is there an account I can use for the service account that I know about before hand? I know many products install SQL Server as part of their install and they don't ask for which account to use as the service account and what the password is. How would I handle that?

    3) The installation may happen on anything from Windows 2000 Professional to Windows 7 to Windows server 2000-2008. Are there any considerations (especially for 2000) I need to know about?

    4) I might have to deal with 64Bit and 32 Bit installs. Do I need to be careful to install the 64 bit SQL Server on a 64bit machine or is 32bit good for all?

    5) How do I tell if the instance I am installing has already been installed?

    Thanks in advance...

    Wednesday, July 28, 2010 9:33 PM

Answers

  • hi,

    1) MS recommends that I distribute the downloaded file and extract the files during install. Question... If I do that, how do I make sure to DELETE these files after installation?

    you've better ask this in InnoSetup newsgroup, but personally I never found a good script for installing MSDE/SQLExpress.. if you have better luck, please post it as well :) anyway, I'd not "extract" the installer, I'd just shell to it to have the job done.. you have no actual benefit extracting it before consuming it..

    2) If I want to do a quiet install, is there an account I can use for the service account that I know about before hand? I know many products install SQL Server as part of their install and they don't ask for which account to use as the service account and what the password is. How would I handle that?

    you should probably rely on the "basic" defaul account, the builtin and more limited one among the available, NETWORKSERVICE.. and in this case you do not have to provide the relative (absent) password, as indicated in http://technet.microsoft.com/en-us/library/ms144259(SQL.100).aspx#Accounts

    3) The installation may happen on anything from Windows 2000 Professional to Windows 7 to Windows server 2000-2008. Are there any considerations (especially for 2000) I need to know about?

    AFAIK (http://technet.microsoft.com/en-us/library/ms143506(SQL.100).aspx#Express32) SQLExpress is not supported at all on Windows 2000..

    4) I might have to deal with 64Bit and 32 Bit installs. Do I need to be careful to install the 64 bit SQL Server on a 64bit machine or is 32bit good for all?

    32 bit based software is "ok", but it will run in a WOW (Windows On Windows) scenario.. but it will work

    5) How do I tell if the instance I am installing has already been installed?

    I never investigated as the pascal scripting of Inno can "handle", say, interoperating with WMI, but you probably have to use it to "list" all eventual already installed instances and check your one is not present.. it not installed, you can "shell" to the SQLExpress installer..

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/ - http://www.hotelsolericcione.de
    Wednesday, July 28, 2010 10:49 PM
    Moderator