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.

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
add comment

1 Answer

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
add comment

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.