The first of these options takes you through several preliminary steps, including verification of Setup Support Rules, selection of a desired product edition (which might require providing a relevant product key) and a setup role (in our case, SQL Server Feature Installation is most appropriate, although All Features With Defaults is also a valid choice). The Installation section gives you the ability to carry out a New installation or add features to an existing installation, run New SQL Server failover cluster installation, Add node to a SQL Server failover cluster, Upgrade from SQL Server 2000, SQL Server 2005, or SQL Server 2008 (in case of SQL Server 2008 R2), as well as Search for product updates. If you are dealing with an existing instance of SQL Server 2000 or 2005 (rather than planning a new setup), you should take advantage of Install Upgrade Advisor, which will notify you about any existing issues that should be resolved before proceeding. NET Framework 2.0 (although specifics depend the version of the host operating system as well as the edition of SQL Server). Software prerequisites, whose presence can be verified using the System Configuration Checker option (located within the Planning section) include, at the minimum, Windows Installer 4.5 and. Its interface is divided in two areas, with Planning, Installation, Maintenance, Tools, Resources, Advanced, and Options categories displayed on the left and links to their respective tools and technical references appearing on the right. Microsoft delivers this functionality via a collection of utilities and associated documentation grouped into SQL Server Installation Center. While the installation of a SQL Server 2008 or 2008 R2 instance can be carried out in an unattended manner (for more information on this subject, refer to the SQL Server 2008 Books Online), it is likely that the majority of installations will be carried out interactively.
Now we turn our attention to more specific implementation topics, starting with the initial setup and configuration.
That high-level overview was intended to help with a basic understanding of the technology and its intended use. We have introduced the basic concepts of SQL Server 20 R2 (based on the November 2009 Community Technology Preview) Integration Services component, briefly describing its core features and primary characteristics that distingush it from its predecessors.
Marcin Policht shows you how to install and configure SQL Server 20 R2 Integration Services.
0 kommentar(er)
