Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2K5 Cluster on Server 2008 x86 Expand / Collapse
Author
Message
Posted Wednesday, January 11, 2012 9:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 22, 2012 12:12 AM
Points: 3, Visits: 4
Hi,

I have stood up a Server 2008 cluster with 3 ISCSI LUN's, One for the cluster resource, one for the MSDTC and one for SQL.
The Server cluster works perfectly, and the DTC service fails over and fails back perfectly.
When I install SQL 2005 Enterprise everything seems to work perfectly, the cluster is detected and SQL is installed on both nodes.

The problem is that SQL is not present in failover cluster MMC, therefore I cannot fail the server over to node B, or back.
I can however use SQL Management Studio to connect to the cluster and everything else seems fine.

I assume I am missing some small step or the likes. I believe that the SQL service etc should be automatically populated in the failover cluster MMC?

Any help/advice would be much appreciated.
Post #1234088
Posted Wednesday, January 11, 2012 2:16 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 4,654, Visits: 11,115
You mean that the SQL Server service is not showing in the Cluster resources?
I guess you didn't install it as a cluster service, then.
Try issuing this:

SELECT SERVERPROPERTY('IsClustered')

If it returns 0, then you don't have a clustered instance and someting went wrong during setup.
If it returns 1, then something is wrong with the cluster anyway.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1234379
Posted Wednesday, January 11, 2012 10:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 22, 2012 12:12 AM
Points: 3, Visits: 4
Thanks for your response.
The SQL & Windows cluster installs were 100% correct. Turns out that SQL install allocates the cluster resources to the available storage group, which is not visible in the failover cluster manager.
The following KB article confirms it is a problem with SQL 2K5 and provides workarounds.

http://support.microsoft.com/kb/932897
Post #1234520
Posted Thursday, January 12, 2012 1:57 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 4,654, Visits: 11,115
Thanks for the feedback.
Glad you sorted it out.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1234570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse