SQL Server Performance

Standalone SSIS Server

Discussion in 'SQL Server 2005 Integration Services' started by acki4711, Nov 24, 2006.

  1. acki4711 Member

    Hi all,
    Maybe a bit of a supid newbe question.
    We always looked at a db as a storage for data and not as an application server.
    Integration service looks to us to some kind of "business logic" so I'm asking myself
    if it's possible to install Integration service on a machine without the db engine on?
    (Like Report service for example).

    TIA
    Dan

  2. satya Moderator

    One way it is a good option to have SSIS on a seperate machine, you can install in that way.
    Note from BOL 2005:
    quote:
    Software Requirements
    SQL Server Setup requires Microsoft Windows Installer 3.1 or later and Microsoft Data Access Components (MDAC) 2.8 SP1 or later. You can download MDAC 2.8 SP1 from this Microsoft Web site.

    SQL Server Setup installs the following software components required by the product:

    Microsoft Windows .NET Framework 2.0


    Microsoft SQL Server Native Client


    Microsoft SQL Server Setup support files


    Note:
    SQL Server 2005 Express Edition does not install .NET Framework 2.0. Before installing SQL Server 2005 Express Edition, you must download and install the .NET Framework 2.0 from this Microsoft Web site.



    If not already installed, SQL Server Setup installs each of these components separately; only the Microsoft SQL Server Setup support files are automatically removed when you uninstall SQL Server 2005. For more information on uninstalling this release, see How to: Uninstall an Existing Instance of SQL Server 2005 (Setup).

    Note:
    The .NET Framework 2.0 Software Development Kit (SDK) is not installed by SQL Server 2005. The SDK contains documentation, a C++ compiler, and other tools that are useful when using the .NET Framework for SQL Server development. You can download the .NET Framework SDK from this Micros.



    After installing required components, SQL Server Setup will verify that the computer where SQL Server will be installed also meets all of the other requirements for a successful installation. For more information, see Check Parameters for the System Configuration Checker.

    SQL Server 2005 failover clusters require Microsoft Cluster Server (MSCS) on at least one node of your server cluster. MSCS is only supported if it is installed on a hardware configuration that has been tested for compatibility with the MSCS software. For more information, see Before Installing Failover Clustering.

    Internet Requirements
    Internet requirements for both the 32-bit and 64-bit versions of SQL Server 2005 are the same. The following table lists the Internet requirements for SQL Server 2005.

    Component Requirement
    Internet software1
    Microsoft Internet Explorer 6.0 SP1 or later is required for all installations of SQL Server 2005, as it is required for Microsoft Management Console (MMC) and HTML Help. A minimal installation of Internet Explorer is sufficient, and Internet Explorer is not required to be the default browser.

    However, if you are installing client components only and you will not connect to a server that requires encryption, Internet Explorer 4.01 with Service Pack 2 is sufficient.

    Internet Information Services (IIS)
    IIS 5.0 or later is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations.

    For more information on how to install IIS, see How to: Install Microsoft Internet Information Services.

    ASP.NET 2.02
    ASP.NET 2.0 is required for Reporting Services. When installing Reporting Services, SQL Server Setup will enable ASP.NET if it is not already enabled.


    1Microsoft Internet Explorer 6.0 SP1 or later is required for SQL Server Management Studio, Business Intelligence Development Studio, and the Report Designer component of Reporting Services.

    2For Reporting Services (64-bit) installations on 64-bit servers, the 64-bit version of ASP.NET must be installed. For Reporting Services (32-bit) installations on the 32-bit subsystem (WOW64) of a 64-bit server, the 32-bit version of ASP.NET must be installed. Reporting Services is not supported in side-by-side configurations on the 64-bit platform and on the 32-bit subsystem (WOW64) of a 64-bit server at the same time. For more information, see How to: Configure IIS to Run 32-bit Reporting Services in WOW64 Mode.



    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page