SSMS Timeout Error

Hi all,

I'mhaving an issue connecting to a SQL2008 instance which is built onWindows 2008. The error that I am getting is "Timeout Expired". Thetimeout period elapsed prior to completion of the operation or theserver is not responding.

I am able to connect via sql analyzer.

Any assistance would be much appreciated.

Thanks

"Time-out" is just your client application telling you that the process is taking longer than the time-out setting for the connection (by default typically 30 or 60 seconds).
You can change the time-out setting to 0 (no time-out) and just wait-and-see how long it takes for the process to finish.
Or you can investigate the process and the objects involved (stored procedures, tables, indexes, query statements, and so on and so forth) to see if there are ways to speed up the process.

Hi,
Thanks for this, but my issue is that this is a bnlank server with no dbs on there as yet!

So how long does it take to connect using SQL Analyzer? And after you connected using SQL Analyzer, did you try again with SSMS?
Could still be the time-out setting for the client app (both SQL Analyzer and SSMS are still client apps).
Are you using Windows authentication in both cases? And is the server under a different domain? Does your (network) account have explicit permissions on the instance of SQL Server, or implied?

I have checked that and yes still the same. I wonder if this has something to do with the firewall? but I can't see how since I am able to connect via analyser.

If default instance, try the IP address, instead of the server name.

I tried that as well and still the same.[quote user="Adriaan"]If default instance, try the IP address, instead of the server name.[/quote]

You're running SSMS and "SQL Analyzer" on the same workstation? Not through remote desktop?
By the way, do you mean "SQL Server Query Analyzer" that came with SQL 7.0 and SQL 2000?
And if you're using Windows Authentication, then try SQL Authentication.

Yes Correct. I've tried sql authentication and that timed out as well. I suspect it's the firewall that's playing up.

Well, if "SQL Analyzer" is not timing out then it must be connecting differently.
Try the client-side settings - TCP/IP vs. Named Pipes, etc.

Try this ... Goto Program menu - Microsoft SQL Server 2008/Configuration Tools/SQL Server Configuration Manager
If you are using remote PC(client ) you must specify the protocol either Named Pip or TCP/IP , After you configuration done ,try to login to your DB instance with your credential