question

bonskijr avatar image
bonskijr asked

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? *----
sql-server-2008ssmstimeout-expired
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SQL or Windows logins being used?
0 Likes 0 ·
Sorry it's mixed logins
0 Likes 0 ·

1 Answer

·
Blackhawk-17 avatar image
Blackhawk-17 answered
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?
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sadly yes, either types of authentication. Can't troubleshoot it because it's happens mostly "randomly"
0 Likes 0 ·
Can you experiment by connecting to SQL by IP as opposed to name and see if the timeouts continue?
0 Likes 0 ·
I also did that, as my initial thought was a DNS issue.
0 Likes 0 ·
Do you have multiple IP addresses? On a VLAN? Saturated network? Sounds like Shared Memory works but TCP/IP has issues.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.