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.
Hi powerapps_tec,
Thank you for reaching out to Microsoft Fabric Community Forum.
The error "The target principal name is incorrect." indicates an SSL certificate problem with SQL Server.
Please verify if the SQL Server certificate matches the server name used in Power BI Gateway.
Please make sure the latest SQL drivers are installed.
Restart SQL Server and Power BI Gateway services after applying changes.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu