Skip to Content
author's profile photo Former Member
Former Member

Cannot Login to SQL Management Studio after IT update - Network Configuration issue

Hello,

I have Microsoft SQL Management Studio installed on my local machine; up to this point I have never had an issue with the Studio or the network configuration. However, after my computer ran the scheduled IT update earlier this week, I can no longer access my instance. When I open the studio and try to connect, I get 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 existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) "

When I attempt to connect again I get a very similar message:

"A connection was successfully established with the server, but then an error occurred during the login process. (Provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64) "

I have tried countless solutions but none have resolved the issue. Has anyone seen this issue before who can offer some insight as to how to fix it?

I truly appreciate your assistance with this matter.

Best,


John Basile

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Apr 26, 2013 at 12:47 AM

    Hi John,

    Could you refer the link and check whether it helps.

    http://support.microsoft.com/?kbid=919710

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2013 at 01:58 PM

    Hi John,

    It maybe necessary to recreate the authorizations for your <sid>adm user.

    Use user Administrator and refer to note 1294762 (schema repair script).

    Regards,

    Eduardo Rezende

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2015 at 08:08 PM

    You sure its an update and not a port issue? Is the server located on the same network segment as your computer?


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2015 at 08:35 AM

    Hi,

    you have to run the Management Studio elevated, so rightclick on it and then "run as administrator".

    Best regards

    Clas Hortien

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.