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