Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone!
I´m having problems with the configuration of a SQL server Data source.
I have the on premise Gateway ready on the server, everything looks OK.
But when I try to configure the data source on the online service, shows me this:
Any idea?
Solved! Go to Solution.
@Anonymous,
Are you able to access SQL Server from the machine that installing gateway? You can install SQL Server Management Studio on the machine to test the connection.
In addition, please configure remote setting for your SQL Server following the guide in this blog, also add your SQL TCP port and UDP port into inbound rule of your firewall, for more details, please review this blog.
Regards,
Lydia
@Anonymous,
Are you able to access SQL Server from the machine that installing gateway? You can install SQL Server Management Studio on the machine to test the connection.
In addition, please configure remote setting for your SQL Server following the guide in this blog, also add your SQL TCP port and UDP port into inbound rule of your firewall, for more details, please review this blog.
Regards,
Lydia
Thanks @v-yuezhe-msft!
Finally we have solved the problem with a rule in the firewall.