Client: Sql Sever Management Studio Express 2005 (SSMSE) on Vista
Server: Sql Server 2005 Express on Windows Server 2008 Standard
When I first try to log into SSMSE from the client machine, the login operation times out. When I retry, the login succeeds almost immediately. If I close the app and re-open it, the same thing happens. This appears to be infinitely repeatable. I am able
to reproduce this behavior using SQLCMD.exe. Here's the error:
"Timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)"
The technical details reference Error Number -2
What may be unique or tricky about this client's network is that it's a mixture of IPv4 and IPv6. I believe the server is configured for both, but honestly the networking side of things is outside of my expertise.
Has anyone else experienced a problem like this? I'm looking for some troubleshooting tips and of course a flat-out answer :-).
Thank you in advance for your time and expertise - I hope I've broken the problem down to its simplest form.
View Complete Post