SQL - A connection was successfully established with the server, but then an error occurred during t...

最新推荐文章于 2025-01-05 23:04:08 发布

转载最新推荐文章于 2025-01-05 23:04:08 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/hunterzou/archive/2010/12/20/1911059.html

文章标签：

#数据库 #git #开发工具

本文介绍了当从本地环境尝试连接ProductionDB时遇到的一个错误：在预登录握手期间发生错误（提供程序：TCP提供程序，错误：0-句柄无效）。并提供了一种可能的解决方案，包括清理Visual Studio解决方案、重建项目、重置IIS及重新运行项目。

I am getting following error when i am trying to connect Production DB from Local Environment.

I was able to connect Production DB before, but suddenly i am getting following error, any idea?

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The handle is invalid.)

Solution

1) Clean your VS.Net Solution

2) Rebuild Project.

3) Reset IIS

4) Run the project again.

Basically that solved my problem, but in my case i was not getting this error and suddenly my local environment starts giving me above error, so may be that trick work for me.

转载于:https://www.cnblogs.com/hunterzou/archive/2010/12/20/1911059.html