1

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)

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.

Any suggestions?

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

user1845593
  • 1,736
  • 3
  • 20
  • 37

4 Answers4

4

Leaving this here as this SO article is the top result for "SSMS Failed to parse xml blob". I got this error when I was capturing traffic with Fiddler 4 AND running SSMS at the same time. If you are running Fiddler 4, please close it and try again!

Troy Witthoeft
  • 2,498
  • 2
  • 28
  • 37
2

today I experienced the same error message and did a lot of trouble shooting. It turned out to be such a simple fix - my PC requires me to use the new password to log in after I changed it two weeks ago (it says the old password was expired). After I re-logged in, connected to VPN, then I got access back!

enter image description here

enter image description here

enter image description here

tbolon
  • 618
  • 9
  • 17
twistandpulse
  • 21
  • 2
0

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

  • 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
  • Install CCleaner and run registry clean
  • Restart PC
  • Install SQL Managment Studio
user1845593
  • 1,736
  • 3
  • 20
  • 37
0

I was facing this tonight. The connection worked while I was at the office but was failing when connected via the work VPN. I thought I'd have to go into the office. One of my teammates suggested I check and make sure my IP connectivity, and especially DNS, was set to automatic.

  • I disconnected from the VPN
  • Set IP & DNS to Automatic
  • Reconnected VPN
  • Connected to Azure SQL via SSMS successfully

I hope this helps someone else.

Will Tartak
  • 548
  • 7
  • 17