且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SSMS无法连接到Azure数据库

更新时间:2022-10-18 10:50:43


感谢您的反馈。我们将帮助您解决问题。您能否参考这个

MSDN主题
,这可能会解决您的问题。


如果您遇到此问题,请告知我们。


问候


Anurag


I am getting this message trying to connect to my (two year old) Azure account with SSMS. I'm never had problems before.

I also get a similar message when my wpf/c# program tries to retrieve data from Azure.

I have no network problems and this has been going on for days. 1433 is open. I have reinstalled SSMS (17.9.1) and Visual Studio.

Azure portal works fine. I can connect to and query my Azure database through sqlcmd.

Microsoft SQL Server Management Studio ------------------------------ Error connecting to 'abc.database.windows.net'. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) ------------------------------ An existing connection was forcibly closed by the remote host

Hi,

Thanks for your feedback. We will help you resolving your concern. Could you please refer this MSDN Thread, this might resolve your issue.

Please let us know if you are facing this issue.

Regards

Anurag