Mega Search
23.2 Million


Sign Up

Make a donation  
Multi instance failover cluster  
News Group: microsoft.public.sqlserver.clustering

Hello guys,

we've got a little problem with adding the second node to the second 
instance.

Everything works fine with the first instance.

The failover cluster is configured active/passive.

We've got 2 2008 R2 x64 Servers & SQL server 2008 SP1

We've added the second instance over add/remove programs sql server/change.

Now we want to add the second node for the second instance but the 
required field stays empty. We can't choose the second instance.

Anybody an idea what went wrong?

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 10-Aug-2010, at 10:46 AM EST
From: H.Ender
 
add instance to SQL 2008 on Windows 2008 Failover Cluster  
News Group: microsoft.public.sqlserver.clustering
You define the IP address and the network name when you create the service/application in the failover cluster. In failovwer cluter manager select services and applications and configure a servicve or application. There is a wizard to walk through

> On Tuesday, August 10, 2010 4:46 AM H.Ender wrote:

> Hello guys,
> 
> we have got a little problem with adding the second node to the second
> instance.
> 
> Everything works fine with the first instance.
> 
> The failover cluster is configured active/passive.
> 
> We've got 2 2008 R2 x64 Servers & SQL server 2008 SP1
> 
> We've added the second instance over add/remove programs sql server/change.
> 
> Now we want to add the second node for the second instance but the
> required field stays empty. We cannot choose the second instance.
> 
> Anybody an idea what went wrong?


> Submitted via EggHeadCafe - Software Developer Portal of Choice 
> Why GUIDs are not a good idea for SQL Server Primary Keys
> http://www.eggheadcafe.com/tutorials/aspnet/d662b371-ed27-481c-aee0-ebe7cf2d9fad/why-guids-are-not-a-good-idea-for-sql-server-primary-keys.aspx

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 8-Oct-2010, at 3:52 PM EST
From: shawn reinhard