Forum Discussion

Biesse's avatar
Biesse
New Member
10 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
Biesse's avatar
Biesse
New Member
10 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
10 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