Re: sql 2005 cluster setup questions

Thanks again, Geoff. I have a new questions today:

apparently applying SP2 had broken DBMail and Maintenance Plan, after some
research online, I learned Build 3175 can fix the problem. Question 1) Have
anyone apply Build 3175 on a cluster? is it the same procedures as applying
SP2? 2) should I install Work Station and SSIS components on both nodes
first or I should wait until after applying Build 3175? 3) do I need to
apply SP2 first then Build 3175 on 2nd node after both components are
installed on it?

Thanks.

"Geoff N. Hiten" wrote:

Ouch.

Here is the official instructions on how to rip SQL 2005 out by the roots.
http://support.microsoft.com/kb/909967/en-us

Personally, I think FDISK may be your best friend if you can afford to take
the system down and rebuild it.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54E914C4-8FCC-497E-91DE-64EED9064D04@xxxxxxxxxxxxxxxx
I got an error hoping someone can help me:

When I run the installation, I missed a '\' when specified destination
folder name for the work station component, it looks hideous in NT
Explorer
so I decided to uninstall work station (it was only installed on primary
node
at this point) component, deleted the folder from both nodes then
reinstall
it with correct folder name. Everything went smoothly, new installation
completed with correct folder name and tools are working fine. When I
went
to 2nd node to install work station component, the original folder was
still
there and would not let me delete saying "Cannot delete
DTSPipelinePerf.dll:Access is denied..." SSIS was installed on the
primary
node at the time so I unintalled it to make sure nothing was using the
.ddl
but still getting the same error after reboot both nodes. The worst part
is,
if I try to install work station on 2nd node, it will point to there and
would not let me change the installation path. I only have Database
Engine
installed right now, no components. I asked my NT Admin to force delete
the
folder but he said "I can remove the reference to the DLL from the
Registry
so it won't load...". Does anyone has any suggestions? I prefer not
touching registry keys. Thanks in advance for your help.

"Geoff N. Hiten" wrote:

Glad I could help.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DB00AC3-DD73-47B4-AF81-6FDA887F684B@xxxxxxxxxxxxxxxx
not waht I want to hear but thank you very much for the information - I
did
want to take Microsoft recommended approach not to cluster SSIS but I
think
I'll follow your suggestion because we do have shared files.

"Geoff N. Hiten" wrote:

Funny you should ask. I just wrote a blog post on that topic:

http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not-to-Cluster-That-SSIS-the-Question.aspx


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:402FF650-45D5-4D0D-89F8-48ABF1459A77@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E@xxxxxxxxxxxxxxxx
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?










.

Relevant Pages

  • Re: New to clustering and need some clarification on disk resource
    ... "Geoff N. Hiten" wrote: ... second node, only the primary, during a cluster install. ... Senior SQL Infrastructure Consultant ... enough disk space for all your data. ...
    (microsoft.public.sqlserver.clustering)
  • Re: I Surrender.....Help?
    ... Name resolution is critical to cluster ... Verify the Edition of SQL you are installing. ... Install the SQL client tools only on your primary install node. ... account is a domain account with local admin rights on each node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... http://www.clusterhelp.com - Cluster Training ... actually do the install to catch that one. ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... Setup is supposed to install client tools on all nodes. ... Microsoft SQL Server MVP ... the first instance on the cluster. ...
    (microsoft.public.sqlserver.clustering)