AnsweredAssumed Answered

AF Failover Installation

Question asked by JkJung on Jun 17, 2020
Latest reply on Jun 22, 2020 by Robin Verhoek

Hello,
I am seeking a solution and need your help.
It is a bit lengthy. I tried as short as possible.
Thanks in advance.

My system sketch is below. I am trying to set up
Failover with <AF-1> and <AF-2> based on manual
"PI-Server-2018-SP3-Patch-1-Installation-and-Upgrade-Guide-EN.pdf"
Its version is PI-Server_2018_SP3.

 

Two Node Collective
<PI-1><PI-2>

 

MCSC Failover

Cluster Name=<AFCluster>

SQL Cluster Name = <AFSQLCluster>

<AF-1>

AF Server

SQLServer

<AF-2>

AF Server

SQL Server

 

Network Load BalanceHeader 2Header 3

<VI-1>

Vision Server

Web Server

Domain Controller

<VI-2>

Vision Server

Web Server

Domain Controller

 

Four questions I have :
#Q1.

      Is it the right way to put both AF server and
      AF SQL server in the same machine for failover?
      The document says it is not recommended but, knowing
      the limitation, technically no issue.

#Q2.

      I heard there are two ways:
            1. "Always On" with registering MCSC service
            2. Failover

      Does "Always On" support failover not "replication" ?
      "Replication" and "mirroring" are the same concept?
      We need, when one machine(active) fails, the other machine (slave) takes control to continue.
      which method is recommend?

#Q3.

      please see the end of this page

#Q4.

      please see the end of this page

 

Currently, I am configuring "Failover cluster".
The steps I followed :
      1. set domain server
      2. set cluster <AFCluster>
      3. set database <AFSQLCluster>,  used "Failover installation option"
         and it requires a new cluster with a new IP.
      4. did the same on the other server <AF-2>
      5. Install AF and AF Analysis
         at this point, I am getting error.
      The message says "AFSQLCluster\AFService not found".

 

#Q3.

       How can I set "AFSQLCluster\AFService" ?
      I put AFService to Domain User, to Local user
      but no success.

 

I managed AF Server Install by manual running GO.BAT
c:\> Go.BAT AFSQLCluster PIAF

but at "Analysis Service" install window, it try to
connect AF server with <AF-1> which is a local machine
hostname. It should be <AFSQLCluster> instead
but it is not an editable textbox.

 

#Q4.

      Like "Go.Bat", is there a command-line way to install "Analysis Service" ?

Outcomes