3

When I tried to connect with bigquery using OAuth Mechanism as "user Authentication" we are facing below error getting Refresh token

DSN configuration Error.

(1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate

We cannot get catalog and dataset information from the dropdown.

Hector Martinez Rodriguez
  • 277
  • 4
  • 11
Surya
  • 3,408
  • 5
  • 27
  • 35

1 Answers1

1

In this case, there can be many reasons to get this kind of error. You can see these solutions:

  1. If you are behind a proxy/VPN/firewall/load balancer balancer, it could affect the connection. I recommend trying to bypass any proxy/VPN/firewall/load balancer. You can see all the URLs in this document.

  2. You can follow these steps:

  • a. Editing the Google BigQuery ODBC connection under the system DSN tab.
  • b. Checking the box to use 'System trust store' and unticking the box for proxy settings.
  • c. Authentication using 'user authentication' and the refresh token.

  1. Check the version: If you are using a Microsoft Office product, you need to check that the Simba driver and the Microsoft Office have the same versions 32 bits or 64 bits.

  2. Check that you are not using localhost as the hostname in the configuration.

Raul Saucedo
  • 1,614
  • 1
  • 4
  • 13
  • Hi @Raul, It's the issue with trust certificate and we are able to connect. Thank you for the detailed info. – Surya Feb 21 '22 at 18:52
  • 1
    @Surya I am glad you were able to connect to the BQ database, do you have any other issues with the connection I can help you with? – Raul Saucedo Feb 21 '22 at 19:13
  • As of now i am good with the connection , will definitely bug you in the coming days . Thanks a lot @Raul – Surya Feb 22 '22 at 13:09