Need your advise on below query. We have got below cluster and 2 nodes from SQL team for the configuration of always on FCI for SCCM configuration. Say below eg.
SQL Cluster name: CL
1st node – SQL01
2nd Node – SQL02.
We couldn’t contact SQL team has they are not responding.
My query is , while installing the Primary Site ( MECM ). In the place of SQL Server name, which instance name should be given? It should be cluser name or 1st node or 2nd node.
Bit confused, please suggest kindly.
Answers ( 2 )
Which is reachable from the SCCM server when you ping? You don’t need to specify any cluster name but the SQL server name and instance.
I have just given the naming convention for Eg for better understanding
SQL cluster name – CL.abc.com
1 sql server – sql01.abc.com
2 sql server – sql02.abc.com
Just checked, All the 3 serves are pingable from SCCM.
If I want to give the sql server name in CM install, which one I need to choose ? ( I could see sql01 and sql02 , both have management studio installed )
And also reporting services installed only on sql02.abc.com
Please advise which are servers to be choosen while installing CM and for reporting services ?