Hi,
I have a FCI installation with SQL 2016 (Database and Analisys Services) in two node cluster. First node is the active, and the another is the standby.
I'd like to create a new failover role on the standby node and move Analisys Services from the main role to this new role.
Currently:
First Node-> FCI role with DB and AS
Second Node-> Nothing
What I want:
First Node-> FCI role with DB
Second Node-> FCI role with AS
I guess a should install a new FCI installation of AS and drop the first one, isn't it? Should I take something more into account? What are the steps to do this?