0

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?

Improve this question
1
  • 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
4

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.

Improve this answer
1
  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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