Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Refused connections

Author  Topic 

shaunc
Starting Member

28 Posts

Posted - 2010-05-19 : 14:22:14
I have a 2005 server that's occasionally refusing connections from our web servers; the web app (using the FreeTDS library) simply reports "Unable to connect," and Apache logs a connection refused error. I don't have any hard limit set on connections. Resource usage looks fairly good and performance is otherwise stellar.

Is there a trace flag I can enable to get more detailed information about why the connections are being refused?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-19 : 15:11:59
You can trace for this via SQL Profiler using the Exception event (in Errors and Warnings), Login Succeeded (in Security) and Login Failed event (in Security). If you don't see the connection happening inside SQL Profiler, then the issue isn't within SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

shaunc
Starting Member

28 Posts

Posted - 2010-05-19 : 15:31:15
Great, thanks Tara. Looks like it's probably an OS issue, as no exceptions and no login audit events are being raised when this happens.
Go to Top of Page
   

- Advertisement -