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

[Former Member]

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

[clas_hortien]

Hi,

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

Best regards

   Clas Hortien

[patelyogesh]

We have find what is the issue for us. We are working to get this resolved.

DELL Secure product blocking all traffics and that's why we are having this issue.

-Yogesh

[former_member206857]

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

[former_member206857]

Troubleshooting: Connection Forcibly Closed

[former_member184473]

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

[patelyogesh]

We are also having same issue and we are not able to find any solution till today.

-Yogesh

[luisdarui]

Hi Yogesh,

Maybe you can get more help with SQL Server management studio within https://support.microsoft.com this should be the best place to get help to fix issues with this.

Best Regards,

Luis

[patelyogesh]

Hello Luis,

I have search through lots of Microsoft KBase but no luck for this error message.

-Yogesh

[luisdarui]

Yogesh,

Have you gone through this wiki also?

http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-th...

Best Regards,

Luis

[patelyogesh]

Hello Luis,

I have gone through this and I have open message with Microsoft for this issue.

Regards,

Yogesh

[former_member188883]

Hi John,

Could you refer the link and check whether it helps.

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

Regards,

Deepak Kori