Question 362269 in Azure Question posted in
The official documentation to get you started can be found here.

Is Azure SQL trigger for Functions is generally available for SQL Server hosted on Azure VM

I see that the Azure SQL trigger is now generally available on Azure SQL Database.

Here is the link: https://azure.microsoft.com/en-us/updates/general-availability-azure-sql-updates-for-latejanuary-2024/

Is it also generally available for SQL Server hosted on Azure VM?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Here is the link to the answer


  2. 0

    Thanks for the solution @AnuragSingh-MSFT.

    As mentioned in the above MSDOC Q&A, Azure SQL trigger for Functions is available for SQL Server hosted on Azure VM.

    1. Create a Virtual Machine with SQL Server Image.

    enter image description here

    1. Go to SQL Server Settings, Select Public(Internet) in the SQL Connectivity and note the port for further use.
    2. Enable SQL Authentication and Review+Create.

    enter image description here

    1. Navigate to Overview of VM, copy the Public IP address of your SQL Server VM.

    2. Open SQL Server Management Studio (SSMS), go to connect=>Connect to Database Engine, enter VM’s public IP address with port (1433, which was specified during the creation of VM) in the Server name field. For example, 11.22.33.444,1401.

    3. In the Authentication section, select SQL Server Authentication, enter username and password and Connect.

    4. Connect to the VM remotely using RDP.

    enter image description here

    Refer Connect to SQL Server MSDOC to ensure that you are able to connect to SQL Server with these values.

    1. Once you are able to connect to the SQL DB from SQL Server Management Studio, Refer MSDOC, to use these values to create Connection URL and use it in the Azure Function.

    General form of connection URL:

    jdbc:sqlserver://[serverName[instanceName][:portNumber]][;property=value[;property=value]]

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search