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.
| Author |
Topic |
|
beatkeeper25
Starting Member
27 Posts |
 Posted - 2014-05-05 : 10:32:01
|
| My production box has started to time out random connections from the app as well as when I try to connect via SSMS. Unfortunately, I'm in an environment where others have access to the server and changes can be made. When I try to connect with SSMS sometimes it works fine, sometimes it timesout, and sometimes it says it timesout but actually makes the connection. I've tested the NIC, seems fine. I did also see some errors stating login was from untrusted domain, but I've replicated the timeouts connecting to server with IP address and SQL authentication. As far as I know, no changes were made in SQL configuration and system has been running for years. Anyone come across anything like this or have any ideas of what to check? We are already talking about buiulding another Prod box and migrating, but 'd really like to know what the issue is here. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-06 : 15:44:21
|
| If you don't see any bottlenecks on the server itself (PerfMon), then this issue is almost certainly due to the network. Run a network trace to see what's going on when it times out.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL 2012 Random Timeouts