Logo
UsFlag English ItFlag Italiano


 
Hotel Sole
 
View Andrea Montanari's profile on LinkedIn

Consuming the SQL Server Express 2008 installation package wrapper

Line

Notice:

  • This posting is provided "AS IS" with no warranties, and confers no rights.
  • Microsoft Corporation is not responsible for the information herewith provided and therefore disclaims all warranties, whether express implied or statutory, fitness for particular purpose, title and non-infringement.
  • All logos, name, images, are to be considered property/copyright/trademark of the respective holders.
  • Consuming the SQL Express 2008 Installation Package wrapper

    The SQLExpress team realeased a wrapper, "a new utility (...) created to help customers who are installing SQL Express 2008 from the web".
    This tool is a little download of about 605 kb (depending on the localization) that will complete the download and installation of all required pre-requisites for the desired SQLExpress 2008 instance, allowing to chose the edition to be installed as well as the localization of the bits.
    In our case, modifying our local settings, the downloaded wrapper was localized in english language, named SQLEXPR32_x86_ENU_Bootstrapper.exe, while the default package for our regional settings (Italy) is about 473 kb and is named SQLEXPR32_x86_ITA_Bootstrapper.exe.

    In order to test the scenario we used a Windows XP sp3 clean virtual machine, where no pre-requisite for SQL Server 2008 has been already installed.

    Current goal: installing a complete SQLExpress 2008 with Advanced Services instance on the local machine.

    Because of the nature of the installation, completely web based, we expect the whole task to be obviously slower than installing SQLExpress from a local image package, and is obviously related to your band width; after all, SQLExpress installer is about 514 mb and DotNet Framework 3.5 sp1 (if required) is about 237 mb :) .
    After executing the wrapper, we are prompted with the initial license agreement
    License agreement

    A little download is performed

    Downloading DotNet Framework 3.5 sp1 boostrapper

    in order to install the DotNet Framework at 3.5 sp1 level
    Installing DotNet Framework 3.5 sp1
    this is a web install and obviously requires some time.

    After the DotNet Framework 3.5 sp1 has been installed, the SQLExpress installer wrapper is chained and requests you to confirm it's execution
    Execute SQLExpress installer wrapper

    that results in an additional download with permissions confirmation
    Execute SQLExpress installer wrapper and permissions

    Finally the user interface of the wrapper is shown, allowing you to customize the installation as required
    Wrapper's user interface

    Prerequisites depending on the instance edition are downloaded, as well as the real SQLExpress installation package
    Downloading additional prerequisites and SQLExpress installer

    After a wait (depending on your bandwidth) the first prerequisite's installation is again chained
    Chained prerequisite's installation

    and a system reboot is required... please remember to log in next time under the same account you now are using to continue the installation..
    Reboot required

    Soon after the required reboot, installation is resumed and the second missing pre-requisite (PowerShell) is installed
    Chained prerequisite's installation

    thus resulting in all pre-requisites installed, so that the installation of SQLExpress can now proceed
    All prerequisites installed

    and finally the SQL Server 2008 Setup is executed, but the wrapper is still executing.

    SQL Server 2008 Setup and wrapper executing

    Once terminated, SQLExpress with Advanced Services has been installed, as long as all the required components.
    SQL Server 2008 Setup terminated

    as indicated by the available application in the Program folder.
    SQLExpress 2008 installed

    We can now configure the instance as desired via SQL Server Configuration Manager and the facets management in SQL Server Management Studio Basic.


    Related:
  • installing, upgrading and uninstalling SQLExpress 2008 instances.
  • Installing SQL Server Management Studio Express.
  • Installing SQL Server 2008 service pack 1 on SQL Server Express 2008.
  • Installing additional features to a SQL Server instance already updated to service pack 1.
  •   Insulin Power® 1993/2010 by Andrea Montanari  modified November 10th 2008
    Copyright (C) 2010 - Insulin Power by Andrea Montanari
    Add Me! SubmitFree: Submit to 25+ Search Engines for free !!!!
    Powered by Daniele Bochicchio and David De Giacomi