August 26, 2014 at 6:47 am
this is the 1st time we are building a active/passive cluster with 1 node each. we usually install default instance and setup domain account as service account which will have an spn delegated. Now for active/passive cluster is it ok to use same domain account as service account for both clusters with both creating as default instance again as the windows was built as SERVER1 and SERVER2.
August 26, 2014 at 8:18 am
doesn't make sense can you explain in more detail please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2014 at 9:06 am
I have a server REVSQL with 2 clusters (REVSQL1 and REVSQL2) on win 2012. I need to install sql server 2012 on this now, should i be naming the instance as default to the machine name or install a named instance naming them as REVSQL1 and REVSQL2?
Also can i use same domain account as service account for REVSQL1 and REVSQL2?
August 26, 2014 at 9:12 am
its still not clear and doesn't make complete sense. you can only have 1 default instance in the cluster the rest must be named.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 9:37 am
REVSQL is not a server. It is SQL Server Network Name. Consider it has a virtual name or pointer that directs to REVSQL1 or REVSQL2 based on what is active.
The link has a three part series that explains cluster and how to set it up.
http://www.pythian.com/blog/how-to-install-a-clustered-sql-server-2012-instance-step-by-step-part-1/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply