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 |
|
carsten.jespersen
Starting Member
4 Posts |
 Posted - 2014-02-06 : 07:11:13
|
| 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.BrCarsten Jespersen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-06 : 14:35:14
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
carsten.jespersen
Starting Member
4 Posts |
Posted - 2014-03-04 : 04:38:02
|
| Thanks a million Tara. I'll try it out.Best regardsCarsten |
|
|
|
carsten.jespersen
Starting Member
4 Posts |
Posted - 2014-03-17 : 05:13:32
|
| 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..)BrCarsten Jespersen |
|
|
|
carsten.jespersen
Starting Member
4 Posts |
Posted - 2014-03-17 : 05:18:21
|
| 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.BrCarstenBrCarsten Jespersen |
|
|
|
|
|
|
Adding an instance to a failover cluster