SQL Server Performance

Clustering Integration Services

Discussion in 'SQL Server 2005 Clustering' started by yukonxyz, Nov 22, 2005.

  1. yukonxyz New Member

    I am installing SQL 2005 on a 3 node cluster. Which components can be setup in the cluster environment? I ran a full install, and got an error at the end that said "Remote Setup Failed".

    I know the database services and the analysis services work well, and I know that reporting services is best run on a web farm. But what about notification services and integration services? Also, what workstation components can I install?

    Thanks
  2. satya Moderator

  3. mulhall New Member

    Can you post up the %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
  4. yukonxyz New Member

    Hi all,

    I redid the install. The first pass I just installed the services - no workstation components. Then I went back and installed the workstation components individually on each node. Everything worked okay.

    I suspect it's best not to install the workstation components via the cluster install.

    Anyway, I don't have the logs because I redid the cluster (it's easy with virtual server and iscsi).

    Thanks for you help.
  5. yukonxyz New Member

    Also, I looked at the FAQS, and don't see anything about clustering integration services.

    I can see the services registered in my cluster group.

    - Analysis Services, data disk
    - SQL AP Address 1 (vsql)
    - SQL Network Name
    - SQL Server
    - SQL Server Agent
    - SQL Server Fulltext
    - my physical disk

    Don't the integration services and notification services need to be registered in the cluster group to failover?
  6. satya Moderator

    I believe we need an expertise answer here who has involved in SQL 2005 cluster installation previously, may be Brad.

    Satya SKJ
    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.
  7. bradmcgehee New Member

    In 2005, SQL Server, here are the services that work with clustering:

    1) Analysis Services (automatic setup)
    2) Notification Services (requires special manual setup)
    3) FullText Search

    SQL Server Reporting should Network Load Balancing and SSIS is not cluster-aware.

    If you have problems with remote installs, the biggest reason is lack of proper security. The you must be a local admin on each remote server you install on.


    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  8. yukonxyz New Member

    Thanks. That little summary you gave me was helpful - it would have been nice if it were in the SQL Server 2005 install FAQ.

    Just curious, if you DID want to have failover ETL services - could you install SSIS on multiple nodes, and register it as a generic service in the cluster group? I suppose the trick is if the package repository can reside on the clustered resources.
  9. bradmcgehee New Member

    I have not tried your suggestion, but it would seem reasonable that it could work, if set up correctly. It would require a "manual" failover of sorts.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  10. y_nakache New Member

    Brad Hi,
    even if SSIS is not cluster aware it can be made cluster aware
    please check :
    http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx
    Cya

  11. satya Moderator

    Cya
    If you look at the post it was replied in the year 2005, at that time SQL was in RTM (still most of them working with CTP version), so at that point of time Brad's point is valid.
    HTH

Share This Page