How do I tell if a server is cluster aware?

Question

Post reply

How do I tell if a server is cluster aware?

RonKin

SSCommitted

Points: 1948
More actions
April 9, 2010 at 7:56 am

#223142

I do not have a SQL Server Test Cluster. I have no one where I work to assist me.
I am currently running SQL Server 2005 Enterprise. I have 2 separate instances.
One is an Active node instance; SQLCluster1. The other was a working Passive (failover) node instance; SQLCluster2
I was given a requirement to turn the Passive node into an Active/Passive node to house a large database.
Out of my “NEWBIE-NESS”, I evicted the SQLCluster2 node because I thought the TCP Ports weren’t correct. I then rebuilt SQLCluster2 as a Standalone SQL Server per a SQL Server forum (won’t trust them anymore). I then found that I needed to totally remove SQL Server from SQLCluster2. This task was recently completed.
So my question is how do I tell if a SQLCLUSTER2 is cluster aware?
Thank you for your patience with me.
Your favorite fan,
RonKin

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

joeroshan SSChampion Points: 10377 More actions · Answer 1

Not clear enough. Can you please tell what you are trying to achieve?

Are you trying to create a single node cluster?

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

GregoryF SSCertifiable Points: 6296 More actions · Answer 2

RonKin (4/9/2010)
I do not have a SQL Server Test Cluster. I have no one where I work to assist me.
I am currently running SQL Server 2005 Enterprise. I have 2 separate instances.
One is an Active node instance; SQLCluster1. The other was a working Passive (failover) node instance; SQLCluster2
I was given a requirement to turn the Passive node into an Active/Passive node to house a large database.
Out of my “NEWBIE-NESS”, I evicted the SQLCluster2 node because I thought the TCP Ports weren’t correct. I then rebuilt SQLCluster2 as a Standalone SQL Server per a SQL Server forum (won’t trust them anymore). I then found that I needed to totally remove SQL Server from SQLCluster2. This task was recently completed.
So my question is how do I tell if a SQLCLUSTER2 is cluster aware?
Thank you for your patience with me.
Your favorite fan,
RonKin

If both nodes show up in the Cluster Administrator, your OK.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

RonKin SSCommitted Points: 1948 More actions · Answer 3

RonKin

SSCommitted

Points: 1948

April 9, 2010 at 8:21 am

#1149143

No Sir, I am trying to acheive a 2 node cluster.

RonKin SSCommitted Points: 1948 More actions · Answer 4

Would this be before or after the install of SQL Server? Does this mean that both instances will have to be reinstalled?

joeroshan SSChampion Points: 10377 More actions · Answer 5

Did you read this link?

http://msdn.microsoft.com/en-us/library/ms191545(SQL.90).aspx

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

RonKin SSCommitted Points: 1948 More actions · Answer 6

Thank you, I just read it. Does this mean I DON"T have to reinstall SQLCluster1? That would be a big blessing to me to NOT have to reinstall SQLCLUSTER1.

joeroshan SSChampion Points: 10377 More actions · Answer 7

If you have no issues with First node, (ie is ur first server is now acting as single node cluster), you are safe.

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

RonKin SSCommitted Points: 1948 More actions · Answer 8

Ok,

Yes, the first node is working as a single node

Roshan-Joe, You are my hero! 😀

Thank you, thank you, thank you,

RonKin