1

I'm running ADFS 2.0 in Windows 2008r2, connected to a SQL Server 2005 database server. Right now the ADFS server has 5623 TCP connections open to the SQL server (checked via netstat - counted with powershell). This many connections is impacting our SQL server and preventing backups from running properly.

Going off of this question, it seems that ADFS may not be closing its SQL connections, however the connections are all in the "Established" state. This became an issue once before several months ago; if I recall correctly, I resolved it by resetting the NIC (to forcefully kill all active connections). This time around I'm looking at restarting the ADFS services first.

But the question is why is this happening in the first place, and how can I troubleshoot the root cause? I've done quite a bit of research and can't find anything that would point the finger at ADFS - such as a bug or something.

Community
  • 1
Thomas
  • 890
  • 4
  • 18
  • 37
  • If you can raise a case with Microsoft support I recommend doing so. Alternatively some quick suggestions worth trying are networking fix rollups like http://support2.microsoft.com/kb/2775511 and any update to SQL client on ad fs side. – maweeras Oct 11 '14 at 17:52
  • I posted the same question on technet and was referred to MSDN's forums, where I found the following thread. We have a freeze on changes due to a pending network core upgrade, but once that's passed we'll try this out and I'll report back if it resolves the problem. https://social.msdn.microsoft.com/Forums/vstudio/en-US/95831bbe-bae9-4dbe-8620-8bf9f46a53c1/massive-number-of-connecitons-from-adfs-server-to-sql-server?forum=Geneva – Thomas Oct 14 '14 at 15:08

0 Answers0