Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
35 views

We have 2 SQL server 2016 servers that are having communication issues

We have 2 SQL server 2016 servers that are having communication issues when setting up Availability groups and replication. The servers can ping each other and can be connected using a UDL file and an ...
1
vote
0answers
334 views

DNS lookup failed with error: '11001(No such host is known.)'

I have a server in the USA that should connect to one of our servers in Europe through service broker. The server in Europe is an Availability group, whose listener is called sqlst. when I run the ...
1
vote
1answer
64 views

How to show the Availability group listener instead of the nodes?

I have just installed a sql server availability group, always on, with 2 servers, SQLPROD1_TS and SQLPROD2_TS as you can see on the picture below: select distinct rcs.database_name, ar....
2
votes
2answers
346 views

Odd error when stress testing against an AG

We are running into an odd error when trying to stress test our application that hits an AG. If we point the application directly to the primary server, we don't see any issues with the test. ...
3
votes
1answer
236 views

Do applications have to specify TCP: in the connection string to availability group listeners?

In articles that I have read about applications accessing databases through the availability group listener, they all seem to want to use TCP: prefix before the listener name in their connection ...
2
votes
1answer
2k views

Difference between Session Timeout and Heartbeat in always on

What is the difference between Session Timeout and Heartbeat in always on... My Network is laggy and i get frequent connection timeout error on error logs and also at the I see missed heartbeat errors ...
1
vote
1answer
444 views

Periodic connection failure on SQL Server 2012 AlwaysOn cluster

Since last wednesday (so a we're dealing with this for a week now) we're getting periodic connection problems on our production database cluster. (An alwayson cluster running on windows 2012, three ...
5
votes
1answer
233 views

SQL Server 2016 Availability Groups Named Pipes?

We have a SQL Server 2016 cluster configured (two VM's) with our databases spread across multiple Availability Groups (AG). Our Sharepoint admin is reporting to me that some functionality is failing ...
2
votes
2answers
3k views

High Availability Error 35250 and “An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)

I am facing problem in configuring High Availability, this is my 30-40 time configuration of Always On Availability Groups with central subscriber replication topology and I have never been stuck like ...
1
vote
0answers
262 views

SQL Server 2014 - remote login to AOAG named instance, listener port does not work

Your help is greatly appreciated. I spent a few hours trying to troubleshoot this and before I go to the firewall/network possibilities, i would like to check if my setup has any errors I am unable ...
3
votes
0answers
623 views

Connection timeout via AlwaysOn Listener IP on local computer

I have AlwaysOn availability group and it has one Listener IP. I can connect this instance using Listener name but, cannot connect using Listener IP from my local computer. It returns following error ...
2
votes
1answer
613 views

SQL Server 2012 Always On AG - DBEngine Service account locking

I am having a strange issue and am hoping you guys might be able to help! Problem: I have a 2 node SQL Server 2012 Availability Group Cluster utilising a FSW. Both nodes are using the same DBEngine ...
7
votes
1answer
20k views

Connection AlwaysOn AG Listener Problem

I'm a newbie for microsoft technologies and I'm having problems in connectivity part for SQL Server 2014. This is probably an easy issue but I'm stuck. I've 4 servers. One of them is the Active ...
5
votes
1answer
12k views

SQL Server AlwaysOn Error_number 35206

I've joined a Ecommerce business where they use SQL Server 2012 AlwaysOn for HADR and this is the first time I've come across supporting this technology. The Sql Server log on both nodes gets ...