Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2K5 Cluster on Server 2008 x86


SQL 2K5 Cluster on Server 2008 x86

Author
Message
artfuldodger 86542
artfuldodger 86542
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.
spaghettidba
spaghettidba
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5732 Visits: 13305
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
artfuldodger 86542
artfuldodger 86542
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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
spaghettidba
spaghettidba
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5732 Visits: 13305
Thanks for the feedback.
Glad you sorted it out.

--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search