You’re offline. This is a read only version of the page.
74
Hello, I'm trying to make an automated feed that will send an email when something is changed in the SQL database.
When I insert the trigger, it does not propose any table (see attachment). I do not understand this because if I put the trigger 'when an element is created', my SQL tables are proposed. Can you help me please ?
Hi @AlexandrePicque ,
When working with triggers in SQL connector, one of the limitations is that it doesn’t work for on-premises SQL Server.
So if you are working with on-premises SQL Server, no table can be selected.
Please check the following doc for more details:
https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/
Best regards,
Mabel
Are you connected to on-premise SQL server? First review the Manage your data source - SQL Server documentation and that you've set it up correctly. If so, This is almost certainly a communication issues with the on-premise data gateway.
Please review the Troubleshooting the On-premises data gateway documentation, and also review the Port requirements and the Firewall and proxy documentation and insure that your proxy or firewall allows access over those ports.
Please review both hardware and software firewalls, including the Windows Firewall on the server. Finally, the Tools for troubleshooting section covers collecting logs and Fiddler tracing.
Also, insure that all of the required ports for the connector are always in use and not blocked or filtered by a proxy or firewall. If you'll notice the data gateway port requirements are far more than port 80 and 443:
*.servicebus.windows.net 5671-5672 Used for Advanced Message Queuing Protocol (AMQP). *.servicebus.windows.net 443, 9350-9354 Used by listeners on Service Bus Relay over TCP (requires 443 for access control token acquisition).
For most firewalls, port 80 and 443 are open because they are the HTTP/S ports, however the ports listed above would not be open by default.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
