• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

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
0
siuf
Asked:
siuf
1 Solution
 
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
 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now