Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Artfuldodger
Starting Member
2 Posts |
 Posted - 2012-01-11 : 07:58:21
|
| Hi, hopefully somebody here can assist me...I am trying to setup a SQL 2005 cluster on a Server 2008 failover cluster.I configure the Windows cluster and there are no hassles.When I install the SQL cluster, the install detects that it is a cluster and installs SQL on both nodes, however SQL is not registered in the Failover Cluster Management MMC and I can therefore not manage the cluster or fail it over to the other node. (I can connect to the SQL server virtual instance through management studio)Any assistance would be appreciated.Thanks! |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-11 : 12:00:25
|
| As I understand when you install the cluster sql2005 , you gave the virtual IP address for the cluster instances and you gave the cluster instances name etc , all the step you follow what required for the installation.If so then can you ping your sql server name from teh dos prompt ?Sr Sql server DBA/Artitech |
 |
|
|
Artfuldodger
Starting Member
2 Posts |
Posted - 2012-01-12 : 00:24:03
|
| 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 |
|
|
|
|
|
|
SQL 2005 Cluster on Server 2008