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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For the last few days our clients have been suffering intermittent connection timeouts to our database server.

Multiple Ajax calls on the same page which connect to the server multiple times are having mixes of success and failure, and at times specific website users are getting connection issues while other users are not from the same site.

I am not sure if the issue lies with the databases or the server itself, but we may be having connection issues to a different database on the same server.

The server is an Amazon Cloud VPC running Windows Server 2008 RC, and the version of SQL Server is SQL Server 2008 R2. I can provide more information if necessary.

Can someone give me any hints on how to go about debugging this? Maybe a few methods to test the connections?

Many thanks.

share|improve this question

Basically, when you failed to connect to your SQL Server, the issue could be:

  1. Network issue.
  2. SQL Server configuration issue.
  3. Firewall issue.
  4. Client driver issue.
  5. Application configuration issue.
  6. Authentication and logon issue.

I thik you can follow THIS article here for more information.

share|improve this answer

Your Answer


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.