@billf24
The error message you're encountering may stem from several potential issues related to your data source connectivity:
1. Confirm the Gateway Connection: Double-check that your gateway is online and in a good state. You can do this by logging into the Power Platform admin center, selecting "Data Gateways", and then checking the status of your gateway.
2. Check the Data Source Configuration: Ensure the data source is properly set up within the gateway. From the same admin center, you can manage your data sources under the respective gateway.
3. Credentials Verification: Double-check your credentials. Sometimes, the error occurs due to incorrect username/password, or you might need to use a different authentication method.
4. Firewall or Network Restrictions: Your network may have restrictions that prevent the connection to your SQL Server. Make sure the necessary ports are open and that your SQL Server is accessible from the machine where the gateway is installed.
5. Encryption Setting: Even though you mentioned you've tried unchecking the encrypted connection, do ensure this setting matches what your SQL Server is expecting. If your SQL Server doesn't support encrypted connections, this could be causing the issue.
6. SQL Server Configuration: Verify that your SQL Server is configured to accept remote connections.
7. Software Updates: Ensure that your gateway is updated to the latest version. Sometimes, connectivity issues
Check if any of this helps @billf24
