2

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.

asked Apr 26, 2012 at 7:05
3
  • So you're timing out before you even connect? Commented Apr 27, 2012 at 12:43
  • yes, only one system have timeout expire problem Commented Apr 27, 2012 at 12:51
  • What is different about that system from the others? Is the firewall turned on, is it on a different subnet, etc? Commented May 8, 2012 at 16:04

1 Answer 1

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?
answered May 16, 2012 at 9:22

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.