Error with SQL Server config data source

[Anonymous]

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?

[v-yuezhe-msft · Accepted 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]

Thanks @v-yuezhe-msft!

Finally we have solved the problem with a rule in the firewall.