Forum Discussion
ERROR:Powershell script from SQL management studio
olafhelper Thank you for your response.
We want to pull data from different external agencies (about 10+) and each of them have their own VPN credentials. So instead of setting up different VM for each agency we are thinking of have one VPN client on a server and dynamically start (with credentials) and stop the F5 using the PowerShell Script. - this is what we are trying to do.
In your response you mentioned the "no profile" - it we setup a profile, will it work? also how to set the profile. Please share some knowledge on that.
thank you!
we setup a profile, will it work? also how to set the profile.
mstechmach , I wouldn't bet on. Why do you want to find a solution using database engine? I would use a SSIS package or a remote PowerShell solution.
- mstechmachFeb 29, 2024Copper ContributorThank you! I will try it out.