Forum Discussion
Helper IVCannot create SQL Server datasource connection for on-premises Gateway
Hi duncfair,
If the troubleshooting steps have not resolved the issue, the most appropriate approach is to seek assistance from Microsoft Support.
If you have already raised a support ticket, please wait for further updates from the team as they continue investigating and working on a resolution.
Thanks for using Microsoft Fabric Community Forum.
Helper IVThere is no SQL Server setting like this:
Disable "Force Encryption" in SQL Server to allow connections without mandatory encryption, preventing potential SSL/TLS mismatches with the new gateway.
Community SupportHi duncfair,
Thanks for using Microsoft Fabric Community Forum.
To disable Force Encryption in SQL Server, open SQL Server Configuration Manager, navigate to SQL Server Network Configuration
Click on Protocols for [YourInstanceName], and open Properties.
In the Flags tab, set Force Encryption to No and click OK.
Finally, restart the SQL Server service for the changes to take effect.
This step may help you reslovoing the issue.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thankyou.
- duncfair
Thanks! I was just looking in SSMS.
Anyway, that setting was already set to 'no'.
- v-sgandrathi
Hi duncfair,
If the troubleshooting steps have not resolved the issue, the most appropriate approach is to seek assistance from Microsoft Support.
If you have already raised a support ticket, please wait for further updates from the team as they continue investigating and working on a resolution.
Thanks for using Microsoft Fabric Community Forum.- duncfair
I have had a ticket with Microsoft open for almost 2 weeks...☹️