Forum Discussion

Userbot's avatar
Userbot
New Member
2 years ago

Unable to authorise my ODBC BIgQuery connection

Hello everyone! Need help. Use My own ReportServer, one one reports has bigquery db as datasourse. But I unable to authorise my ODBC BIgQuery connection (via Samba ODBC Driver) to configure my scheduled updates at web ui. Tried both methods as a Service Authentication and User Authentication.  Getting Error Log on failed. Ensure the user name and password are correct.

bigquery

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Userbot ,

    Please try below steps:

    1. Check Credentials:
    - Ensure that the username and password you're using are correct.
    - If you're using service authentication, verify that the service account has the appropriate permissions and that the private key is valid.

     

    2. Permissions:
    - Confirm that the account you're using has the `bigquery.jobs.create` permission in the BigQuery project.
    - If you're using a service account, make sure it has been granted the necessary roles in the IAM & Admin section of the Google Cloud Console.

     

    3. Driver Configuration:
    - Double-check the ODBC driver settings to ensure they are configured correctly.
    - Verify that the data source name (DSN) is set up with the correct connection details.

     

    4. Google Cloud Console:
    - Check the IAM & Admin section in the Google Cloud Console to ensure that the service account or user account has the necessary roles and permissions.

     

    5. Network Issues:
    - Make sure there are no network issues that could be preventing the connection from being established.
    - Ensure that your network allows outgoing connections to Google BigQuery's API endpoints.

     

    6. Driver Updates:
    - Check if there are any updates available for the Samba ODBC Driver that may resolve authorization issues.

     

    7. Logs and Error Messages:
    - Review detailed logs from the ODBC connection attempt for any additional information that could point to the root cause.
    - Check for any error codes or messages that may give more context to the issue.

     

    8. BigQuery API Enablement:
    - Ensure that the BigQuery API is enabled in the Google Cloud Console for your project.

     

    9. Test the Connection:
    - Use another tool to test the ODBC connection with the same credentials to verify if the issue is specific to your ReportServer environment.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.