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.
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:
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? *----
My first guess at this would be a DNS issue that is causing Windows Authentication difficulty in finding/communicating with the Domain Controller.
Do you get the error with a SQL login?
answered Jun 09, 2011 at 07:23 AM