Forum Discussion
SQL Server connections offline
We solved the issue with the solution described in this post.
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-2024-release/
By trusting all our database servers in the GatewayCore configuration file, we are able to create new connections, and existing connections appear online.
Thanks to Anonymous for the clear instructions in the post.
Thank you for your replies to my message. 1) No, we do not have any logon triggers and 2) Yes, the certificate name matches the server name.
As I mentioned, the dataset refreshes are working fine. It seems like the gateway software uses different mechanisms to authenticate for a dataset refresh versus when creating new connections or retrieving the status of a connection. If we could find out what that difference is, it would really help narrow in on the problem.
Many thanks.