You’re offline. This is a read only version of the page.
Announcements
14
Please help I am unable to get the starting action to run using when an item is created sql trigger.
Hi @AYOBAMIO !
As shown above there are different ways in how to connect to the SQL server. Here, I will give you detailed steps for "Windows Authentication".
Prerequisites:
1. Make sure you have SSMS installed. If not, follow this video from Youtube: https://youtu.be/_rgHDiaJBds?si=L0ZnL2JCpPxutcav for first 2 mins to get it installed. It's Anders Jensen video 🙂
2. Since a gateway is required, follow the steps in this link: https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Once both have been done, open the SSMS, connect, create a database, in that create a table and save it. Now as can be seen from above image, you need the SQL server name, database name, username, password and gateway. For the first one, you can get it by opening the "Microsoft SQL Server Management Studio" (if installed in step 1 of prerequisites).
From above image, you will get the SQL server name (copy the same but with no caps). Done 1/5.
Click connect, and see your databases as below example: So it will be "BLACKLIST". Done 2/5
Open "cmd" (Command Prompt) and type in 'whoami' command. This will display a username associated with the effective user ID. This is your username. Done 3/5.
Password will be the one you enter into your system. Done 4/5.
Gateway will already be done in step 2 of prerequisites. It will come in as a dropdown as shown below:
Done 5/5.
Next, go back to your automated cloud flow, copy each details from above into the respective fields and it should finally connect for you.
Result:
Incase if using Azure or SQL Server Authentication, follow this video: https://www.youtube.com/watch?v=kMzJKcxbRrc&t=515s
I hope this helps.
Regards,
Nathan Alvares
----------------------------------------------------------------------------------------------------------------------------------------
If this helps & solves your problem, please remember to give a "Thumbs up" and "Accept my solution" as it will help others in the future.
Share
Report
All responses (
Answers (
