Forum Discussion

RMuoni's avatar
RMuoni
Regular Visitor
2 years ago
Solved

Data gateway datasource connection needs reauthentication everyday

Hello, I've run into a problem where the connection to our SQL server needs to be reauthenticated each day. It works fine through out the day even until evening but during the night it seems like som...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi RMuoni 

     

    Here are some steps to help you resolve or manage this issue:

    1. Token Expiry Confirmation: Check the expiration policy for your OAuth2 tokens. If the tokens are indeed set to expire every 24 hours, this would align with the issue you are experiencing.

    2. Automatic Token Refresh: Ideally, your authentication setup should support automatic refreshing of tokens. This can usually be configured in the application that manages your SQL server connections (like Power BI). Ensure that your application is set up to automatically refresh tokens. This might involve:
    Checking the configuration settings in Power BI or the gateway managing these connections.
    Implementing a script or using middleware that can automatically refresh the tokens when they are close to expiring.

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi RMuoni 

 

Here are some steps to help you resolve or manage this issue:

1. Token Expiry Confirmation: Check the expiration policy for your OAuth2 tokens. If the tokens are indeed set to expire every 24 hours, this would align with the issue you are experiencing.

2. Automatic Token Refresh: Ideally, your authentication setup should support automatic refreshing of tokens. This can usually be configured in the application that manages your SQL server connections (like Power BI). Ensure that your application is set up to automatically refresh tokens. This might involve:
Checking the configuration settings in Power BI or the gateway managing these connections.
Implementing a script or using middleware that can automatically refresh the tokens when they are close to expiring.

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.