SQL instance and port syntax during install

During the SCOM install you get to 2 screens asking for the Ops db and DW location. There's a certain syntax to use depending on the SQL instance.

SQL type: Standalone with standard port (1433)
Change DatabaseServerName to computer\<instance> followed by a comma, and then the SQL Server port number ie. computer\instance,portNumber

SQL type: Cluster
Replace computer with the virtual network name of the cluster.

SQL type: AlwaysOn Availability Group
Replace computer\instance with the availability group listener name ie. AvalabilityGroupListnerName,portNumber

Comments