连接到Azure SQL Server时出错“已成功与服务器建立连接，但在登录前握手期间发生错误” [英] Error connecting to Azure SQL Server "A connection was successfully established with the server, but then an error occurred during the pre-login handshake"

问题描述

Hello



我创建了一个新的SQL Server是我的Azure帐户，但我无法从SSMS（SQL Server Mangament）连接。



我已经添加了ip防火墙规则，并且我在SSM中增加了超时，但是我收到以下错误：

"A连接已成功与服务器建立，但在登录前握手期间发生错误。 （提供程序：TCP提供程序，错误：0 - 指定的网络名称不再可用。）（Microsoft SQL Server，错误：64）" b


我是由Twitter写入Azure支持，但他们无法给我解决方案。



谢谢！

Hello

I've created a new SQL Server is my Azure Account, but I can't connect from SSMS (SQL Server Mangament).

I've add my ip the firewall rule and I've increased timeout in SSM, but I get the following error:
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)"

I've written to Azure Support by Twitter, but they weren't able to give me the solution.

Thanks!

推荐答案

你好，

如果您刚刚在Azure上创建了一个SQL Server VM（IaaS）并且想要使用SSMS连接到它，请按照以下步骤提供
文件：

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines -windows-sql-connect #connect-with-ssms

希望这会有所帮助。

问候，

Alberto Morillo

SQLCoffee.com

这篇关于连接到Azure SQL Server时出错“已成功与服务器建立连接，但在登录前握手期间发生错误”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！