Assistance Required with SQL Server Standard Mode On-Premises Gateway Connection Error

Thank you Anonymous 

Hi, Pavan_123456789 

The current error is that it is now the default behavior for all PBI desktop and gateway versions that are equal to or higher than the February 2024 release.
You can solve this problem by doing the following:
In the gateway configuration (Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config), you can use a new setting called "SqlTrustedServers" in the same way:

<setting name="SqlTrustedServers" serializeAs="String">
    <value> *spintoptoys,sql*,*.contoso.com</value>
</setting>

This will match the local SQL servers "sqlservertopspintoptoys", "sql-yyz-5", "sqlazure.contoso.com" and "SQL5150.contoso.com ".
Note that wildcards expand only in the server name, not in the domain extension. The example above doesn't match the "SQL33.subsite.contoso.com" example.
Also note that SQL Server instances that require a port number cannot specify the port in the usual way, i.e., "*spintopsql,1443", because a comma indicates the new server name. Instead, add a wildcard at the end, for example: "spintopsql*" or ".contoso.com"

You can refer to the following official documentation:

Power Query SQL Server connector - Power Query | Microsoft Learn

To prevent unexpected errors, you need to back up your gateway profile in advance and work with your IT department to practice this method.

Best Regards

Jianpeng Li

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