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

While I try to connect to SQL Server, I am getting the following error:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (Microsoft SQL Server, Error: 10053)

How can this be solved? What may be the cause of this issue?

share|improve this question
Can you connect at all? Even locally on the server? ANd what does the Windows event log say? – gbn Jul 3 '13 at 6:50
up vote 4 down vote accepted

There are several causes for this. The ones I know of (at least)

Have you ever connected? Changed any settings? Have a backup of master? What other errors are there in the event log?

Anyhow, restart SQL Server with the -f option and ensure the the 2 settings above are sensible.

share|improve this answer
Your reply is almost correct. Restarted that particular instance and I could now connect to the same..Thanks for that.. :) – Vysakh Jul 3 '13 at 7:34

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.