January 11, 2012 at 9:11 am
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.
January 11, 2012 at 2:16 pm
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
January 11, 2012 at 10:13 pm
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.
January 12, 2012 at 1:57 am
Thanks for the feedback.
Glad you sorted it out.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply