Forum Discussion

Biesse's avatar
Biesse
New Member
9 months ago

cannot refresh report automatically

Hi,  I created a report linked to sql server.    I cannot refresh it automatically because of incorrect credentials.   This is the error I had:  Failure details: The last refresh attempt failed...
Need Help
v-veshwara-msft's avatar
v-veshwara-msft
Community Support
9 months ago

Hi Biesse ,
Just checking in to see if the issue is resolved.

The suggestions shared regarding verifying gateway connectivity and switching from OAuth to Windows or Basic authentication are aligned with the recommended approach for SQL Server connections.

Thanks to the community members for their guidance on this. If you are still facing issues after updating the credentials, please confirm whether your SQL Server is hosted on Azure, on-premises, or a VM so we can assist further.

 

Thank you.

  • Biesse's avatar
    Biesse
    New Member
    9 months ago

    Hi, 

    thanks for all replies. 

    We are still verifying with our it manager to fix some problems with gateway. Our SQL servers are hosted on premises, but I'm not able to reach them out, for the moment! 

    I will update you as soon as I can. 

     

    Bianca 

     

    • R1k91's avatar
      R1k91
      Super User
      9 months ago

      so you basically need:

      - one working standard gateway (not personal)

      - that gateway must be in the same network of your SQL Servers or must be able to reach that network through correct firewall rules

      - you need an account to connect, you should verify which type of autheticantion are supported by your instance (SQL Auth or Windows Auth most common) 

      - you need to setup the connection in the service with this credentials leveraging that gateway

      - you need to map the connection in the dataset to the one configured in the gateway

    • v-veshwara-msft's avatar
      v-veshwara-msft
      Community Support
      9 months ago

      Hi Biesse ,

      Thanks for the update. Since your SQL Server is on-premises, ensuring that the gateway can reach the server and that the credentials are correctly configured should help resolve the issue. We’ll wait for your update once the checks are complete.

       

      Thank you.