SSMS connection error during the login process

Posted on 2009-12-17
Last Modified: 2012-05-08
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
Question by:siuf
    LVL 15

    Expert Comment

    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

    I think this can solve your problem

    Accepted Solution

    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 !


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now