SSMS connection error during the login process

Hello Experts
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
Pierrot
siufAsked:
Who is Participating?
 
siufAuthor Commented:
It does not work, absolutely no connection is accepted. Even with "sqlcmd -A" I get the same error. So what I did is
- uninstall the SQL database engine
- reinstall the default instance + SP3 + Cumulative Update, which took quite some time
- attach the 35 databases
-  restore the model and msdb from backup
After a few hours, I could login again, but this was a nice experience with SQL Server !

0
 
jorge_torizResearch & Development ManagerCommented:
Use the DAC connection:

Open your SSMS and cancel the default connection intent, then open a new query and in the server name type "admin:locahost", then you will be connected through DAC.

Now, execute:

sp_configure 'max server memory (MB)', 2147483647
GO
RECONFIGURE

I think this can solve your problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.