SQL Server Performance Forum – Threads Archive
Clustering Integration Services
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? ThanksCheckhttp://www.sql-server-performance.com/clustering_resources.asp for clustering installation. Setup for SQL Server 2005 uses Microsoft Windows Installer to completely integrate the installation of SQL Server features in a single feature tree. Check under eventviewer for any more information. 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.
Can you post up the %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
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.
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?
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.
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
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.
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
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
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
]]>