Troubleshoot: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
We have this virtualised(VMWare) Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) build 7600, on Windows 2008 r2 Enterprise. We have this very nagging problem of "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" error message using SSMS just to **login**. UPDATE: We're using mixed authentication. It only happens when connecting through SSMS remotely, but if I RDP inside and connect it doesn't happen. I've tried connecting via IP but it also gives the same error What I have done in hopes of resolving this issue: 1. Reduce the number of users under the sysadmin roles(
http://support.microsoft.com/kb/934751) 2. Check, via the sysads, if firewall is blocking the port or dropping them. They said its not. 3. Installed sp_whoisactive just to make sure there's no long running query that might contribute to this. Found nothing. 4. Check if SQL Browser is running and is active, both are true. 4. 6. Disabled for the meantime CDC jobs, just to eliminate it from equation. I'm connecting via SSMS 2008 r2/ SSMS 2008 and sqlcmd all return the same message. I'm stumped and its intermittent , do you have any idea in troubleshooting this? *----