上次我打开应用程序,所有单元测试通过.现在没有代码更改,我的所有数据单元测试失败,并显示以下错误:
Initialization method
PerTrac.Pictor.Data.Test.RequestLogRepositoryShould.CreateLog threw
exception. System.Data.EntityException: System.Data.EntityException:
The underlying provider Failed on Open. —>
System.Data.sqlClient.sqlException: A connection was successfully
established with the server,but then an error occurred during the
pre-login handshake. (provider: SSL Provider,error: 0 – The wait
operation timed out.) —> System.ComponentModel.Win32Exception: The
wait operation timed out.
我意识到现在有一个类似这样的问题,但这些解决方案对我的情况没有任何影响.
我应该注意,我可以连接SSMS没有问题使用相同的凭据.我没有在禁用的协议上设置强制加密,我已经重置了我的本地IIS几次.
解决方法
运行命令行命令netsh WinSock Show Catalog>> winsock.txt然后记事本winsock.txt来打开文件.
查看返回的每个Winsock目录提供程序条目.如果服务标志值设置为0x20000位,则提供程序使用IFS句柄,并且可以正常工作.如果“服务标志”0x20000位清除(未设置),则它是非IFS BSP或LSP,可能是一个问题.尝试禁用此应用程序,让我们知道它是否工作.
当您查看文本文件结果时,请忽略“名称空间提供商条目”.他们不是问题.
以下是我的清洁系统的样例,用于输出netsh WinSock Show Catalog文件.
Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: MSAFD Tcpip [TCP/IP] Provider ID: {E70F1AA0-AB8B-11CF-8CA3-00805F48A192} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1001 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 1 Protocol: 6 Service Flags: 0x20066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: MSAFD Tcpip [UDP/IP] Provider ID: {E70F1AA0-AB8B-11CF-8CA3-00805F48A192} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1002 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 2 Protocol: 17 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: MSAFD Tcpip [RAW/IP] Provider ID: {E70F1AA0-AB8B-11CF-8CA3-00805F48A192} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1003 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 3 Protocol: 0 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: MSAFD Tcpip [TCP/IPv6] Provider ID: {F9EAB0C0-26D4-11D0-BBBF-00AA006C34E4} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1004 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 1 Protocol: 6 Service Flags: 0x20066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: MSAFD Tcpip [UDP/IPv6] Provider ID: {F9EAB0C0-26D4-11D0-BBBF-00AA006C34E4} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1005 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 2 Protocol: 17 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: MSAFD Tcpip [RAW/IPv6] Provider ID: {F9EAB0C0-26D4-11D0-BBBF-00AA006C34E4} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1006 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 3 Protocol: 0 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: RSVP TCPv6 Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1007 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 1 Protocol: 6 Service Flags: 0x22066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: RSVP TCP Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1008 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 1 Protocol: 6 Service Flags: 0x22066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: RSVP UDPv6 Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1009 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 2 Protocol: 17 Service Flags: 0x22609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider Description: RSVP UDP Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1010 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 2 Protocol: 17 Service Flags: 0x22609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: MSAFD Tcpip [TCP/IP] Provider ID: {E70F1AA0-AB8B-11CF-8CA3-00805F48A192} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1001 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 1 Protocol: 6 Service Flags: 0x20066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: MSAFD Tcpip [UDP/IP] Provider ID: {E70F1AA0-AB8B-11CF-8CA3-00805F48A192} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1002 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 2 Protocol: 17 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: MSAFD Tcpip [RAW/IP] Provider ID: {E70F1AA0-AB8B-11CF-8CA3-00805F48A192} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1003 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 3 Protocol: 0 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: MSAFD Tcpip [TCP/IPv6] Provider ID: {F9EAB0C0-26D4-11D0-BBBF-00AA006C34E4} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1004 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 1 Protocol: 6 Service Flags: 0x20066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: MSAFD Tcpip [UDP/IPv6] Provider ID: {F9EAB0C0-26D4-11D0-BBBF-00AA006C34E4} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1005 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 2 Protocol: 17 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: MSAFD Tcpip [RAW/IPv6] Provider ID: {F9EAB0C0-26D4-11D0-BBBF-00AA006C34E4} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1006 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 3 Protocol: 0 Service Flags: 0x20609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: RSVP TCPv6 Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1007 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 1 Protocol: 6 Service Flags: 0x22066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: RSVP TCP Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1008 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 1 Protocol: 6 Service Flags: 0x22066 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: RSVP UDPv6 Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1009 Version: 2 Address Family: 23 Max Address Length: 28 Min Address Length: 28 Socket Type: 2 Protocol: 17 Service Flags: 0x22609 Protocol Chain Length: 1 Winsock Catalog Provider Entry ------------------------------------------------------ Entry Type: Base Service Provider (32) Description: RSVP UDP Service Provider Provider ID: {9D60A9E0-337A-11D0-BD88-0000C082E69A} Provider Path: %SystemRoot%\system32\mswsock.dll Catalog Entry ID: 1010 Version: 2 Address Family: 2 Max Address Length: 16 Min Address Length: 16 Socket Type: 2 Protocol: 17 Service Flags: 0x22609 Protocol Chain Length: 1 Name Space Provider Entry ------------------------------------------------------ Description: Network Location Awareness Legacy (NLAv1) Namespace Provider ID: {6642243A-3BA8-4AA6-BAA5-2E0BD71FDD83} Name Space: 15 Active: 1 Version: 0 Name Space Provider Entry ------------------------------------------------------ Description: E-mail Naming Shim Provider Provider ID: {964ACBA2-B2BC-40EB-8C6A-A6DB40161CAE} Name Space: 37 Active: 1 Version: 0 Name Space Provider Entry ------------------------------------------------------ Description: PNRP Cloud Namespace Provider Provider ID: {03FE89CE-766D-4976-B9C1-BB9BC42C7B4D} Name Space: 39 Active: 1 Version: 0 Name Space Provider Entry ------------------------------------------------------ Description: PNRP Name Namespace Provider Provider ID: {03FE89CD-766D-4976-B9C1-BB9BC42C7B4D} Name Space: 38 Active: 1 Version: 0 Name Space Provider Entry ------------------------------------------------------ Description: Tcpip Provider ID: {22059D40-7E9E-11CF-AE5A-00AA00A7112B} Name Space: 12 Active: 1 Version: 0 Name Space Provider Entry ------------------------------------------------------ Description: NTDS Provider ID: {3B2637EE-E580-11CF-A555-00C04FD8D4AC} Name Space: 32 Active: 1 Version: 0 Name Space Provider Entry ------------------------------------------------------ Description: WindowsLive NSP Provider ID: {4177DDE9-6028-479E-B7B7-03591A63FF3A} Name Space: 12 Active: 1 Version: 1 Name Space Provider Entry ------------------------------------------------------ Description: WindowsLive Local NSP Provider ID: {229F2A2C-5F18-4A06-8F89-3A372170624D} Name Space: 19 Active: 1 Version: 1 Name Space Provider Entry (32) ------------------------------------------------------ Description: Network Location Awareness Legacy (NLAv1) Namespace Provider ID: {6642243A-3BA8-4AA6-BAA5-2E0BD71FDD83} Name Space: 15 Active: 1 Version: 0 Name Space Provider Entry (32) ------------------------------------------------------ Description: E-mail Naming Shim Provider Provider ID: {964ACBA2-B2BC-40EB-8C6A-A6DB40161CAE} Name Space: 37 Active: 1 Version: 0 Name Space Provider Entry (32) ------------------------------------------------------ Description: PNRP Cloud Namespace Provider Provider ID: {03FE89CE-766D-4976-B9C1-BB9BC42C7B4D} Name Space: 39 Active: 1 Version: 0 Name Space Provider Entry (32) ------------------------------------------------------ Description: PNRP Name Namespace Provider Provider ID: {03FE89CD-766D-4976-B9C1-BB9BC42C7B4D} Name Space: 38 Active: 1 Version: 0 Name Space Provider Entry (32) ------------------------------------------------------ Description: Tcpip Provider ID: {22059D40-7E9E-11CF-AE5A-00AA00A7112B} Name Space: 12 Active: 1 Version: 0 Name Space Provider Entry (32) ------------------------------------------------------ Description: NTDS Provider ID: {3B2637EE-E580-11CF-A555-00C04FD8D4AC} Name Space: 32 Active: 1 Version: 0 Name Space Provider Entry (32) ------------------------------------------------------ Description: WindowsLive NSP Provider ID: {4177DDE9-6028-479E-B7B7-03591A63FF3A} Name Space: 12 Active: 1 Version: 1 Name Space Provider Entry (32) ------------------------------------------------------ Description: WindowsLive Local NSP Provider ID: {229F2A2C-5F18-4A06-8F89-3A372170624D} Name Space: 19 Active: 1 Version: 1