Power BI Gateway issue with SQL Server Type Connection only - after updated to Mar,2025 version

[AmanKalra]

I would like to highlight issue with 3000.262.7 gateway version which we faced recently.

We updated the gateways to Mar,2025 version ( 3000.262.7) and suddenly after some days, SQL Server type connections started showing Offline with below error and also not able to create new connection. I have done the below checks from my side.

• I have already updated the SQL trusted entries in On-Premises gateway files.
• Checked the connectivity in gateway server in PBI Desktop and it is working.

Please suggest solution for this if anyone knows OR if any one come across this.

[AmanKalra]

Hi @V-yubandi-msft @anilelmastasi 

I would like to know whether any user reported any issue in April,2025 gateway version i.e 3000.266.4 because we are going to update our production gateways to Apr version. Looking for if anyone faced any type of issues so far if you know.

Thanks in Advance !

[AmanKalra]

I have updated the gateway software to April,2025 version and it resolved my issue of SQL Server Connection type.

[V-yubandi-msft]

Hi @AmanKalra ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @AmanKalra ,

We haven’t received a response yet and want to ensure the solution met your needs. If you need any further assistance, feel free to reach out we’d be happy to help. If everything is working as expected, kindly mark it as Accepted as solution.

Thank You.

[V-yubandi-msft · Accepted solution]

Hi @AmanKalra ,

In additon to @anilelmastasi  response, Instead of rolling back, you can also upgrade to the latest April 2025 Gateway version (3000.266) which may have addressed this issue.

Currently supported monthly updates to the on-premises data gateways | Microsoft Learn

Thank you for your response @anilelmastasi .

If this solved your issue, please mark it as the accepted solution. 

[anilelmastasi]

Hello @AmanKalra ,

For 3000.262.7, there are some problems.

1- If possible can you rollback to "Feb 2025: 3000.260.11"

2- if your SQL connections use Basic auth or a SQL login, try switching to Windows authentication with a domain account (if possible). The issue seems more prevalent with SQL login-type connections.

3- Some users fixed it by explicitly enabling TLS 1.2 (registry) or disabling older protocols like SSL 3.0 or TLS 1.0 on the gateway machine and SQL server.

If this solved your issue, please mark it as the accepted solution. ✅

[AmanKalra]

Hi @anilelmastasi ,

Thanks for your inputs. Unfortunately changes in TLS didnt work for me. I would like to know, do you or anyone faced any issues in Feb version of gateway so I will uninstall the Mar and install the "Feb 2025: 3000.260.11" gateway version if this resolved the SQL Server type issue.

[anilelmastasi]

Hello @AmanKalra ,

Also @V-yubandi-msft mentioned a new version. You can check that version too.