A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
2018
Dec
29
awarded  Editor
Dec
29
revised SQL listener connection fluctuates between primary and Secondary
added 100 characters in body
Dec
29
revised SQL listener connection fluctuates between primary and Secondary
edited tags
Dec
28
comment SQL listener connection fluctuates between primary and Secondary
@SeanGallardy Additional information: Our servers are on Azure and SQL listener is configured with Azure ILB. Issue gets resolved for some period when we restart the secondary server, but reoccurs after some time.
Dec
27
comment SQL listener connection fluctuates between primary and Secondary
@SeanGallardy We haven't configured the readonly routing. We have set the Readable secondary property to 'Yes' and not 'Read-Inteant only'.
Dec
26
comment SQL listener connection fluctuates between primary and Secondary
@RandiVertongen We have only one instance.
Dec
26
comment SQL listener connection fluctuates between primary and Secondary
We are simply trying to connect through SSMS. When we look for properties of connections (Listener), Sometime it shows primary server name and sometime it shows secondary server name even though no failover has happened. Also to cross check the connection, we used powershell command "Invoke-Sqlcmd -ServerInstance SQLListenerName -Query "sELECT @@sERVERNAME". Sometime this also returns the primary server name and sometimes secondary server name. Note: We are trying to access the listener from multiple third party server from same domain.
Dec
25
asked SQL listener connection fluctuates between primary and Secondary