Create SQL connection in Power Automate with simple steps
Many of the times, we want to create SQL connection in Power Automate to execute SQL statements and fetch data from SQL so that we can re-utilize the same in either Power Automate or Power Apps .
We would have experienced difficulty in getting the data for the fields like SQL server details, data base details and establishing the authentication mechanism especially when we are connecting to SQL server using on-prem gateway.
To ease this I am sharing the steps that I have found over a period of time that will help in retrieving the data quickly by executing few commands.
Fetch SQL server details
To fetch the SQL server details execute the command to retrieve the information
Fetch SQL database details
To fetch the SQL database details execute the command to retrieve the information
Fetch windows domain name
To retrieve the windows domain name information we should execute few commands in command prompt
To retrieve the windows username information execute the below command in Command Prompt
Finally, you can enter the windows password to successfully create the connection from Power Automate to SQL server.
Hope these steps help you ease the process of successful authentication the next time you try to connect to SQL from Power Automate or Power Apps.