SQL Server Connector hanging with error in console

Data Studio Data Studio Q&A
,
1

Hi all,

I am trying to establish a connection to my SQL Server instance hosted on an Azure VM. Upon entering my details and clicking Authenticate the screen just hangs like the below:

image
image799×775 33.9 KB

After a few minutes, the following error appears in the console. I’ve reproduced this in both Chrome and Edge:

image
image743×331 23 KB

2

I am having the same problem.

5

I was able to achieve what I needed through a different method (Using the Google Sheets API to populate a Sheet to read from).

While investigating I found a number of issues that could have caused this exception:

  1. Our Server firewall / network settings was not configured to allow for inbound traffic.
  2. We use SQL Server 2022 which is not listed as a supported version for the connector in the documentation.