 | |
sql 2005 cluster setup questions
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: sql 2005 cluster setup questions -
10-25-2007
, 08:42 AM
|
Since you asked nicely, Yes, you should be able to install any of the non-clustered components on a currently inactive node without affecting the cluster. I still would wait for a maintenance window, just because I like to play things safe. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Mary" <Mary (AT) discussions (DOT) microsoft.com> wrote in message news:09963DA7-66AA-4D3A-A80F-97E3372328C5 (AT) microsoft (DOT) com... Hello Geoff, Since you thoroughly answered Li’s questions, I guess you can answer mine too. I have one-instance two-node clustered SQL server 2005 sp1. The node two doesn’t have SSIS and workstation tools installed. I need install SSIS and workstation tool on the second node of the PRODUCTION cluster. If I am going to run the installer on the second node which doesn’t own the resource to install SSIS, do you expect to see any issues? I did install SSIS on the second node when the second node owned the resource in the past and many places recommend do that. Since I don’t have an extra SQL server 2005 cluster test box to test, I am just wondering if you happened to know I can install SSIS from the node which doesn’t own the resource. Thank you very much. Mary. "Geoff N. Hiten" wrote: Funny you should ask. I just wrote a blog post on that topic: http://weblogs.sqlteam.com/geoffh/ar...-Question.aspx -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Li" <Li (AT) discussions (DOT) microsoft.com> wrote in message news:402FF650-45D5-4D0D-89F8-48ABF1459A77 (AT) microsoft (DOT) com... I installed SSIS on Active node of SQL Server 2005 Std, Active/Passive Cluster. Do I need to install it on Passive node too if I don't need SSIS to be configures as a cluster resource? What will be the disadvantages for not having SSIS on 2nd node? Thanks. "Geoff N. Hiten" wrote: The usual "It depends" answer applies. I have been putting SSIS in a separate resource group, but only on single-instance clusters. I haven't experimented with clustering SSIS for multiple instances. I suggest unclustered for this many nodes, that way, there is always a local copy for each instance to use. If you only use SSIS on one instance, then I would cluster around that instance. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Ellie" <Ellie (AT) discussions (DOT) microsoft.com> wrote in message news:F87915F6-4B88-44D8-92CB-2758872CC0B9 (AT) microsoft (DOT) com... Thanks so much for valuable information. what will be the best for consolidated sql envitonment on active/active cluster with 4 instances 1. to install it SSIS on all nodes to leave it unclustered 2. to configure SSIS in all sql resource groups (dont know if that possible at all) 3. to cluster SSIS in different cluster group "Geoff N. Hiten" wrote: By default, SSIS only does a local install. You can install it on each node and cluster it "by hand" afterwards. Here is the article on how to do it: http://msdn2.microsoft.com/en-us/library/ms345193.aspx The installer should start from the node that currently owns the disk resource you wish to use for that particular SQL instance. Personally, I prefer to run the installer on each node and install just the client tools and documentation. Those components are not cluster-aware and must be installed on each node separately anyway. It is less confusing if you get them out of the way first. Standard Edition only supports 2-node clusters. It won't work on clusters with more than two nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Ellie" <Ellie (AT) discussions (DOT) microsoft.com> wrote in message news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) com... Im working on sql consolidation project and I am about to build multiinstance 2 node cluster. If I want Integration services installed should I manually install on both nodes or thats something that will be installed automatically on both nodes ( It is crutial to have IS installed) i want to 2 instances to live on node1 and 2 more on node 2 ( i.e. active active cluster). Should I start sql set up on one node only or I have to run setup from home node of each instance? last one q - is it possible to build 4-instance cluster active-active with SQL 2005 Standatrd edition? |
#32
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.