SQL 2005 Cluster ! !

Question

SQL 2005 Cluster ! !

nbz_01

SSC Veteran

Points: 200
More actions
December 12, 2009 at 12:28 am

#139980

Good day,
We have 2 SQL 2005 engines installed on 2 different machines (DB1 & DB2). Both DBs linked to the data which is in SAN. Sometimes the ODBC on the application level does not see the SQLCLUSTER.
I want to check if the SQL Engines installed as Cluster. How can I check that? becuase I have adoubt that both were installed as Stand-Alone SQL Server.
One more thing, if I have to uninstall SQL Engines & install them again, Do I have to reinstall the Cluster on Windonws 2003 (Cluster Administration) or delete the groups?
Please if there is good document or guide for that, just provide me to solve this issue.
Best regards.

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

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Start cluster administrator (cluadmin) and make sure that the SQL resource group is there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nbz_01 SSC Veteran Points: 200 More actions · Answer 2

Thanx for the hint

I have DB2 only in Resources and online.

I have 2 groups: ClusterGroup & Group0

Both groups contains DB2, If I make move group, it will bring DB1 online.

how can I check that the SQL Instances are installed as Cluster, is the Cluster Administration on windows 2003 will move the groups even though if both DB1 & DB2 has SQL Instance as stand alone not as cluster?

Just I wanna check, becuase it must be cluster configuration on both level (Windows & SQL Engine)

The real issue foe this check, becuase the cluster must be restart from time to time, then the application servers could connect !!!

could you guess where is the problem?

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

nbz_01 (12/12/2009)
could you guess where is the problem?

From your description, no.

Got anyone there that knows clustering?

What is DB2?

What's in the groups ClusterGroup & Group0

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nbz_01 SSC Veteran Points: 200 More actions · Answer 4

Let me explian more:

we have to groups on Cluster Administration:

1. Cluster Group (Could be DB1 or DB2)

2. Group0 (Could be DB1 or DB2)

DB1: database1 server, it contians OS for SQL Instance 1 "SQLCLUSTER"

DB2: database2 server, it contians OS for SQL Instance 2 "SQLCLUSTER"

We have issue on the connection from the application servers

App1 & App2 on the ODBC with the cluster.

The ODBC in both application servers loses the connection with SQLCLUSTER for unkowen reason.

as troubleshooting:

we checked the CLUSTER Environment to see if the configuration is perefect

DB1 (10.0.0.2)

DB2 (10.0.0.4)

SQLCLUSTER (10.0.0.3) Virtual IP

my adoubt is about the SQL Instances if it was installed as Stand Alones not as clusters.

How Could I check that the cluster environment is configured successfully?

This is for (Cluster Administration on Windows 2003 & SQL Instances on DB1 & DB2)

How I can ensure that the SQL Engines installed on DB1 & DB2 as SQL Cluster?

I hope now it is clear 🙂 please your Advice

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Look in cluster administrator. Make sure that the SQL instance is a cluster resource. Make sure that the possible owners for it are the correct nodes.

Is there someone there that knows clustering? If not, can you get someone in to check the cluster over for the appropriate config?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLbee Ten Centuries Points: 1009 More actions · Answer 6

Use the following to determine if the sql server is a clustered one.

Select serverproperty( 'IsClustered')

To fine out the instance which is the current of cluster resources run:

Select serverproperty( 'ComputerNamePhysicalNetBIOS" )

To test the basic functionality of the cluster, ping the cluster from another system within the network using the name, it should reflect the cluster ip address and not the server ip address.

regards

Akhil

nbz_01 SSC Veteran Points: 200 More actions · Answer 7

Thanx for the help guys.

I did the test as you mentioned:

--------------------------------------------------------

on DB2 server:

Select serverproperty( 'ComputerNamePhysicalNetBIOS' )

Output: DB2

Select serverproperty( 'IsClustered')

OUTPUT: 1

---------------------------------------------------------

on DB1 server:

Select serverproperty( 'ComputerNamePhysicalNetBIOS' )

Output: DB2

Select serverproperty( 'IsClustered')

OUTPUT: 1

----------------------------------------------------------

Notice: The online DB at the Cluster Administration when the test done is DB2

I did the Ping also for the Cluster Name & it replays with the virtual IP for Cluster

Please, is the cluster in this case configured successfully?

another thing: is the SQL is a Cluster in this case?

Please your advice.

Best regards.