How to fix sqlTrigger for azure function

Question

How to fix sqlTrigger for azure function

Sagar Kapadia 0

Failed to start SQL trigger listener for table: 'dbo.ADADAPTED_PAYLOAD', function ID: 'cd373651592ded96'. Exception: System.ArgumentException: Keyword not supported: 'jdbc:sqlserver://maaa-elec-dev-westus-sqlsrv-01.database.windows.net:1433;database'.at Microsoft.Data.Common.DbConnectionOptions.

I am wondering why my jdbc connection string is not working for this sql trigger. is there a specific connection string way I have to use it? such as asp? I am using java for my azure function

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
navba-MSFT 27,540 Reputation points Microsoft Employee Moderator

2023-11-16T03:49:24.67+00:00

@Sagar Kapadia Just following up to check if the below answer helped. If that answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know. I would be happy to help.

1 answer

Your answer

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
navba-MSFT 27,540 Reputation points Microsoft Employee Moderator

2023-11-16T03:49:24.67+00:00

@Sagar Kapadia Just following up to check if the below answer helped. If that answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know. I would be happy to help.

Answer 1

@Sagar Kapadia Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

I understand that you have Azure Function with SQL Trigger which is failing with error: Failed to start SQL trigger listener for table: 'dbo.ADADAPTED_PAYLOAD', function ID: 'cd373651592ded96'. Exception: System.ArgumentException: Keyword not supported: 'jdbc:sqlserver://maaa-elec-dev-westus-sqlsrv-01.database.windows.net:1433;database'.at Microsoft.Data.Common.DbConnectionOptions.

. It seems like the error message you’re seeing is due to the format of the connection string. The Azure SQL trigger listener expects a connection string in a specific format. For an Azure SQL database, the connection string should be in the following format:

.


Server=tcp:{your-server-name}.database.windows.net,1433;Initial Catalog={your-database-name};Persist Security Info=False;User ID={your-user-name};Password={your-password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Please replace {your-server-name}, {your-database-name}, {your-user-name}, and {your-password} with your actual server name, database name, user ID, and password respectively.
.

Please see the limitations and pre-requisites here. Ensure that you have followed it.

.

On a side note: The Azure SQL trigger for Functions is currently in preview and requires that a preview extension library or extension bundle is used. In consumption plan functions, automatic scaling is not available for SQL trigger. Use premium or dedicated plans for scaling benefits with SQL trigger.
.

If you continue to experience issues, I recommend checking the Azure SQL trigger documentation for more information and troubleshooting tips. Hope this helps! Let me know if you have any other questions.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members._

Share via

How to fix sqlTrigger for azure function

1 answer

Your answer