我正在尝试从桌面连接到sql Server 2012(在不同的服务器上)并收到以下错误:
Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was – [Pre-Login] initialization=190; handshake=4; [Login] initialization=0; authentication=102; [Post-Login] complete=14002; (Microsoft sql Server)
客户端是sql Server Management Studio 2012.服务器上的防火墙已关闭.我可以telnet到端口1433.从服务器上的Studio连接本身工作正常.桌面和服务器位于同一网段;使用Windows身份验证.
Windows Server 2008R2和sql Server都是从头开始构建的.
解决方法
改编自我的评论,找到了答案:
检查事件日志.你可能会在那里看到一些指向问题的东西.