There is a SQL Server which I have access to but which exists on another domain. I need to run a daily SQL query against one of the databases - I can connect to it using SSMS but when I try to automate the process using powerflow, I get stuck on this gateway setting.
I am choosing the 'Execute a SQL query (V2)' and then choosing 'SQL Server Authentication' which provides the option of Server name, DB name, Username, Password - but then this gateway option wont allow me to go any further? I won't be able to install additional software on the remote server - they won't allow that.
Do I need to do this using a PowerShell command?
How do I automate a daily SQL query?
Thanks.