Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a server machine and four client machine for database connectivity.

I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through the EMS (SQL Manager 2008 for SQL Server ).

The issue is that when I connect the database from that m/c which has sqlexpress 2008 then it gives "Timeout Expired"

But all remaining systems connect to server easily.

Why it gives an error for that particular system.

share|improve this question
    
So you're timing out before you even connect? –  Thomas Stringer Apr 27 '12 at 12:43
    
yes, only one system have timeout expire problem –  Ghost Answer Apr 27 '12 at 12:51
    
What is different about that system from the others? Is the firewall turned on, is it on a different subnet, etc? –  jgardner04 May 8 '12 at 16:04

1 Answer 1

Some things I'd check:

  • When you connect from SQL Server Management Studio 2008 on the box with Express, are you using the right server name (and possibly port number)?
  • Have you got Windows Firewall enabled on any of the machines?
  • Can you ping the SQL Server? Do you get the same IP address for it that you get on the other machines?
  • Do you have any aliases set up in SQL Server Configuration Manager?
  • Have you disabled any client protocols in SSCM?
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.