尝试填充对象资源管理器时出现SQL异常 [英] SQL Exception when trying to populate object explorer
问题描述
我在Azure中有一个SQL数据库。实际上有多个。我是一名全球管理员，创建了一些数据库，另一位开发人员创建了其他数据库。突然当我尝试使用在创建数据库
时创建的管理员帐户连接到它们时，我得到以下例外：
I have a SQL Database in Azure. Multiple ones actually. I am a global admin and have created some of the databases and another developer created the others. All of a sudden when I try to connect to them using the admin account that was created when the databases where created, I am getting the following exceptions:
Error connecting to '<DATABASENAME (I replaced the text here.)>'.
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.) (.Net SqlClient Data Provider)
来自SSMS。如果我在Azure Data Studio中尝试相同的操作，我会连接到数据库，但尝试查看表会引发异常。
That is from SSMS. If I try the same thing in Azure Data Studio, I connect to the database, but trying to view the tables throws an exception.
An exception occurred while executing a Transact-SQL statement or batch.
此外，我在C＃代码中的所有连接字符串使用相同的帐户来执行CRUD操作。所以看来我正在连接服务器，但是当试图获取数据库的元数据时，它是我没有更改任何防火墙设置，我在Windows 10中使用
内置防病毒软件。我确保Azure中列入白名单的IP实际上是我的，并且没有改变。我有我整个周末一直在搜索这个问题并找不到解决方案的原因。我希望我遇到的问题有道理。
提前感谢您提供任何帮助。
Also, all my connection strings in C# code work using the same account to perform CRUD operations. So it appears that I am connecting the server, but when trying to get the metadata for the database it's failing. I have not changed any firewall setting, I use the built in antivirus in windows 10. I have made sure that the white-listed IP in Azure is in-fact mine and it hasn't changed. I have been googling the heck out of this all weekend and can't find a cause of solution. I hope the issue I am having makes sense. Thank you in advance for any help you can provide.
推荐答案
你好，
有些用户报告说卸载SSMS并安装SSMS 17.9.1解决了这个问题。其他用户通过安装SSMS 18.0的最新预览解决了这个
问题。
希望这会有所帮助。
问候，
Alberto Morillo
SQLCoffee.com
这篇关于尝试填充对象资源管理器时出现SQL异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
