cancel
Showing results for 
Search instead for 
Did you mean: 

How do I simplify the HA client connection string?

Breck_Carter
Participant
0 Kudos
1,446

The usual connection string for a client that wants to connect to a primary (or secondary) High Availability server on a network includes a list of two host addresses for the two partners which can at any time be the primary (or secondary); e.g.,

"%SQLANY16%\\bin64\\dbisql.com"^
  -c "SERVER=primary_demo; UID=dba; PWD=sql; HOST=computer1:55501,computer2:55502;" 

Is there any networking magic way to simplify that list, to use some kind single unchanging network "alias" that doesn't require changing all 10,000 client connection strings when someone moves servers around on a network?

Accepted Solutions (0)

Answers (0)