无法解析XML Blob [英] Failed to parse XML blob

问题描述

我在对Azure上的dbs进行身份验证时遇到问题.所有详细信息都正确，但是当我单击连接"时，出现以下错误:

I'm having problems authenticating against dbs on azure. All the details are right but when I click connect I get the following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Error connecting to 'tcp:xyz.database.windows.net,1433'.
------------------------------
ADDITIONAL INFORMATION:
Failed to connect to server tcp:xyz.database.windows.net,1433. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
One or more errors occurred. (mscorlib)
------------------------------
One or more errors occurred. (mscorlib)
------------------------------
Failed to parse XML blob.
Reason: XML document must have a top level element.
Line: 0, Position: 0
Text: (null) (System.Data)

我已经卸载了与SQL和SQL Management Studio有关的所有内容，但仍然没有运气.我尝试与其他计算机上的帐户建立连接并可以正常工作，因此我的计算机上似乎有问题.

I already uninstalled everything related to SQL and SQL Management Studio and still no luck. I tried connecting with my account in other machine and works, so it seems is something on my machine.

有什么建议吗?

更新: 我在我的计算机上测试了另一个用户并且可以正常工作，所以我的计算机上的用户一定可以正常工作！

UPDATE: I tested another user on my machine and does work, so it must be something with my user on my machine!

推荐答案

好几次尝试将其解决后，我终于将其修复. 遵循对我有用的步骤:

Ok after multiple attempts to sort this out, I finally got it fixed. Follows the steps that worked for me:

• 卸载SQL和SQL Managment Studio
• 从程序文件中删除SQL文件夹
• 打开"regedit"并删除以下条目:
  • HKEY_CURRENT_USER \ Software \ Microsoft \ Microsoft SQL Server
  • HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server
  • HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server 2012 Redist
  • HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server 2017 Redist
  • HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server本机客户端11.0
  • Uninstall SQL and SQL Managment Studio
  • Delete SQL folders from Program Files
  • Open "regedit" and delete following entries:
    • HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2012 Redist
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2017 Redist
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Native Client 11.0

    这篇关于无法解析XML Blob的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！