Orchestrator 2022 - Database Connection Issues

Yang, Vao 25 Reputation points
2023-12-06T21:28:33.0666667+00:00

I have Orchestrator 2022 stood up in AWS running into database connection issues. There are times I can connect to Runbook Designer and times I cannot. Deploy Manager as well. Looking at the system requirements, it shows for SQL Server, "SQL Always ON is supported, except in cases where configuration is done on multi subnets." I think this maybe the case for my set up. Is there any way to resolve this?

Here are the details on how SQL is setup:

  • An Always On SQL cluster with 2 replicas.  Each replica is in a different subnet.
  • A requirement of our AWS implementation where our EC2 instances reside in different Availability Zones or datacenters.  
  • The listener has 2 IP addresses, one for each subnet.

Others in my IT department suggested to look at MultiSubnetFailover within a connection string. Is that a thing for Orchestrator?

System Center Orchestrator
System Center Orchestrator
A family of System Center products that provide an automation platform for orchestrating and integrating both Microsoft and non-Microsoft IT tools.
229 questions
0 comments
Accepted answer
  1. Anonymous
    2023-12-07T16:01:02.12+00:00

    Hello,

    SQL Always On is supported, except in cases where configuration is done on multi subnets.

    To resolve this issue, it is recommended to set the network name of the availability group listener to only register a single active IP address in DNS and configure the cluster to use a low TTL value for the registered DNS record. These settings allow for quicker recovery and resolution of the cluster name with the new IP address when failover to a node in a different subnet occurs.

    Regarding the MultiSubnetFailover, there is no information indicates whether it is supported in Orchestrator 2022.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.