What is use of Read/write and Read-only listener endpoint in Failover Groups

%3CLINGO-SUB%20id%3D%22lingo-sub-2078361%22%20slang%3D%22en-US%22%3EWhat%20is%20use%20of%26nbsp%3BRead%2Fwrite%20and%26nbsp%3BRead-only%20listener%20endpoint%20in%20Failover%26nbsp%3BGroups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078361%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ECan%20someone%20help%20me%20to%20know%20use%20of%26nbsp%3B%26nbsp%3BRead%2Fwrite%20and%26nbsp%3BRead-only%20listener%20endpoint%20in%20Failover%26nbsp%3BGroups%20in%20Azure%20SQL%20MI.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E1.%20Can%20I%20use%20Name%20of%26nbsp%3BRead%2Fwrite%20listener%20endpoint%20in%20Connection%20String%20for%26nbsp%3BRead%2Fwrite%20and%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E2.%26nbsp%3BCan%20I%20use%20Name%20of%26nbsp%3BRead-only%20listener%20endpoint%20in%20connection%20String%20for%20Reporting%20purpose.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Team,

 

Can someone help me to know use of  Read/write and Read-only listener endpoint in Failover Groups in Azure SQL MI. 

 

1. Can I use Name of Read/write listener endpoint in Connection String for Read/write and

2. Can I use Name of Read-only listener endpoint in connection String for Reporting purpose. 

 

 

1 Reply

Read/write listener endpoint is a generic server name given by default(azure).   In case of failover, regardless of which server is uprunning,  using the default server name (abc.database.windows.net) in the application can read/write and listen only from the primary server seamlessly. It always points to the primary sever irrespective of number of times the switching of primary and secondary server happens.

 

If your application only reads and listens data from the server then use this default name in Read-only listener endpoint.

 

Not sure about connecting strings.

 

@manishshukla05