Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • 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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded