How to load SQL Server 2005 in a cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 26 Jun 2006 14:43 GMT

We have clustering set up. Now I want to load SQL Server 2005 EE. Do I load
it on both servers in my cluster? If I understand this correctly, I load the
system db's on the shared disk array. When I load SQL server 2005 on the
passive box, how do I configure the system db's on that server? Everything I
read is for loading SQL server 2005 in a clustered environment for the first
server but not the second. How do I load it on the second server?

Reply to this Message

Rodney R. Fournier [MVP] - 26 Jun 2006 15:57 GMT

SQL will install on every node you tell it - at the same time. Same thing
for Service Pack 1. If you require a second instance, do it all over again,
including the SP.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> We have clustering set up. Now I want to load SQL Server 2005 EE. Do I
> load
[quoted text clipped - 6 lines]
> first
> server but not the second. How do I load it on the second server?

Reply to this Message

Brian - 26 Jun 2006 16:14 GMT

So I only have to go thru the install once?

If I need to move the system mdf's and ldf's after the install to the
correct drives, will I need to do anything else?

Brian

> SQL will install on every node you tell it - at the same time. Same thing
> for Service Pack 1. If you require a second instance, do it all over again,
[quoted text clipped - 20 lines]
> > first
> > server but not the second. How do I load it on the second server?

Reply to this Message

Rodney R. Fournier [MVP] - 26 Jun 2006 16:51 GMT

You can tell the install what drive to mdf's on :)

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> So I only have to go thru the install once?
>
[quoted text clipped - 31 lines]
>> > first
>> > server but not the second. How do I load it on the second server?

Reply to this Message

Brian - 26 Jun 2006 20:26 GMT

Rodney,
It looks like the install went ok except for a warning on the Integration
Services from the primary server. It says it failed to install and configure
assemblies F:\Microsoft Sql
server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: -2147467259

Error message: Unspecified error
Error description: Error HRESULT E_FAIL has been returned from a call to a
COM component.

We did isntall MSDTC clustering which we thought was the original problem.
Any ideas?

> You can tell the install what drive to mdf's on :)
>
[quoted text clipped - 43 lines]
> >> > first
> >> > server but not the second. How do I load it on the second server?

Reply to this Message

Rodney R. Fournier [MVP] - 27 Jun 2006 15:51 GMT

See http://msmvps.com/blogs/clustering/archive/2004/10/25/16672.aspx for a
fix.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Rodney,
> It looks like the install went ok except for a warning on the Integration
[quoted text clipped - 62 lines]
>> >> > first
>> >> > server but not the second. How do I load it on the second server?

Reply to this Message

Linchi Shea - 26 Jun 2006 15:58 GMT

SQL2005 installer is cluster aware, meaning that when you choose to install
in a cluster virtual server, the installer will place all the necessary files
on the other node(s) in the cluster, update their register entries, create
the services on all the nodes, and so on. You do not need to run the install
on each node esparately.

But you do need to tell the SQL2005 installer during the install that you
want to install the SQL2005 instance on the cluster, not on the current node
only.

Linchi

> We have clustering set up. Now I want to load SQL Server 2005 EE. Do I load
> it on both servers in my cluster? If I understand this correctly, I load the
> system db's on the shared disk array. When I load SQL server 2005 on the
> passive box, how do I configure the system db's on that server? Everything I
> read is for loading SQL server 2005 in a clustered environment for the first
> server but not the second. How do I load it on the second server?

Reply to this Message

Geoff N. Hiten - 27 Jun 2006 01:24 GMT

One small correction.

The client tools installer is cluster-blind. You have to install the client
tools individually on each node.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> We have clustering set up. Now I want to load SQL Server 2005 EE. Do I
> load
[quoted text clipped - 6 lines]
> first
> server but not the second. How do I load it on the second server?

Reply to this Message