SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Adding an instance to a failover cluster
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

carsten.jespersen
Starting Member

Norway
4 Posts

Posted - 02/06/2014 :  07:11:13  Show Profile  Reply with Quote
I'm wondering if anyone could tell me how to install MSSQL3 (Third Instance) in a two node failover cluster, running two instances. SQL Server 2012 on Server 2008R2. Cant find any info that doesn't involve installing node number three.


Br

Carsten Jespersen

tkizer
Almighty SQL Goddess

USA
36674 Posts

Posted - 02/06/2014 :  14:35:14  Show Profile  Visit tkizer's Homepage  Reply with Quote
It's the same procedure as the first two. Before you start, you'll need storage, virtual server name, DNS entry/IP/cluster object for said virtual server created. We create the SPN manually after the install. Your setup might be able to do it automatically.

Once you have all of the prerequisites, startup the installer and follow the prompts. The installer is a bit different from a standalone installation.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

carsten.jespersen
Starting Member

Norway
4 Posts

Posted - 03/04/2014 :  04:38:02  Show Profile  Reply with Quote
Thanks a million Tara. I'll try it out.

Best regards


Carsten
Go to Top of Page

carsten.jespersen
Starting Member

Norway
4 Posts

Posted - 03/17/2014 :  05:13:32  Show Profile  Reply with Quote
Hi again Tara.
In my two-node cluster I have just added a third instance.
I can fail over MSSQL1 and MSSQL2 between the nodes but when trying with the latest addition, MSSQL3, I get the following error:

The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group.

Anything I might have missed?
Node 1 is the preferred owner and node 2 is set as possible owner on all resources. (Disks etc..)


Br

Carsten Jespersen
Go to Top of Page

carsten.jespersen
Starting Member

Norway
4 Posts

Posted - 03/17/2014 :  05:18:21  Show Profile  Reply with Quote
Sorry Tara.
Forgot to actually check owners for the server itself. It works now.
Thank you so much for the push in the right direction.

Br


Carsten


Br

Carsten Jespersen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000