SSMS connection error during the login process
Posted on 2009-12-17
I wanted to change the min and max memory limit in SQL Server 2005, did it a bit too quick and unfortunately typed 0 for min and also 0 for max, because some keys aren't working well on my keyboard.
So now I cannot connect to the instance when using sqlcmd or SQL Server Management Studio.
I'm getting the 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).
I tried connecting with sqlcmd -A, using ADMIN:<servername>, in single-user mode, etc. no chance.
I did not even find where to change the max memory parameter in some startup file...
On that server, the Analysis Services work just fine, no problemo.
Help, advice or recommandation of any sort will be welcome, many thanks in advance