OS: Microsoft Windows Server 2008 R2 Enterprise x64
SQL Server: Microsoft SQL Server 2008 R2 Standard x64 [Product Version: 10.50.1600.1, Product Level: RTM]
Last night the SQL server we are using decided at random to stop accepting remote connections. We could access the database directly from the server, but not remotely. The services were all up and running, but when we ran NETSTAT -an we found
that the SQL server had stopped listening on the configured port (1540). The app server shows that it stopped at 1:35 in the morning, but we have scoured every log we can find on the SQL server (event logs, SQL server logs, trace logs) and have been
unable to locate anything abnormal. We ended up having to restart the service "SQL Server (InstanceName)" in order to get the SQL server to start listening on the configured port again.
Has anyone experienced this issue before? How did you locate the root cause?
Thanks for any help!
View Complete Post